APPS.CTO_WORKBENCH_UTIL_PK dependencies on OE_DROP_SHIP_SOURCES

Line 173: from oe_drop_ship_sources ods

169: IF nvl(p_source_type, 'INTERNAL') = 'EXTERNAL' THEN
170:
171: select count(*)
172: into v_ds_po_quantity
173: from oe_drop_ship_sources ods
174: where ods.line_id = l_demand_line_id
175: --and ods.drop_ship_source_id = 2
176: and ods.po_header_id is not null;
177:

Line 184: from oe_drop_ship_sources ods

180: END IF;
181:
182: select count(*)
183: into v_ds_req_quantity
184: from oe_drop_ship_sources ods
185: where ods.line_id = l_demand_line_id
186: --and ods.drop_ship_source_id = 2
187: and ods.po_header_id is null;
188:

Line 731: from oe_drop_ship_sources ods, po_line_locations_all poll

727:
728: UNION
729:
730: select nvl(poll.promised_date,poll.need_by_date) exp_comp_date
731: from oe_drop_ship_sources ods, po_line_locations_all poll
732: where ods.line_id = l_config_line_id
733: and ods.po_header_id = poll.po_header_id
734: and ods.line_location_id = poll.line_location_id
735:

Line 739: from oe_drop_ship_sources ods, po_requisition_lines_all porl

735:
736: UNION
737:
738: select porl.need_by_date exp_comp_date
739: from oe_drop_ship_sources ods, po_requisition_lines_all porl
740: where ods.line_id = l_config_line_id
741: and ods.po_header_id is null
742: and ods.requisition_header_id = porl.requisition_header_id
743: and ods.requisition_line_id = porl.requisition_line_id