DBA Data[Home] [Help]

APPS.GMI_SHIPPING_UTIL dependencies on OE_ORDER_LINES_ALL

Line 2329: from oe_order_lines_all

2325: CURSOR c_order_line_info(c_order_line_id number) is
2326: SELECT source_document_type_id
2327: , source_document_id
2328: , source_document_line_id
2329: from oe_order_lines_all
2330: where line_id = c_order_line_id;
2331: l_order_line_info c_order_line_info%ROWTYPE;
2332:
2333: CURSOR c_delivery_info is

Line 2842: from rcv_shipment_lines rsl, oe_order_lines_all oel

2838: AND NVL(dd.inv_interfaced_flag , 'N') = 'Y'
2839: AND dd.container_flag = 'N'
2840: AND dd.source_code = 'OE'
2841: AND NOT EXISTS(select 1
2842: from rcv_shipment_lines rsl, oe_order_lines_all oel
2843: where oel.line_id = dd.source_line_id
2844: and rsl.requisition_line_id = oel.source_document_line_id
2845: and rsl.comments = 'OPM WDD:'||to_char(dd.delivery_detail_id));
2846:

Line 2854: from oe_order_lines_all

2850: SELECT source_document_type_id
2851: , source_document_id
2852: , source_document_line_id
2853: , ship_from_org_id
2854: from oe_order_lines_all
2855: where line_id = c_order_line_id;
2856:
2857: l_order_line_info c_order_line_info%ROWTYPE;
2858: rc NUMBER := NULL;

Line 3010: , oe_order_lines_all sol

3006: , wdd.sublot_number
3007: , wdd.released_status SHIP_STATUS
3008: FROM wsh_delivery_details wdd
3009: , oe_order_headers_all soh
3010: , oe_order_lines_all sol
3011: , mtl_parameters mp1
3012: , mtl_parameters mp2
3013: WHERE wdd.source_line_id = sol.line_id
3014: AND mp1.organization_id = sol.org_id

Line 3071: , oe_order_lines_all sol

3067: , wdd.SHIPPED_QUANTITY SHIP_QTY
3068: FROM ic_txn_request_lines mo
3069: , wsh_delivery_details wdd
3070: , oe_order_headers_all soh
3071: , oe_order_lines_all sol
3072: , mtl_parameters mp1
3073: , mtl_parameters mp2
3074: Where soh.header_id = sol.header_id
3075: and sol.line_id = mo.txn_source_line_id