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 the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...