DBA Data[Home] [Help]

APPS.WSH_DELIVERY_LEGS_GRP dependencies on WSH_DOCUMENT_INSTANCES

Line 369: FROM WSH_DOCUMENT_INSTANCES wdi,

365:
366: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_BOL_NUM_LVL) = 1) THEN
367: SELECT count(*)
368: INTO l_bol_number
369: FROM WSH_DOCUMENT_INSTANCES wdi,
370: WSH_DELIVERY_LEGS wdl
371: WHERE wdi.entity_id = wdl.delivery_leg_id
372: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
373: AND wdi.status <> 'CANCELLED'

Line 434: FROM WSH_DOCUMENT_INSTANCES wdi,

430: CLOSE get_parent_leg;
431:
432: SELECT count(*)
433: INTO l_bol_number
434: FROM WSH_DOCUMENT_INSTANCES wdi,
435: WSH_DELIVERY_LEGS wdl
436: WHERE wdi.entity_id = wdl.delivery_leg_id
437: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
438: AND wdi.status <> 'CANCELLED'