DBA Data[Home] [Help]

APPS.CSTPPIPV dependencies on MTL_ITEM_CATEGORIES

Line 106: FROM mtl_item_categories mic

102: )
103: OR (p_item_option = 5
104: AND EXISTS
105: ( SELECT 'X'
106: FROM mtl_item_categories mic
107: WHERE mic.organization_id =
108: cql.organization_id
109: AND mic.category_id =
110: p_category_id

Line 826: FROM mtl_item_categories mic,

822: AND msi.outside_operation_flag = 'Y' and rownum <2 ) )
823: OR ( l_item_option = 5 -- Category items
824: AND EXISTS (
825: SELECT 'X'
826: FROM mtl_item_categories mic,
827: mtl_system_items_b msi
828: WHERE mic.organization_id = p_organization_id
829: AND mic.category_id = p_category_id
830: AND mic.category_set_id = p_category_set_id