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 137: , OE_ORDER_LINES_ALL ol

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

Line 173: , OE_ORDER_LINES_ALL ol

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

Line 287: , OE_ORDER_LINES_ALL ol

283: FROM
284: WSH_NEW_DELIVERIES_OB_GRP_V wnd
285: , wsh_delivery_assignments_v wda
286: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
287: , OE_ORDER_LINES_ALL ol
288: , hr_organization_information hoi /*Bug 8467743*/
289: WHERE wnd.delivery_id = wda.delivery_id
290: AND wda.delivery_detail_id = wdd.delivery_detail_id
291: AND wdd.source_line_id = ol.line_id

Line 386: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;

382: )
383:
384: IS
385: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
386: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
387: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
388: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
389: l_error_code NUMBER;
390: l_return_status VARCHAR2(1);

Line 387: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;

383:
384: IS
385: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
386: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
387: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
388: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
389: l_error_code NUMBER;
390: l_return_status VARCHAR2(1);
391: l_item_type_code oe_order_lines_all.item_type_code%TYPE;

Line 391: l_item_type_code oe_order_lines_all.item_type_code%TYPE;

387: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
388: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
389: l_error_code NUMBER;
390: l_return_status VARCHAR2(1);
391: l_item_type_code oe_order_lines_all.item_type_code%TYPE;
392: l_order_uom OE_ORDER_LINES_ALL.order_Quantity_Uom%TYPE;
393: l_uom_conv_rate NUMBER;
394: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_SO_Details';
395:

Line 392: l_order_uom OE_ORDER_LINES_ALL.order_Quantity_Uom%TYPE;

388: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
389: l_error_code NUMBER;
390: l_return_status VARCHAR2(1);
391: l_item_type_code oe_order_lines_all.item_type_code%TYPE;
392: l_order_uom OE_ORDER_LINES_ALL.order_Quantity_Uom%TYPE;
393: l_uom_conv_rate NUMBER;
394: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_SO_Details';
395:
396: --Fix bug 3318761, replace wsh_shipping_details_v with wdd and wnd tables

Line 445: , OE_ORDER_LINES_ALL oola

441: , oola.item_type_code
442: , oola.order_quantity_uom
443: FROM
444: OE_ORDER_HEADERS_ALL ooha
445: , OE_ORDER_LINES_ALL oola
446: , wsh_delivery_details_ob_grp_v wdd
447: , wsh_new_deliveries_ob_grp_v wnd
448: , wsh_delivery_assignments_v wda
449: , HZ_PARTIES rac

Line 730: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;

726: , x_movement_transaction IN OUT NOCOPY
727: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
728: )
729: IS
730: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
731: l_order_uom OE_ORDER_LINES_ALL.order_Quantity_Uom%TYPE;
732: l_uom_conv_rate NUMBER;
733: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_KIT_SO_Details';
734:

Line 731: l_order_uom OE_ORDER_LINES_ALL.order_Quantity_Uom%TYPE;

727: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
728: )
729: IS
730: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
731: l_order_uom OE_ORDER_LINES_ALL.order_Quantity_Uom%TYPE;
732: l_uom_conv_rate NUMBER;
733: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_KIT_SO_Details';
734:
735: --Get line information for kit item line

Line 748: oe_order_lines_all oola

744: , oola.inventory_item_id
745: , msi.description
746: , msi.primary_uom_code
747: FROM
748: oe_order_lines_all oola
749: , mtl_system_items msi
750: WHERE oola.inventory_item_id = msi.inventory_item_id
751: AND oola.ship_from_org_id = msi.organization_id
752: AND line_id = p_link_to_line_id;

Line 852: oe_order_lines_all oola

848: SELECT
849: source_document_id
850: , source_document_line_id
851: FROM
852: oe_order_lines_all oola
853: , po_requisition_headers_all prha
854: WHERE prha.requisition_header_id = oola.source_document_id
855: AND line_id = x_movement_transaction.order_line_id;
856:

Line 1090: FROM oe_order_lines_all

1086: UPDATE wsh_delivery_details
1087: SET mvt_stat_status = 'FORDISP'
1088: , movement_id = p_movement_id
1089: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1090: FROM oe_order_lines_all
1091: WHERE link_to_line_id = p_link_to_line_id);
1092: ELSIF p_status = 'DISPPROCESSED'
1093: THEN
1094: --cross legal entity SO, the dispatch is already created,so set the status

Line 1101: FROM oe_order_lines_all

1097: UPDATE wsh_delivery_details
1098: SET mvt_stat_status = 'FORARVL'
1099: , movement_id = p_movement_id
1100: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1101: FROM oe_order_lines_all
1102: WHERE link_to_line_id = p_link_to_line_id);
1103: ELSE
1104: --Regular SO
1105: UPDATE wsh_delivery_details

Line 1109: FROM oe_order_lines_all

1105: UPDATE wsh_delivery_details
1106: SET mvt_stat_status = 'PROCESSED'
1107: , movement_id = p_movement_id
1108: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1109: FROM oe_order_lines_all
1110: WHERE link_to_line_id = p_link_to_line_id);
1111: END IF;
1112: ELSE
1113: UPDATE wsh_delivery_details

Line 1117: FROM oe_order_lines_all

1113: UPDATE wsh_delivery_details
1114: SET mvt_stat_status = 'PROCESSED'
1115: , movement_id = p_movement_id
1116: WHERE source_line_id IN (SELECT line_id --fix bug 4185582
1117: FROM oe_order_lines_all
1118: WHERE link_to_line_id = p_link_to_line_id);
1119: END IF;
1120:
1121: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)