DBA Data[Home] [Help]

APPS.WSH_BOLS_PVT dependencies on WSH_DOCUMENT_INSTANCES

Line 630: wsh_document_instances wdi,

626: wt.name
627: from wsh_delivery_legs wdl,
628: wsh_trip_stops wts1,
629: wsh_trips wt,
630: wsh_document_instances wdi,
631: wsh_doc_sequence_categories wdsc
632: where wdsc.doc_sequence_category_id = wdi.doc_sequence_category_id
633: AND NVL(wdsc.document_code, '-99') <> '-99'
634: AND wdi.entity_id = wdl.delivery_leg_id

Line 653: wsh_document_instances wdi

649: from wsh_delivery_legs wdl,
650: wsh_trip_stops wts1,
651: wsh_trip_stops wts2,
652: wsh_trips wt,
653: wsh_document_instances wdi
654: where wdi.entity_id = wdl.delivery_leg_id
655: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
656: AND wdi.document_type = 'BOL'
657: AND wdi.status <> 'CANCELLED'

Line 755: from wsh_document_instances

751:
752: FOR i IN l_bol_num_tab.FIRST..l_bol_num_tab.LAST
753: LOOP
754: select 1 into l_tmp
755: from wsh_document_instances
756: where document_instance_id = l_bol_num_tab(i).document_instance_id
757: FOR UPDATE NOWAIT;
758: END LOOP;
759: