eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_WARRANTY_CONTRACTS_PVT dependencies on CSI_ITEM_INSTANCES

Line 55: CSI_ITEM_INSTANCES INSTANCE

51: IS
52: SELECT ASSOC.WARRANTY_TEMPLATE_ID,
53: INSTANCE.INSTANCE_ID
54: FROM AHL_WARRANTY_TMPL_ITEMS ASSOC,
55: CSI_ITEM_INSTANCES INSTANCE
56: WHERE ASSOC.INVENTORY_ITEM_ID = INSTANCE.INVENTORY_ITEM_ID
57: AND ASSOC.INVENTORY_ORG_ID = INSTANCE.INV_MASTER_ORGANIZATION_ID
58: -- avikukum :: changes for bug# 11664006 :: START
59: AND TRUNC(NVL(INSTANCE.ACTIVE_START_DATE, SYSDATE)) <= TRUNC(SYSDATE)

Line 315: FROM CSI_ITEM_INSTANCES

311:
312: -- cursor to validate the given instance id
313: CURSOR validate_instance_csr (c_item_instance_id NUMBER) IS
314: SELECT 'X'
315: FROM CSI_ITEM_INSTANCES
316: WHERE INSTANCE_ID = c_item_instance_id;
317:
318: -- cursor to fetch the details of the given template id
319: CURSOR warranty_template_csr (c_warranty_template_id NUMBER, c_item_instance_id NUMBER ) IS

Line 332: CSI_ITEM_INSTANCES INSTANCE

328: AWTB.CLAIM_LABOUR_HOURS,
329: ASSOC.OSP_CLAIM_FLAG
330: FROM AHL_WARRANTY_TEMPLATES_B AWTB,
331: AHL_WARRANTY_TMPL_ITEMS ASSOC,
332: CSI_ITEM_INSTANCES INSTANCE
333: WHERE AWTB.WARRANTY_TEMPLATE_ID = c_warranty_template_id
334: AND INSTANCE.INSTANCE_ID = c_item_instance_id
335: AND ASSOC.WARRANTY_TEMPLATE_ID = AWTB.WARRANTY_TEMPLATE_ID
336: AND ASSOC.INVENTORY_ITEM_ID = INSTANCE.INVENTORY_ITEM_ID