APPS.CSTPPIPV dependencies on MTL_SYSTEM_ITEMS_B

Line 787: FROM mtl_system_items_b msi

783: OR p_item_type = 2) -- OSP only
784: AND ( ( l_item_option = 1 -- All items
785: AND EXISTS (
786: SELECT 'X'
787: FROM mtl_system_items_b msi
788: WHERE msi.organization_id = p_organization_id
789: AND msi.inventory_item_id = pla.item_id
790: AND msi.outside_operation_flag = 'Y' and rownum <2) )
791: OR ( l_item_option = 2 -- Specific item

Line 794: FROM mtl_system_items_b msi

790: AND msi.outside_operation_flag = 'Y' and rownum <2) )
791: OR ( l_item_option = 2 -- Specific item
792: AND EXISTS (
793: SELECT 'X'
794: FROM mtl_system_items_b msi
795: WHERE msi.organization_id = p_organization_id
796: AND msi.inventory_item_id = p_specific_item_id
797: AND msi.inventory_item_id = pla.item_id
798: AND msi.outside_operation_flag = 'Y' and rownum <2 ) )

Line 803: mtl_system_items_b msi

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
807: AND mic.inventory_item_id = msi.inventory_item_id

Line 816: FROM mtl_system_items_b msi

812: OR p_item_type = 3) -- direct only
813: AND ( pla.item_id IS NULL
814: OR EXISTS (
815: SELECT 'X'
816: FROM mtl_system_items_b msi
817: WHERE msi.organization_id = p_organization_id
818: AND msi.inventory_item_id = pla.item_id
819: AND msi.stock_enabled_flag = 'N'
820: )