DBA Data[Home] [Help]

APPS.INV_MGD_MVT_PO_MDTR dependencies on OE_ORDER_LINES_ALL

Line 783: , OE_ORDER_LINES_ALL oola

779: --, rac.party_number
780: , hzc.account_number
781: FROM
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

Line 804: , oe_order_lines_all oola

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;
808: */

Line 1199: , oe_order_lines_all oola

1195: , rcv.subinventory
1196: , rcv.mvt_stat_status -- 7165989
1197: FROM
1198: RCV_TRANSACTIONS rcv
1199: , oe_order_lines_all oola
1200: , hr_organization_information hoi /*Bug 8467743*/
1201: WHERE rcv.oe_order_line_id = oola.line_id
1202: AND rcv.mvt_stat_status IN ('NEW', 'FORDISP', 'FORARVL') -- 7165989 Changes for RMA triangulation
1203: AND rcv.transaction_type IN ('DELIVER')

Line 1254: , oe_order_lines_all oola

1250: , rcv.mvt_stat_status -- 7165989
1251: FROM
1252: RCV_TRANSACTIONS rcv
1253: , RCV_SHIPMENT_HEADERS rsh
1254: , oe_order_lines_all oola
1255: , hr_organization_information hoi /*Bug 8467743*/
1256: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1257: AND rcv.oe_order_line_id = oola.line_id
1258: AND rsh.receipt_num = p_movement_transaction.receipt_num

Line 1336: l_order_uom OE_ORDER_LINES_ALL.Pricing_Quantity_Uom%TYPE;

1332: )
1333: IS
1334: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
1335: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1336: l_order_uom OE_ORDER_LINES_ALL.Pricing_Quantity_Uom%TYPE;
1337: l_uom_conv_rate NUMBER;
1338: l_unit_price NUMBER;
1339: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_RMA_Details';
1340:

Line 1342: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;

1338: l_unit_price NUMBER;
1339: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_RMA_Details';
1340:
1341: /*bug 8435314 Add logic for config Item in RMA*/
1342: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1343: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
1344: l_error_code NUMBER;
1345: l_return_status VARCHAR2(1);
1346: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;

Line 1346: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;

1342: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1343: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
1344: l_error_code NUMBER;
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

Line 1390: , OE_ORDER_LINES_ALL oola

1386: RCV_TRANSACTIONS po
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

Line 1781: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;

1777: IS
1778: l_unit_of_measure rcv_transactions.unit_of_measure%TYPE;
1779: l_transport_mode mtl_movement_statistics.transport_mode%TYPE;
1780: l_document_unit_price mtl_movement_statistics.document_unit_price%TYPE;
1781: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1782: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;
1783:
1784: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1785: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;

Line 1784: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;

1780: l_document_unit_price mtl_movement_statistics.document_unit_price%TYPE;
1781: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1782: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;
1783:
1784: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1785: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1786: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
1787: l_error_code NUMBER;
1788: l_return_status VARCHAR2(1);

Line 1785: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;

1781: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1782: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;
1783:
1784: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1785: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1786: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
1787: l_error_code NUMBER;
1788: l_return_status VARCHAR2(1);
1789: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_IO_Arrival_Details';

Line 1853: , OE_ORDER_LINES_ALL oola

1849: WSH_NEW_DELIVERIES_OB_GRP_V wnd
1850: , wsh_delivery_assignments_v wda
1851: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
1852: , OE_ORDER_HEADERS_ALL ooha
1853: , OE_ORDER_LINES_ALL oola
1854: , HZ_PARTIES rac
1855: , HZ_CUST_ACCOUNTS hzc
1856: WHERE wnd.delivery_id = wda.delivery_id
1857: AND wda.delivery_detail_id = wdd.delivery_detail_id