DBA Data[Home] [Help]

APPS.WMS_RFID_DEVICE_PUB dependencies on MTL_CROSS_REFERENCES

Line 2469: select uom_code INTO l_uom_code FROM mtl_cross_references mcr

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