DBA Data[Home] [Help]

APPS.INV_LABEL dependencies on WMS_CONTAINER_PUB

Line 4015: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,

4011: SELECT wlpn.lpn_context , wlpn.subinventory_code , wlpn.locator_id
4012: INTO l_lpn_context , l_subinventory_code , l_locator_id
4013: FROM wms_license_plate_numbers wlpn
4014: WHERE wlpn.lpn_id = p_lpn_id;
4015: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
4016: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
4017: WMS_Container_PUB.LPN_CONTEXT_STORES,
4018: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
4019: WMS_Container_PUB.LPN_CONTEXT_PACKING,

Line 4016: WMS_Container_PUB.LPN_CONTEXT_VENDOR,

4012: INTO l_lpn_context , l_subinventory_code , l_locator_id
4013: FROM wms_license_plate_numbers wlpn
4014: WHERE wlpn.lpn_id = p_lpn_id;
4015: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
4016: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
4017: WMS_Container_PUB.LPN_CONTEXT_STORES,
4018: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
4019: WMS_Container_PUB.LPN_CONTEXT_PACKING,
4020: WMS_Container_PUB.LPN_CONTEXT_WIP,

Line 4017: WMS_Container_PUB.LPN_CONTEXT_STORES,

4013: FROM wms_license_plate_numbers wlpn
4014: WHERE wlpn.lpn_id = p_lpn_id;
4015: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
4016: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
4017: WMS_Container_PUB.LPN_CONTEXT_STORES,
4018: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
4019: WMS_Container_PUB.LPN_CONTEXT_PACKING,
4020: WMS_Container_PUB.LPN_CONTEXT_WIP,
4021: WMS_Container_PUB.LPN_CONTEXT_RCV

Line 4018: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,

4014: WHERE wlpn.lpn_id = p_lpn_id;
4015: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
4016: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
4017: WMS_Container_PUB.LPN_CONTEXT_STORES,
4018: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
4019: WMS_Container_PUB.LPN_CONTEXT_PACKING,
4020: WMS_Container_PUB.LPN_CONTEXT_WIP,
4021: WMS_Container_PUB.LPN_CONTEXT_RCV
4022: )

Line 4019: WMS_Container_PUB.LPN_CONTEXT_PACKING,

4015: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
4016: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
4017: WMS_Container_PUB.LPN_CONTEXT_STORES,
4018: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
4019: WMS_Container_PUB.LPN_CONTEXT_PACKING,
4020: WMS_Container_PUB.LPN_CONTEXT_WIP,
4021: WMS_Container_PUB.LPN_CONTEXT_RCV
4022: )
4023: OR (p_transaction_id is NULL)

Line 4020: WMS_Container_PUB.LPN_CONTEXT_WIP,

4016: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
4017: WMS_Container_PUB.LPN_CONTEXT_STORES,
4018: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
4019: WMS_Container_PUB.LPN_CONTEXT_PACKING,
4020: WMS_Container_PUB.LPN_CONTEXT_WIP,
4021: WMS_Container_PUB.LPN_CONTEXT_RCV
4022: )
4023: OR (p_transaction_id is NULL)
4024: OR (p_business_flow in (1,2,3,4))THEN

Line 4021: WMS_Container_PUB.LPN_CONTEXT_RCV

4017: WMS_Container_PUB.LPN_CONTEXT_STORES,
4018: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
4019: WMS_Container_PUB.LPN_CONTEXT_PACKING,
4020: WMS_Container_PUB.LPN_CONTEXT_WIP,
4021: WMS_Container_PUB.LPN_CONTEXT_RCV
4022: )
4023: OR (p_transaction_id is NULL)
4024: OR (p_business_flow in (1,2,3,4))THEN
4025: -- no need to check src status for these transaction so calling get_lpn_status