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.

[Home] [Help]

APPS.INV_MGD_MVT_PO_MDTR dependencies on OE_ORDER_LINES_ALL

Line 747: , OE_ORDER_LINES_ALL oola

743: , rac.party_name
744: , rac.party_number
745: FROM
746: OE_ORDER_HEADERS_ALL ooha
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

Line 767: , oe_order_lines_all oola

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;
771:

Line 1120: , oe_order_lines_all oola

1116: , rcv.subinventory
1117: , rcv.mvt_stat_status -- 7165989
1118: FROM
1119: RCV_TRANSACTIONS rcv
1120: , oe_order_lines_all oola
1121: WHERE rcv.oe_order_line_id = oola.line_id
1122: AND rcv.mvt_stat_status IN ('NEW', 'FORDISP', 'FORARVL') -- 7165989 Changes for RMA triangulation
1123: AND rcv.transaction_type IN ('DELIVER')
1124: AND rcv.source_document_code = 'RMA'

Line 1170: , oe_order_lines_all oola

1166: , rcv.mvt_stat_status -- 7165989
1167: FROM
1168: RCV_TRANSACTIONS rcv
1169: , RCV_SHIPMENT_HEADERS rsh
1170: , oe_order_lines_all oola
1171: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1172: AND rcv.oe_order_line_id = oola.line_id
1173: AND rsh.receipt_num = p_movement_transaction.receipt_num
1174: AND rcv.mvt_stat_status IN ('NEW', 'FORDISP', 'FORARVL') -- 7165989 Changes for RMA triangulation

Line 1247: l_order_uom OE_ORDER_LINES_ALL.Pricing_Quantity_Uom%TYPE;

1243: )
1244: IS
1245: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
1246: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1247: l_order_uom OE_ORDER_LINES_ALL.Pricing_Quantity_Uom%TYPE;
1248: l_uom_conv_rate NUMBER;
1249: l_unit_price NUMBER;
1250: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_RMA_Details';
1251:

Line 1286: , OE_ORDER_LINES_ALL oola

1282: RCV_TRANSACTIONS po
1283: , RCV_SHIPMENT_HEADERS rsh
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

Line 1622: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;

1618: IS
1619: l_unit_of_measure rcv_transactions.unit_of_measure%TYPE;
1620: l_transport_mode mtl_movement_statistics.transport_mode%TYPE;
1621: l_document_unit_price mtl_movement_statistics.document_unit_price%TYPE;
1622: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1623: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;
1624:
1625: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1626: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;

Line 1625: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;

1621: l_document_unit_price mtl_movement_statistics.document_unit_price%TYPE;
1622: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1623: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;
1624:
1625: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1626: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1627: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
1628: l_error_code NUMBER;
1629: l_return_status VARCHAR2(1);

Line 1626: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;

1622: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1623: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;
1624:
1625: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1626: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1627: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
1628: l_error_code NUMBER;
1629: l_return_status VARCHAR2(1);
1630: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_IO_Arrival_Details';

Line 1692: , OE_ORDER_LINES_ALL oola

1688: WSH_NEW_DELIVERIES_OB_GRP_V wnd
1689: , wsh_delivery_assignments_v wda
1690: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
1691: , OE_ORDER_HEADERS_ALL ooha
1692: , OE_ORDER_LINES_ALL oola
1693: , HZ_PARTIES rac
1694: , HZ_CUST_ACCOUNTS hzc
1695: WHERE wnd.delivery_id = wda.delivery_id
1696: AND wda.delivery_detail_id = wdd.delivery_detail_id