DBA Data[Home] [Help]

APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_DOCUMENT_INSTANCES

Line 3826: wsh_document_instances di

3822: /*Refer POD Information from WSH_DELIVERY_LEGS. Bug#1918342*/
3823: CURSOR check_POD (l_stop_id NUMBER, l_delivery_id NUMBER) IS
3824: SELECT dg.pod_flag
3825: FROM wsh_delivery_legs dg,
3826: wsh_document_instances di
3827: WHERE dg.drop_off_stop_id = l_stop_id AND
3828: di.entity_id = dg.delivery_leg_id AND
3829: di.entity_name = 'WSH_DELIVERY_LEGS' AND
3830: di.document_type = 'BOL' AND

Line 4176: wsh_document_instances di

4172: --
4173: CURSOR check_POD (p_stop_id NUMBER) IS
4174: SELECT 1
4175: FROM wsh_delivery_legs dg,
4176: wsh_document_instances di
4177: WHERE dg.drop_off_stop_id = p_stop_id
4178: AND di.entity_id = dg.delivery_leg_id
4179: AND di.entity_name = 'WSH_DELIVERY_LEGS'
4180: AND di.document_type = 'BOL'