DBA Data[Home] [Help]

APPS.INV_LABEL dependencies on WMS_CONTAINER_PUB

Line 3916: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,

3912: SELECT wlpn.lpn_context , wlpn.subinventory_code , wlpn.locator_id
3913: INTO l_lpn_context , l_subinventory_code , l_locator_id
3914: FROM wms_license_plate_numbers wlpn
3915: WHERE wlpn.lpn_id = p_lpn_id;
3916: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
3917: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
3918: WMS_Container_PUB.LPN_CONTEXT_STORES,
3919: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
3920: WMS_Container_PUB.LPN_CONTEXT_PACKING,

Line 3917: WMS_Container_PUB.LPN_CONTEXT_VENDOR,

3913: INTO l_lpn_context , l_subinventory_code , l_locator_id
3914: FROM wms_license_plate_numbers wlpn
3915: WHERE wlpn.lpn_id = p_lpn_id;
3916: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
3917: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
3918: WMS_Container_PUB.LPN_CONTEXT_STORES,
3919: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
3920: WMS_Container_PUB.LPN_CONTEXT_PACKING,
3921: WMS_Container_PUB.LPN_CONTEXT_WIP,

Line 3918: WMS_Container_PUB.LPN_CONTEXT_STORES,

3914: FROM wms_license_plate_numbers wlpn
3915: WHERE wlpn.lpn_id = p_lpn_id;
3916: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
3917: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
3918: WMS_Container_PUB.LPN_CONTEXT_STORES,
3919: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
3920: WMS_Container_PUB.LPN_CONTEXT_PACKING,
3921: WMS_Container_PUB.LPN_CONTEXT_WIP,
3922: WMS_Container_PUB.LPN_CONTEXT_RCV

Line 3919: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,

3915: WHERE wlpn.lpn_id = p_lpn_id;
3916: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
3917: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
3918: WMS_Container_PUB.LPN_CONTEXT_STORES,
3919: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
3920: WMS_Container_PUB.LPN_CONTEXT_PACKING,
3921: WMS_Container_PUB.LPN_CONTEXT_WIP,
3922: WMS_Container_PUB.LPN_CONTEXT_RCV
3923: )

Line 3920: WMS_Container_PUB.LPN_CONTEXT_PACKING,

3916: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
3917: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
3918: WMS_Container_PUB.LPN_CONTEXT_STORES,
3919: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
3920: WMS_Container_PUB.LPN_CONTEXT_PACKING,
3921: WMS_Container_PUB.LPN_CONTEXT_WIP,
3922: WMS_Container_PUB.LPN_CONTEXT_RCV
3923: )
3924: OR (p_transaction_id is NULL)

Line 3921: WMS_Container_PUB.LPN_CONTEXT_WIP,

3917: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
3918: WMS_Container_PUB.LPN_CONTEXT_STORES,
3919: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
3920: WMS_Container_PUB.LPN_CONTEXT_PACKING,
3921: WMS_Container_PUB.LPN_CONTEXT_WIP,
3922: WMS_Container_PUB.LPN_CONTEXT_RCV
3923: )
3924: OR (p_transaction_id is NULL)
3925: OR (p_business_flow in (1,2,3,4))THEN

Line 3922: WMS_Container_PUB.LPN_CONTEXT_RCV

3918: WMS_Container_PUB.LPN_CONTEXT_STORES,
3919: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT ,
3920: WMS_Container_PUB.LPN_CONTEXT_PACKING,
3921: WMS_Container_PUB.LPN_CONTEXT_WIP,
3922: WMS_Container_PUB.LPN_CONTEXT_RCV
3923: )
3924: OR (p_transaction_id is NULL)
3925: OR (p_business_flow in (1,2,3,4))THEN
3926: -- no need to check src status for these transaction so calling get_lpn_status