DBA Data[Home] [Help]

APPS.INVPPROC dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 1530: FROM mtl_default_category_sets d

1526: AND s.organization_id = Cat_Assign_Rec.MORG
1527: AND (d.control_level = 1
1528: OR EXISTS
1529: ( SELECT 'x'
1530: FROM mtl_default_category_sets d
1531: WHERE
1532: d.category_set_id = s.category_set_id
1533: AND
1534: (d.functional_area_id = DECODE( Cat_Assign_Rec.INVFLAG, 'Y', 1, 0 )

Line 1613: ,mtl_default_category_sets d

1609: ,prg_id -- program_id
1610: ,l_sysdate -- program_update_date
1611: ,req_id -- request_id
1612: FROM mtl_system_items_interface m
1613: ,mtl_default_category_sets d
1614: ,mtl_category_sets_b s
1615: WHERE
1616: m.transaction_type = 'CREATE'
1617: AND m.process_flag = l_process_flag_4

Line 1690: ,mtl_default_category_sets mdcs

1686: ,prg_id -- program_id
1687: ,l_sysdate -- program_update_date
1688: ,req_id -- request_id
1689: FROM mtl_system_items_interface msi
1690: ,mtl_default_category_sets mdcs
1691: ,mtl_category_sets_b mcs
1692: ,mtl_parameters mp
1693: WHERE
1694: msi.transaction_type = 'CREATE'