DBA Data[Home] [Help]

APPS.CSTPLCAC dependencies on MTL_SYSTEM_ITEMS

Line 443: FROM MTL_SYSTEM_ITEMS

439: --------------------------------------------------------
440:
441: SELECT decode(INVENTORY_ASSET_FLAG,'Y',0,1)
442: INTO l_exp_item
443: FROM MTL_SYSTEM_ITEMS
444: WHERE INVENTORY_ITEM_ID = wro_rec.inventory_item_id
445: AND ORGANIZATION_ID = i_org_id;
446:
447:

Line 1452: FROM MTL_SYSTEM_ITEMS

1448: --------------------------------------------------------
1449:
1450: SELECT decode(INVENTORY_ASSET_FLAG,'Y',0,1)
1451: INTO l_exp_item
1452: FROM MTL_SYSTEM_ITEMS
1453: WHERE INVENTORY_ITEM_ID = wro_rec.inventory_item_id
1454: AND ORGANIZATION_ID = i_org_id;
1455:
1456: