APPS.INV_MGD_MVT_PO_MDTR dependencies on MTL_SYSTEM_ITEMS

Line 786: , MTL_SYSTEM_ITEMS si

782: OE_ORDER_HEADERS_ALL ooha
783: , OE_ORDER_LINES_ALL oola
784: , HZ_PARTIES rac
785: , HZ_CUST_ACCOUNTS hzc
786: , MTL_SYSTEM_ITEMS si
787: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
788: WHERE ooha.header_id = oola.header_id
789: AND oola.inventory_item_id = si.inventory_item_id
790: AND oola.ship_from_org_id = si.organization_id

Line 1349: SELECT DISTINCT 'CONFIG' FROM mtl_system_items

1345: l_return_status VARCHAR2(1);
1346: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1347: l_So_line_Id NUMBER;
1348: CURSOR l_rma_config IS
1349: SELECT DISTINCT 'CONFIG' FROM mtl_system_items
1350: WHERE inventory_item_id=x_movement_transaction.inventory_item_id
1351: AND auto_created_config_flag='Y'
1352: AND base_item_id IS NOT null;
1353: /*End bug 8435314 */

Line 1391: --, MTL_SYSTEM_ITEMS si

1387: , RCV_SHIPMENT_HEADERS rsh
1388: , RCV_SHIPMENT_LINES rsl
1389: , OE_ORDER_HEADERS_ALL ooha
1390: , OE_ORDER_LINES_ALL oola
1391: --, MTL_SYSTEM_ITEMS si
1392: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
1393: WHERE po.shipment_header_id = rsh.shipment_header_id
1394: AND rsh.shipment_header_id = rsl.shipment_header_Id
1395: AND po.shipment_line_id = rsl.shipment_line_id