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

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...