APPS.CSTPPIPV dependencies on MTL_SYSTEM_ITEMS

Line 578: mtl_system_items msi

574: cavh.var_amount,
575: p_adj_account,
576: 'PO Distribution: '|| TO_CHAR (cavh.po_distribution_id)
577: FROM cst_ap_variance_headers cavh,
578: mtl_system_items msi
579: WHERE cavh.batch_id = l_batch_id
580: AND cavh.var_amount <> 0
581: AND cavh.inventory_item_id = msi.inventory_item_id
582: AND cavh.organization_id = msi.organization_id

Line 811: FROM mtl_system_items_b msi

807: OR p_item_type = 2) -- OSP only
808: AND ( ( l_item_option = 1 -- All items
809: AND EXISTS (
810: SELECT 'X'
811: FROM mtl_system_items_b msi
812: WHERE msi.organization_id = p_organization_id
813: AND msi.inventory_item_id = pla.item_id
814: AND msi.outside_operation_flag = 'Y' and rownum <2) )
815: OR ( l_item_option = 2 -- Specific item

Line 818: FROM mtl_system_items_b msi

814: AND msi.outside_operation_flag = 'Y' and rownum <2) )
815: OR ( l_item_option = 2 -- Specific item
816: AND EXISTS (
817: SELECT 'X'
818: FROM mtl_system_items_b msi
819: WHERE msi.organization_id = p_organization_id
820: AND msi.inventory_item_id = p_specific_item_id
821: AND msi.inventory_item_id = pla.item_id
822: AND msi.outside_operation_flag = 'Y' and rownum <2 ) )

Line 827: mtl_system_items_b msi

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

Line 840: FROM mtl_system_items_b msi

836: OR p_item_type = 3) -- direct only
837: AND ( pla.item_id IS NULL
838: OR EXISTS (
839: SELECT 'X'
840: FROM mtl_system_items_b msi
841: WHERE msi.organization_id = p_organization_id
842: AND msi.inventory_item_id = pla.item_id
843: AND msi.stock_enabled_flag = 'N'
844: )