APPS.OE_DS_PVT dependencies on OE_DROP_SHIP_SOURCES

Line 201: OE_DROP_SHIP_SOURCES OD,

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

Line 297: oe_drop_ship_sources ds

293:
294: SELECT pol.org_id
295: INTO l_po_ou_id
296: FROM po_lines_all pol,
297: oe_drop_ship_sources ds
298: WHERE ds.line_id = l_line_id
299: AND ds.po_header_id = pol.po_header_id
300: AND ds.po_line_id = pol.po_line_id;
301: */

Line 1808: FROM OE_DROP_SHIP_SOURCES

1804: PO_Header_ID,
1805: PO_Line_ID,
1806: Line_Location_ID,
1807: PO_Release_ID
1808: FROM OE_DROP_SHIP_SOURCES
1809: WHERE line_id = l_new_line_id
1810: AND line_location_id = G_LINE_LOCATION_ID; -- bug 4402566
1811:
1812: --

Line 1830: Insert Into OE_Drop_Ship_Sources

1826: l_line_location_id,
1827: l_po_release_id;
1828: CLOSE old_drop_ship_line;
1829:
1830: Insert Into OE_Drop_Ship_Sources
1831: (
1832: drop_ship_source_id,
1833: header_id,
1834: line_id,

Line 2735: update oe_drop_ship_sources

2731: IF l_debug_level > 0 THEN
2732: oe_debug_pub.add( 'Updating existing dropship record with new line '||l_new_line_id , 1 ) ;
2733: END IF;
2734:
2735: update oe_drop_ship_sources
2736: set line_id = l_new_line_id
2737: where line_id = p_line_rec.line_id;
2738:
2739: insert_oe_drop_ship_source(p_line_rec.line_id, l_new_line_id);

Line 2817: FROM oe_drop_ship_sources

2813: END IF;
2814:
2815: SELECT requisition_header_id, po_header_id, po_release_id
2816: INTO l_req_header_id,l_po_header_id, l_po_release_id --bug 5328526
2817: FROM oe_drop_ship_sources
2818: WHERE line_id = p_line_id
2819: AND header_id = p_header_id;
2820:
2821: IF l_debug_level > 0 THEN

Line 2987: FROM oe_drop_ship_sources ds,oe_order_lines l

2983: END IF;
2984:
2985: SELECT po_header_id, po_release_id
2986: INTO l_po_header_id, l_po_release_id --bug 5328526
2987: FROM oe_drop_ship_sources ds,oe_order_lines l
2988: WHERE ds.header_id = l_header_id
2989: AND l.item_type_code = 'CONFIG'
2990: AND l.line_id = ds.line_id
2991: AND l.ato_line_id = l_ato_line_id;

Line 3001: FROM oe_drop_ship_sources

2997: l_operation <> OE_GLOBALS.G_OPR_CREATE THEN
2998:
2999: SELECT po_header_id, po_release_id
3000: INTO l_po_header_id, l_po_release_id --bug 5328526
3001: FROM oe_drop_ship_sources
3002: WHERE line_id = l_line_id
3003: AND header_id = l_header_id;
3004: END IF;
3005:

Line 3110: FROM oe_drop_ship_sources l,po_requisition_lines_all rl

3106:
3107:
3108: SELECT drop_ship_flag
3109: INTO l_drop_ship_flag
3110: FROM oe_drop_ship_sources l,po_requisition_lines_all rl
3111: WHERE l.line_id = l_line_id
3112: AND l.header_id = l_header_id
3113: AND l.requisition_line_id = rl.requisition_line_id;
3114: