DBA Data[Home] [Help]

APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_DOCUMENT_INSTANCES

Line 3916: wsh_document_instances di

3912: /*Refer POD Information from WSH_DELIVERY_LEGS. Bug#1918342*/
3913: CURSOR check_POD (l_stop_id NUMBER, l_delivery_id NUMBER) IS
3914: SELECT dg.pod_flag
3915: FROM wsh_delivery_legs dg,
3916: wsh_document_instances di
3917: WHERE dg.drop_off_stop_id = l_stop_id AND
3918: di.entity_id = dg.delivery_leg_id AND
3919: di.entity_name = 'WSH_DELIVERY_LEGS' AND
3920: di.document_type = 'BOL' AND

Line 4266: wsh_document_instances di

4262: --
4263: CURSOR check_POD (p_stop_id NUMBER) IS
4264: SELECT 1
4265: FROM wsh_delivery_legs dg,
4266: wsh_document_instances di
4267: WHERE dg.drop_off_stop_id = p_stop_id
4268: AND di.entity_id = dg.delivery_leg_id
4269: AND di.entity_name = 'WSH_DELIVERY_LEGS'
4270: AND di.document_type = 'BOL'