Thursday, October 28, 2021

Query to get Approval Control Limits in Approval Hierarchy-Oracle APPS

SELECT pcr.control_group_id,
         pcga.control_group_name
         rule_type_code,
         object_code,
         amount_limit,
         segment1_low,
         segment1_high,
         segment2_low,
         segment2_high,
         segment3_low,
         segment3_high,
         segment4_low,
         segment4_high,
         segment5_low,
         segment5_high,
         segment6_low,
         segment6_high,
         segment7_low,
         segment7_high,
         segment8_low,
         segment8_high,
         segment9_low,
         segment9_high,
         segment10_low,
         segment10_high
    FROM po_control_rules pcr
    ,po_control_groups_all pcga
   WHERE pcga.control_group_id = pcr.control_group_id

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)