eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MGD_MVT_PO_MDTR dependencies on CST_ITEM_COSTS_FOR_GL_VIEW

Line 418: --, CST_ITEM_COSTS_FOR_GL_VIEW cst

414: , RCV_SHIPMENT_HEADERS rsh
415: , RCV_SHIPMENT_LINES rsl
416: , PO_HEADERS_ALL poh
417: , PO_LINES_ALL pol
418: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
419: WHERE po.shipment_header_id = rsh.shipment_header_id
420: AND rsh.shipment_header_id = rsl.shipment_header_id
421: AND po.shipment_line_id = rsl.shipment_line_id
422: AND po.po_line_id = pol.po_line_id

Line 443: CST_ITEM_COSTS_FOR_GL_VIEW

439: CURSOR c_item_cost IS
440: SELECT
441: item_cost
442: FROM
443: CST_ITEM_COSTS_FOR_GL_VIEW
444: WHERE organization_id = x_movement_transaction.organization_id
445: AND inventory_item_id = x_movement_transaction.inventory_item_id;
446:
447: CURSOR l_adj IS

Line 787: --, CST_ITEM_COSTS_FOR_GL_VIEW cst

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
791: AND rac.party_id = hzc.party_id

Line 803: CST_ITEM_COSTS_FOR_GL_VIEW cst

799: CURSOR c_item_cost IS
800: SELECT
801: cst.item_cost
802: FROM
803: CST_ITEM_COSTS_FOR_GL_VIEW cst
804: , oe_order_lines_all oola
805: WHERE cst.organization_id = oola.ship_from_org_id
806: AND cst.inventory_item_id = oola.inventory_item_id
807: AND oola.line_id = x_movement_transaction.order_line_id;

Line 816: CST_ITEM_COSTS_FOR_GL_VIEW cst

812: CURSOR c_item_cost IS
813: SELECT
814: cst.item_cost
815: FROM
816: CST_ITEM_COSTS_FOR_GL_VIEW cst
817: WHERE cst.organization_id = l_ship_from_org_id
818: AND cst.inventory_item_id = x_movement_transaction.inventory_item_id;
819:
820: BEGIN

Line 1392: --, CST_ITEM_COSTS_FOR_GL_VIEW cst

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
1396: AND po.oe_order_header_id = ooha.header_id

Line 1410: CST_ITEM_COSTS_FOR_GL_VIEW

1406: CURSOR c_item_cost IS
1407: SELECT
1408: item_cost
1409: FROM
1410: CST_ITEM_COSTS_FOR_GL_VIEW
1411: WHERE organization_id = x_movement_transaction.organization_id
1412: AND inventory_item_id = x_movement_transaction.inventory_item_id;
1413:
1414: /*CURSOR l_uom IS

Line 1816: --, CST_ITEM_COSTS_FOR_GL_VIEW cst

1812: FROM
1813: RCV_TRANSACTIONS rcv
1814: , RCV_SHIPMENT_HEADERS rsh
1815: , RCV_SHIPMENT_LINES rsl
1816: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
1817: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1818: AND rsh.shipment_header_id = rsl.shipment_header_id
1819: AND rcv.shipment_line_id = rsl.shipment_line_id
1820: --AND rsl.to_organization_id = cst.organization_id (+)

Line 1880: CST_ITEM_COSTS_FOR_GL_VIEW

1876: CURSOR c_item_cost IS
1877: SELECT
1878: item_cost
1879: FROM
1880: CST_ITEM_COSTS_FOR_GL_VIEW
1881: WHERE organization_id = x_movement_transaction.organization_id
1882: AND inventory_item_id = x_movement_transaction.inventory_item_id;
1883:
1884: BEGIN