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 Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...