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_SO_MDTR dependencies on OE_ORDER_LINES_ALL

Line 100: , OE_ORDER_LINES_ALL ol

96: WSH_NEW_DELIVERIES_OB_GRP_V wnd
97: , wsh_delivery_assignments_v wda
98: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
99: , hr_organization_information hoi
100: , OE_ORDER_LINES_ALL ol
101: , OE_ORDER_HEADERS_ALL oh
102: , HZ_CUST_SITE_USES_ALL ras
103: WHERE wnd.delivery_id = wda.delivery_id
104: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 136: , OE_ORDER_LINES_ALL ol

132: WSH_NEW_DELIVERIES_OB_GRP_V wnd
133: , wsh_delivery_assignments_v wda
134: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
135: , hr_organization_information hoi
136: , OE_ORDER_LINES_ALL ol
137: , OE_ORDER_HEADERS_ALL oh
138: , HZ_CUST_SITE_USES_ALL ras
139: WHERE wnd.delivery_id = wda.delivery_id
140: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 171: , OE_ORDER_LINES_ALL ol

167: FROM
168: WSH_NEW_DELIVERIES_OB_GRP_V wnd
169: , wsh_delivery_assignments_v wda
170: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
171: , OE_ORDER_LINES_ALL ol
172: , OE_ORDER_HEADERS_ALL oh
173: , HZ_CUST_SITE_USES_ALL ras
174: , hr_organization_information hoi
175: WHERE wnd.delivery_id = wda.delivery_id

Line 284: , OE_ORDER_LINES_ALL ol

280: FROM
281: WSH_NEW_DELIVERIES_OB_GRP_V wnd
282: , wsh_delivery_assignments_v wda
283: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
284: , OE_ORDER_LINES_ALL ol
285: WHERE wnd.delivery_id = wda.delivery_id
286: AND wda.delivery_detail_id = wdd.delivery_detail_id
287: AND wdd.source_line_id = ol.line_id
288: AND wdd.source_code = 'OE'

Line 378: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;

374: )
375:
376: IS
377: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
378: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
379: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
380: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
381: l_error_code NUMBER;
382: l_return_status VARCHAR2(1);

Line 379: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;

375:
376: IS
377: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
378: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
379: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
380: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
381: l_error_code NUMBER;
382: l_return_status VARCHAR2(1);
383: l_item_type_code oe_order_lines_all.item_type_code%TYPE;

Line 383: l_item_type_code oe_order_lines_all.item_type_code%TYPE;

379: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
380: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
381: l_error_code NUMBER;
382: l_return_status VARCHAR2(1);
383: l_item_type_code oe_order_lines_all.item_type_code%TYPE;
384: l_order_uom OE_ORDER_LINES_ALL.order_Quantity_Uom%TYPE;
385: l_uom_conv_rate NUMBER;
386: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_SO_Details';
387:

Line 384: l_order_uom OE_ORDER_LINES_ALL.order_Quantity_Uom%TYPE;

380: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
381: l_error_code NUMBER;
382: l_return_status VARCHAR2(1);
383: l_item_type_code oe_order_lines_all.item_type_code%TYPE;
384: l_order_uom OE_ORDER_LINES_ALL.order_Quantity_Uom%TYPE;
385: l_uom_conv_rate NUMBER;
386: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_SO_Details';
387:
388: --Fix bug 3318761, replace wsh_shipping_details_v with wdd and wnd tables

Line 435: , OE_ORDER_LINES_ALL oola

431: , oola.item_type_code
432: , oola.order_quantity_uom
433: FROM
434: OE_ORDER_HEADERS_ALL ooha
435: , OE_ORDER_LINES_ALL oola
436: , wsh_delivery_details_ob_grp_v wdd
437: , wsh_new_deliveries_ob_grp_v wnd
438: , wsh_delivery_assignments_v wda
439: , HZ_PARTIES rac

Line 691: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;

687: , x_movement_transaction IN OUT NOCOPY
688: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
689: )
690: IS
691: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
692: l_order_uom OE_ORDER_LINES_ALL.order_Quantity_Uom%TYPE;
693: l_uom_conv_rate NUMBER;
694: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_KIT_SO_Details';
695:

Line 692: l_order_uom OE_ORDER_LINES_ALL.order_Quantity_Uom%TYPE;

688: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
689: )
690: IS
691: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
692: l_order_uom OE_ORDER_LINES_ALL.order_Quantity_Uom%TYPE;
693: l_uom_conv_rate NUMBER;
694: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_KIT_SO_Details';
695:
696: --Get line information for kit item line

Line 709: oe_order_lines_all oola

705: , oola.inventory_item_id
706: , msi.description
707: , msi.primary_uom_code
708: FROM
709: oe_order_lines_all oola
710: , mtl_system_items msi
711: WHERE oola.inventory_item_id = msi.inventory_item_id
712: AND oola.ship_from_org_id = msi.organization_id
713: AND line_id = p_link_to_line_id;

Line 813: oe_order_lines_all oola

809: SELECT
810: source_document_id
811: , source_document_line_id
812: FROM
813: oe_order_lines_all oola
814: , po_requisition_headers_all prha
815: WHERE prha.requisition_header_id = oola.source_document_id
816: AND line_id = x_movement_transaction.order_line_id;
817:

Line 1051: FROM oe_order_lines_all

1047: UPDATE wsh_delivery_details
1048: SET mvt_stat_status = 'FORDISP'
1049: , movement_id = p_movement_id
1050: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1051: FROM oe_order_lines_all
1052: WHERE link_to_line_id = p_link_to_line_id);
1053: ELSIF p_status = 'DISPPROCESSED'
1054: THEN
1055: --cross legal entity SO, the dispatch is already created,so set the status

Line 1062: FROM oe_order_lines_all

1058: UPDATE wsh_delivery_details
1059: SET mvt_stat_status = 'FORARVL'
1060: , movement_id = p_movement_id
1061: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1062: FROM oe_order_lines_all
1063: WHERE link_to_line_id = p_link_to_line_id);
1064: ELSE
1065: --Regular SO
1066: UPDATE wsh_delivery_details

Line 1070: FROM oe_order_lines_all

1066: UPDATE wsh_delivery_details
1067: SET mvt_stat_status = 'PROCESSED'
1068: , movement_id = p_movement_id
1069: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1070: FROM oe_order_lines_all
1071: WHERE link_to_line_id = p_link_to_line_id);
1072: END IF;
1073: ELSE
1074: UPDATE wsh_delivery_details

Line 1078: FROM oe_order_lines_all

1074: UPDATE wsh_delivery_details
1075: SET mvt_stat_status = 'PROCESSED'
1076: , movement_id = p_movement_id
1077: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1078: FROM oe_order_lines_all
1079: WHERE link_to_line_id = p_link_to_line_id);
1080: END IF;
1081:
1082: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)