DBA Data[Home] [Help]

APPS.INVPUOPI dependencies on MTL_ITEM_LOCATIONS

Line 667: from MTL_ITEM_LOCATIONS

663:
664: else if flex_code = 'MTLL' then
665: select INVENTORY_LOCATION_ID
666: into flex_id
667: from MTL_ITEM_LOCATIONS
668: where ORGANIZATION_ID = org_id
669: and NVL(segment1,' ') = DECODE(seg_value(1),NULL,' ',seg_value(1))
670: and NVL(segment2,' ') = DECODE(seg_value(2),NULL,' ',seg_value(2))
671: and NVL(segment3,' ') = DECODE(seg_value(3),NULL,' ',seg_value(3))