APPS.INV_MGD_MVT_PO_MDTR dependencies on CST_ITEM_COSTS_FOR_GL_VIEW

Line 412: --, CST_ITEM_COSTS_FOR_GL_VIEW cst

408: , RCV_SHIPMENT_HEADERS rsh
409: , RCV_SHIPMENT_LINES rsl
410: , PO_HEADERS_ALL poh
411: , PO_LINES_ALL pol
412: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
413: WHERE po.shipment_header_id = rsh.shipment_header_id
414: AND rsh.shipment_header_id = rsl.shipment_header_id
415: AND po.shipment_line_id = rsl.shipment_line_id
416: AND po.po_line_id = pol.po_line_id

Line 437: CST_ITEM_COSTS_FOR_GL_VIEW

433: CURSOR c_item_cost IS
434: SELECT
435: item_cost
436: FROM
437: CST_ITEM_COSTS_FOR_GL_VIEW
438: WHERE organization_id = x_movement_transaction.organization_id
439: AND inventory_item_id = x_movement_transaction.inventory_item_id;
440:
441: CURSOR l_adj IS

Line 751: --, CST_ITEM_COSTS_FOR_GL_VIEW cst

747: , OE_ORDER_LINES_ALL oola
748: , HZ_PARTIES rac
749: , HZ_CUST_ACCOUNTS hzc
750: , MTL_SYSTEM_ITEMS si
751: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
752: WHERE ooha.header_id = oola.header_id
753: AND oola.inventory_item_id = si.inventory_item_id
754: AND oola.ship_from_org_id = si.organization_id
755: AND rac.party_id = hzc.party_id

Line 766: CST_ITEM_COSTS_FOR_GL_VIEW cst

762: CURSOR c_item_cost IS
763: SELECT
764: cst.item_cost
765: FROM
766: CST_ITEM_COSTS_FOR_GL_VIEW cst
767: , oe_order_lines_all oola
768: WHERE cst.organization_id = oola.ship_from_org_id
769: AND cst.inventory_item_id = oola.inventory_item_id
770: AND oola.line_id = x_movement_transaction.order_line_id;

Line 1288: --, CST_ITEM_COSTS_FOR_GL_VIEW cst

1284: , RCV_SHIPMENT_LINES rsl
1285: , OE_ORDER_HEADERS_ALL ooha
1286: , OE_ORDER_LINES_ALL oola
1287: --, MTL_SYSTEM_ITEMS si
1288: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
1289: WHERE po.shipment_header_id = rsh.shipment_header_id
1290: AND rsh.shipment_header_id = rsl.shipment_header_Id
1291: AND po.shipment_line_id = rsl.shipment_line_id
1292: AND po.oe_order_header_id = ooha.header_id

Line 1306: CST_ITEM_COSTS_FOR_GL_VIEW

1302: CURSOR c_item_cost IS
1303: SELECT
1304: item_cost
1305: FROM
1306: CST_ITEM_COSTS_FOR_GL_VIEW
1307: WHERE organization_id = x_movement_transaction.organization_id
1308: AND inventory_item_id = x_movement_transaction.inventory_item_id;
1309:
1310: /*CURSOR l_uom IS

Line 1657: --, CST_ITEM_COSTS_FOR_GL_VIEW cst

1653: FROM
1654: RCV_TRANSACTIONS rcv
1655: , RCV_SHIPMENT_HEADERS rsh
1656: , RCV_SHIPMENT_LINES rsl
1657: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
1658: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1659: AND rsh.shipment_header_id = rsl.shipment_header_id
1660: AND rcv.shipment_line_id = rsl.shipment_line_id
1661: --AND rsl.to_organization_id = cst.organization_id (+)

Line 1719: CST_ITEM_COSTS_FOR_GL_VIEW

1715: CURSOR c_item_cost IS
1716: SELECT
1717: item_cost
1718: FROM
1719: CST_ITEM_COSTS_FOR_GL_VIEW
1720: WHERE organization_id = x_movement_transaction.organization_id
1721: AND inventory_item_id = x_movement_transaction.inventory_item_id;
1722:
1723: BEGIN