DBA Data[Home] [Help]

APPS.WMS_EPC_PVT dependencies on WMS_CONTAINER_PUB

Line 668: AND wlpn.lpn_context = wms_container_pub.LPN_CONTEXT_PACKING

664: wms_license_plate_numbers wlpn
665: WHERE Nvl(mmtt.transfer_lpn_id,mmtt.content_lpn_id) = p_lpn_id
666: AND mmtt.organization_id = p_org_id
667: AND wlpn.lpn_id = Nvl(mmtt.transfer_lpn_id,mmtt.content_lpn_id)
668: AND wlpn.lpn_context = wms_container_pub.LPN_CONTEXT_PACKING
669: GROUP BY mmtt.inventory_item_id,mmtt.transaction_uom, mmtt.revision;
670: --All GTINS (transaction_uom) have to different in an LPN for SGTIN EPC generation rule
671:
672: EXCEPTION

Line 873: AND wlpn.LPN_CONTEXT = wms_container_pub.LPN_CONTEXT_WIP

869: wms_lpn_contents wlc
870: WHERE wlc.parent_lpn_id = p_lpn_id
871: AND wlc.organization_id = p_org_id
872: AND wlpn.lpn_id = wlc.parent_lpn_id
873: AND wlpn.LPN_CONTEXT = wms_container_pub.LPN_CONTEXT_WIP
874: AND wlc.organization_id = wlpn.organization_id
875: GROUP BY WLC.inventory_item_id,wlc.uom_code,wlc.revision;
876: --this code will be invoked for Picking business flow only and a
877: --physical lpn can have only one status at a time..that will be