DBA Data[Home] [Help]

APPS.INVPPROC dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 1446: FROM mtl_default_category_sets d

1442: AND s.organization_id = Cat_Assign_Rec.MORG
1443: AND (d.control_level = 1
1444: OR EXISTS
1445: ( SELECT 'x'
1446: FROM mtl_default_category_sets d
1447: WHERE
1448: d.category_set_id = s.category_set_id
1449: AND
1450: (d.functional_area_id = DECODE( Cat_Assign_Rec.INVFLAG, 'Y', 1, 0 )

Line 1529: ,mtl_default_category_sets d

1525: ,prg_id -- program_id
1526: ,l_sysdate -- program_update_date
1527: ,req_id -- request_id
1528: FROM mtl_system_items_interface m
1529: ,mtl_default_category_sets d
1530: ,mtl_category_sets_b s
1531: WHERE
1532: m.transaction_type = 'CREATE'
1533: AND m.process_flag = l_process_flag_4

Line 1604: ,mtl_default_category_sets mdcs

1600: ,prg_id -- program_id
1601: ,l_sysdate -- program_update_date
1602: ,req_id -- request_id
1603: FROM mtl_system_items_interface msi
1604: ,mtl_default_category_sets mdcs
1605: ,mtl_category_sets_b mcs
1606: ,mtl_parameters mp
1607: WHERE
1608: msi.transaction_type = 'CREATE'