APPS.CSD_WARRANTY_CONTRACT_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 476: FROM MTL_MATERIAL_TRANSACTIONS MMT,

472: CURSOR c_total_job_cost IS
473: SELECT (nvl(mat.item_cost, 0)+ nvl(res.resource_cost, 0)) total_cost
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

Line 502: FROM MTL_MATERIAL_TRANSACTIONS MMT,

498: AND CRC.cost_type_id = 1 ) res;
499:
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