DBA Data[Home] [Help]

APPS.INVUPD2B dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 6111: from mtl_default_category_sets d

6107: rec.organization_id
6108: from mtl_category_sets s
6109: where s.category_set_id in
6110: ( select d.category_set_id
6111: from mtl_default_category_sets d
6112: where (d.functional_area_id =
6113: decode(rec.INVENTORY_ITEM_FLAG,'Y',1,0)
6114: or d.functional_area_id =
6115: decode(rec.PURCHASING_ITEM_FLAG,'Y',2,0)

Line 6215: from mtl_default_category_sets d

6211: and mp.organization_id <> mp.master_organization_id
6212: and s.default_category_id IS NOT NULL --Bug: 2801594
6213: and s.category_set_id in
6214: ( select d.category_set_id
6215: from mtl_default_category_sets d
6216: where d.functional_area_id =
6217: decode( rec.INTERNAL_ORDER_FLAG, 'Y', 11, 0 )
6218: or d.functional_area_id =
6219: decode( rec.CUSTOMER_ORDER_FLAG, 'Y', 11, 0 )

Line 6286: from mtl_default_category_sets d

6282: from mtl_category_sets s
6283: where s.default_category_id IS NOT NULL --Bug: 2801594
6284: and s.category_set_id in
6285: ( select d.category_set_id
6286: from mtl_default_category_sets d
6287: where d.functional_area_id =
6288: decode( rec.INTERNAL_ORDER_FLAG, 'Y', 11, 0 )
6289: or d.functional_area_id =
6290: decode( rec.CUSTOMER_ORDER_FLAG, 'Y', 11, 0 )