DBA Data[Home] [Help]

APPS.INVUPD2B dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 5797: from mtl_default_category_sets d

5793: rec.organization_id
5794: from mtl_category_sets s
5795: where s.category_set_id in
5796: ( select d.category_set_id
5797: from mtl_default_category_sets d
5798: where (d.functional_area_id =
5799: decode(rec.INVENTORY_ITEM_FLAG,'Y',1,0)
5800: or d.functional_area_id =
5801: decode(rec.PURCHASING_ITEM_FLAG,'Y',2,0)

Line 5886: from mtl_default_category_sets d

5882: )
5883: AND s.default_category_id IS NOT NULL --Bug: 2801594
5884: and s.category_set_id in
5885: ( select d.category_set_id
5886: from mtl_default_category_sets d
5887: where d.functional_area_id =
5888: decode( rec.INTERNAL_ORDER_FLAG, 'Y', 11, 0 )
5889: or d.functional_area_id =
5890: decode( rec.CUSTOMER_ORDER_FLAG, 'Y', 11, 0 )