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 1449: FROM MTL_SYSTEM_ITEMS

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