DBA Data[Home] [Help]

APPS.WMS_RFID_DEVICE_PUB dependencies on MTL_CROSS_REFERENCES

Line 2470: select uom_code INTO l_uom_code FROM mtl_cross_references mcr

2466: IF l_single_item THEN
2467: BEGIN
2468: --Assumption is that given a GTIN + Item_id + org_id , the set
2469: --up for cross reference will return only one record
2470: select uom_code INTO l_uom_code FROM mtl_cross_references mcr
2471: WHERE mcr.inventory_item_id = L_LPN_ITEM_ID
2472: AND mcr.CROSS_REFERENCE = To_char(p_tag_info(i).gtin)
2473: AND mcr.CROSS_REFERENCE_TYPE = G_PROFILE_GTIN
2474: AND (( mcr.org_independent_flag = 'Y' AND mcr.organization_id IS NULL) OR