[Home] [Help]
206:
207: CURSOR C1_get_instance_id(p_wip_entity_id number, p_Repair_Line_Id number)
208: IS
209: SELECT repairs.CUSTOMER_PRODUCT_ID
210: FROM CSD_REPAIRS REPAIRS, wip_entities wip
211: WHERE repairs.repair_line_id = p_Repair_Line_Id
212: and wip.wip_entity_id = p_wip_entity_id
213: and repairs.inventory_item_id = wip.primary_item_id;
214:
294: OPEN C3_get_w_contract_id (l_instance_id);
295: FETCH C3_get_w_contract_id INTO l_warranty_contract_id;
296: CLOSE C3_get_w_contract_id;
297:
298: l_WARRANTY_Rec.SOURCE_TABLE := 'WIP_ENTITIES';
299: l_WARRANTY_Rec.SOURCE_COLUMN := 'WIP_ENTITY_ID';
300: l_WARRANTY_Rec.SOURCE_ID := P_Wip_Entity_Id;
301:
302: --yvchen: if only 1 contract, set it as default; if >1 contracts, do not set default
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
481: AND MMT.transaction_type_id = 35
488: ) mat,
489: (SELECT SUM( NVL( WTXN.primary_quantity, 0 )*CRC.resource_rate) resource_cost
490: FROM WIP_TRANSACTIONS WTXN,
491: CST_RESOURCE_COSTS CRC,
492: WIP_ENTITIES WIP
493: WHERE WTXN.wip_entity_id = p_wip_entity_id
494: AND WTXN.wip_entity_id = wip.wip_entity_id
495: AND WTXN.transaction_type IN( 1, 2, 3 )
496: AND CRC.resource_id = WTXN.resource_id
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
507: AND MMT.transaction_type_id = 35