APPS.CSTPPIPV dependencies on MTL_SYSTEM_ITEMS

Line 554: mtl_system_items msi

550: cavh.var_amount,
551: p_adj_account,
552: 'PO Distribution: '|| TO_CHAR (cavh.po_distribution_id)
553: FROM cst_ap_variance_headers cavh,
554: mtl_system_items msi
555: WHERE cavh.batch_id = l_batch_id
556: AND cavh.var_amount <> 0
557: AND cavh.inventory_item_id = msi.inventory_item_id
558: AND cavh.organization_id = msi.organization_id

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: )