APPS.OE_DROP_SHIP_PVT dependencies on SO_DROP_SHIP_SOURCES

Line 64: so_drop_ship_sources sodss

60: nvl(poll.quantity_shipped,0))
61: into
62: poqty
63: from po_line_locations poll,
64: so_drop_ship_sources sodss
65: where sodss.line_id = p_lineid
66: and poll.line_location_id = sodss.line_location_id
67: and sodss.header_id = p_headerid
68: and nvl(poll.closed_code, '*') <> 'FINALLY CLOSED';

Line 78: so_drop_ship_sources sodss

74:
75: begin
76: select user_hold_flag into po_hold_exists
77: from po_headers poh,
78: so_drop_ship_sources sodss
79: where
80: sodss.header_id = p_headerid
81: and sodss.line_id = p_lineid
82: and sodss.po_header_id = poh.po_header_id;

Line 95: so_drop_ship_sources sodss

91: - nvl(prl.quantity_delivered,0))
92: into
93: poqty
94: from po_requisition_lines prl,
95: so_drop_ship_sources sodss
96: where sodss.line_id = p_lineid
97: and prl.requisition_line_id = sodss.requisition_line_id
98: and sodss.header_id = p_headerid
99: and nvl(prl.closed_code,'*') <> 'FINALLY CLOSED';