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 802: FROM mtl_item_categories mic,

798: AND msi.outside_operation_flag = 'Y' and rownum <2 ) )
799: OR ( l_item_option = 5 -- Category items
800: AND EXISTS (
801: SELECT 'X'
802: FROM mtl_item_categories mic,
803: mtl_system_items_b msi
804: WHERE mic.organization_id = p_organization_id
805: AND mic.category_id = p_category_id
806: AND mic.category_set_id = p_category_set_id