DBA Data[Home] [Help]

APPS.CTO_UPDATE_ITEMS_PK dependencies on CTO_CUSTOM_CATEGORY_PK

Line 2281: and CTO_CUSTOM_CATEGORY_PK.Copy_Category (ic.category_set_id , ic.organization_id) = 1

2277: and ic.inventory_item_id = bcolu.inventory_item_id
2278: and ic.organization_id = bcso.organization_id
2279: and bcso.model_item_id = ic.inventory_item_id
2280: and bcso.line_id = bcolu.line_id
2281: and CTO_CUSTOM_CATEGORY_PK.Copy_Category (ic.category_set_id , ic.organization_id) = 1
2282: and NOT EXISTS
2283: (select /*+ NO_UNNEST PUSH_SUBQ */ NULL
2284: from MTL_ITEM_CATEGORIES ic1
2285: where ic1.inventory_item_id = bcolu.config_item_id

Line 2407: and CTO_CUSTOM_CATEGORY_PK.Copy_Category (ic.category_set_id , ic.organization_id) = 1

2403: and ic.organization_id = bcso.organization_id
2404: and ic.category_id <> p_cat_id -- CTO category
2405: and bcso.model_item_id = ic.inventory_item_id
2406: and bcso.line_id = bcolu.line_id
2407: and CTO_CUSTOM_CATEGORY_PK.Copy_Category (ic.category_set_id , ic.organization_id) = 1
2408: and NOT EXISTS
2409: (select /*+ NO_UNNEST PUSH_SUBQ */ NULL
2410: from MTL_ITEM_CATEGORIES ic1
2411: where ic1.inventory_item_id = bcolu.config_item_id