DBA Data[Home] [Help]

APPS.CSD_WARRANTY_CONTRACT_PVT dependencies on CST_ITEM_COSTS

Line 478: CST_ITEM_COSTS CIC

474: FROM
475: ( SELECT SUM( abs(mmt.primary_quantity)*CIC.item_cost) item_cost
476: FROM MTL_MATERIAL_TRANSACTIONS MMT,
477: WIP_ENTITIES WIP ,
478: CST_ITEM_COSTS CIC
479: WHERE MMT.transaction_source_id = WIP.wip_entity_id
480: AND MMT.transaction_source_type_id = 5
481: AND MMT.transaction_type_id = 35
482: AND MMT.primary_quantity < 0

Line 504: CST_ITEM_COSTS CIC

500: CURSOR c_item_cost IS
501: SELECT CIC.item_cost
502: FROM MTL_MATERIAL_TRANSACTIONS MMT,
503: WIP_ENTITIES WIP ,
504: CST_ITEM_COSTS CIC
505: WHERE MMT.transaction_source_id = WIP.wip_entity_id
506: AND MMT.transaction_source_type_id = 5
507: AND MMT.transaction_type_id = 35
508: AND MMT.primary_quantity < 0