APPS.OE_DS_PVT dependencies on OE_DROP_SHIP_SOURCES

Line 204: OE_DROP_SHIP_SOURCES OD,

200: OD.LINE_LOCATION_ID, -- bug 4402566
201: RT.PO_HEADER_ID, -- bug 4402566
202: nvl(OL.SHIPPED_QUANTITY,0) shp_qty
203: FROM OE_ORDER_LINES_ALL OL,
204: OE_DROP_SHIP_SOURCES OD,
205: RCV_TRANSACTIONS RT
206: WHERE OL.LINE_ID = OD.LINE_ID
207: AND OL.SOURCE_TYPE_CODE = 'EXTERNAL'
208: AND OD.PO_HEADER_ID = RT.PO_HEADER_ID

Line 302: oe_drop_ship_sources ds

298:
299: SELECT pol.org_id
300: INTO l_po_ou_id
301: FROM po_lines_all pol,
302: oe_drop_ship_sources ds
303: WHERE ds.line_id = l_line_id
304: AND ds.po_header_id = pol.po_header_id
305: AND ds.po_line_id = pol.po_line_id;
306: */

Line 1833: FROM OE_DROP_SHIP_SOURCES

1829: PO_Header_ID,
1830: PO_Line_ID,
1831: Line_Location_ID,
1832: PO_Release_ID
1833: FROM OE_DROP_SHIP_SOURCES
1834: WHERE line_id = l_new_line_id
1835: AND line_location_id = G_LINE_LOCATION_ID; -- bug 4402566
1836:
1837: --

Line 1855: Insert Into OE_Drop_Ship_Sources

1851: l_line_location_id,
1852: l_po_release_id;
1853: CLOSE old_drop_ship_line;
1854:
1855: Insert Into OE_Drop_Ship_Sources
1856: (
1857: drop_ship_source_id,
1858: header_id,
1859: line_id,

Line 2775: update oe_drop_ship_sources

2771: IF l_debug_level > 0 THEN
2772: oe_debug_pub.add( 'Updating existing dropship record with new line '||l_new_line_id , 1 ) ;
2773: END IF;
2774:
2775: update oe_drop_ship_sources
2776: set line_id = l_new_line_id
2777: where line_id = p_line_rec.line_id;
2778:
2779: insert_oe_drop_ship_source(p_line_rec.line_id, l_new_line_id);

Line 2857: FROM oe_drop_ship_sources

2853: END IF;
2854:
2855: SELECT requisition_header_id, po_header_id, po_release_id
2856: INTO l_req_header_id,l_po_header_id, l_po_release_id --bug 5328526
2857: FROM oe_drop_ship_sources
2858: WHERE line_id = p_line_id
2859: AND header_id = p_header_id;
2860:
2861: IF l_debug_level > 0 THEN

Line 3027: FROM oe_drop_ship_sources ds,oe_order_lines l

3023: END IF;
3024:
3025: SELECT po_header_id, po_release_id
3026: INTO l_po_header_id, l_po_release_id --bug 5328526
3027: FROM oe_drop_ship_sources ds,oe_order_lines l
3028: WHERE ds.header_id = l_header_id
3029: AND l.item_type_code = 'CONFIG'
3030: AND l.line_id = ds.line_id
3031: AND l.ato_line_id = l_ato_line_id;

Line 3041: FROM oe_drop_ship_sources

3037: l_operation <> OE_GLOBALS.G_OPR_CREATE THEN
3038:
3039: SELECT po_header_id, po_release_id
3040: INTO l_po_header_id, l_po_release_id --bug 5328526
3041: FROM oe_drop_ship_sources
3042: WHERE line_id = l_line_id
3043: AND header_id = l_header_id;
3044: END IF;
3045:

Line 3150: FROM oe_drop_ship_sources l,po_requisition_lines_all rl

3146:
3147:
3148: SELECT drop_ship_flag
3149: INTO l_drop_ship_flag
3150: FROM oe_drop_ship_sources l,po_requisition_lines_all rl
3151: WHERE l.line_id = l_line_id
3152: AND l.header_id = l_header_id
3153: AND l.requisition_line_id = rl.requisition_line_id;
3154: