DBA Data[Home] [Help]

APPS.MST_SNAPSHOT_TASK_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 232: from wsh_Delivery_details det,

228: l_osp_flag varchar2(1) ;
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