[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
CSD_AHL_W_CONTRACT_XREF_PKG.Insert_Row(
px_WARRANTY_CONTRACT_XREF_ID => x_WARRANTY_CONTRACT_XREF_ID
,p_OBJECT_VERSION_NUMBER => 1
,p_CREATED_BY => G_USER_ID
,p_CREATION_DATE => SYSDATE
,p_LAST_UPDATED_BY => G_USER_ID
,p_LAST_UPDATE_DATE => SYSDATE
,p_LAST_UPDATE_LOGIN => G_LOGIN_ID
,p_SOURCE_TABLE => p_WARRANTY_rec.SOURCE_TABLE
,p_SOURCE_COLUMN => p_WARRANTY_rec.SOURCE_COLUMN
,p_SOURCE_ID => p_WARRANTY_rec.SOURCE_ID
,p_WARRANTY_CONTRACT_ID => p_WARRANTY_rec.WARRANTY_CONTRACT_ID
,p_ATTRIBUTE_CATEGORY => p_WARRANTY_rec.ATTRIBUTE_CATEGORY
,p_ATTRIBUTE1 => p_WARRANTY_rec.ATTRIBUTE1
,p_ATTRIBUTE2 => p_WARRANTY_rec.ATTRIBUTE2
,p_ATTRIBUTE3 => p_WARRANTY_rec.ATTRIBUTE3
,p_ATTRIBUTE4 => p_WARRANTY_rec.ATTRIBUTE4
,p_ATTRIBUTE5 => p_WARRANTY_rec.ATTRIBUTE5
,p_ATTRIBUTE6 => p_WARRANTY_rec.ATTRIBUTE6
,p_ATTRIBUTE7 => p_WARRANTY_rec.ATTRIBUTE7
,p_ATTRIBUTE8 => p_WARRANTY_rec.ATTRIBUTE8
,p_ATTRIBUTE9 => p_WARRANTY_rec.ATTRIBUTE9
,p_ATTRIBUTE10 => p_WARRANTY_rec.ATTRIBUTE10
,p_ATTRIBUTE11 => p_WARRANTY_rec.ATTRIBUTE11
,p_ATTRIBUTE12 => p_WARRANTY_rec.ATTRIBUTE12
,p_ATTRIBUTE13 => p_WARRANTY_rec.ATTRIBUTE13
,p_ATTRIBUTE14 => p_WARRANTY_rec.ATTRIBUTE14
,p_ATTRIBUTE15 => p_WARRANTY_rec.ATTRIBUTE15
,p_REPAIR_LINE_ID => p_WARRANTY_rec.REPAIR_LINE_ID
,p_INSTANCE_ID => p_WARRANTY_rec.INSTANCE_ID); --yvchen
SELECT repairs.CUSTOMER_PRODUCT_ID
FROM CSD_REPAIRS REPAIRS, wip_entities wip
WHERE repairs.repair_line_id = p_Repair_Line_Id
and wip.wip_entity_id = p_wip_entity_id
and repairs.inventory_item_id = wip.primary_item_id;
SELECT count(contract.warranty_contract_id)
FROM AHL_WARRANTY_CONTRACTS_B contract
WHERE contract.contract_status_code = 'ACTIVE'
AND TRUNC(NVL(contract.expiration_date, SYSDATE + 1)) > TRUNC(sysdate)
AND contract.item_instance_id = p_instance_id;
SELECT contract.warranty_contract_id
FROM AHL_WARRANTY_CONTRACTS_B contract
WHERE contract.contract_status_code = 'ACTIVE'
AND TRUNC(NVL(contract.expiration_date, SYSDATE + 1)) > TRUNC(sysdate)
AND contract.item_instance_id = p_instance_id;
SELECT (nvl(mat.item_cost, 0)+ nvl(res.resource_cost, 0)) total_cost
FROM
( SELECT SUM( abs(mmt.primary_quantity)*CIC.item_cost) item_cost
FROM MTL_MATERIAL_TRANSACTIONS MMT,
WIP_ENTITIES WIP ,
CST_ITEM_COSTS CIC
WHERE MMT.transaction_source_id = WIP.wip_entity_id
AND MMT.transaction_source_type_id = 5
AND MMT.transaction_type_id = 35
AND MMT.primary_quantity < 0
AND MMT.inventory_item_id <> nvl(WIP.primary_item_id, -999)
AND WIP.wip_entity_id = p_wip_entity_id
AND CIC.inventory_item_id = MMT.inventory_item_id
AND CIC.organization_id = WIP.organization_id
AND CIC.cost_type_id = 1
) mat,
(SELECT SUM( NVL( WTXN.primary_quantity, 0 )*CRC.resource_rate) resource_cost
FROM WIP_TRANSACTIONS WTXN,
CST_RESOURCE_COSTS CRC,
WIP_ENTITIES WIP
WHERE WTXN.wip_entity_id = p_wip_entity_id
AND WTXN.wip_entity_id = wip.wip_entity_id
AND WTXN.transaction_type IN( 1, 2, 3 )
AND CRC.resource_id = WTXN.resource_id
AND CRC.organization_id = wip.organization_id
AND CRC.cost_type_id = 1 ) res;
SELECT CIC.item_cost
FROM MTL_MATERIAL_TRANSACTIONS MMT,
WIP_ENTITIES WIP ,
CST_ITEM_COSTS CIC
WHERE MMT.transaction_source_id = WIP.wip_entity_id
AND MMT.transaction_source_type_id = 5
AND MMT.transaction_type_id = 35
AND MMT.primary_quantity < 0
AND MMT.inventory_item_id <> nvl(WIP.primary_item_id, -999)
AND MMT.inventory_item_id = p_inventory_item_id
AND WIP.wip_entity_id = p_wip_entity_id
AND CIC.inventory_item_id = MMT.inventory_item_id
AND CIC.organization_id = WIP.organization_id
AND CIC.cost_type_id = 1
AND rownum = 1;