DBA Data[Home] [Help]

APPS.MST_SNAPSHOT_TASK_UTIL dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 233: wsh_delivery_assignments assg,

229: begin
230: select decode(det.source_line_type_code, 'OSP','Y','N')
231: into l_osp_flag
232: from wsh_Delivery_details det,
233: wsh_delivery_assignments assg,
234: wsh_new_deliveries del
235: where del.delivery_id= ldelivery_id
236: AND del.delivery_id = assg.delivery_id
237: AND assg.delivery_detail_id = det.delivery_detail_id