APPS.AHL_WARRANTY_CONTRACTS_PVT dependencies on AHL_WARRANTY_TMPL_ITEMS

Line 54: FROM AHL_WARRANTY_TMPL_ITEMS ASSOC,

50: CURSOR auto_assign_item_instances_csr
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

Line 331: AHL_WARRANTY_TMPL_ITEMS ASSOC,

327: AWTB.CONTRACT_EXPIRY_TYPE,
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

Line 754: FROM AHL_WARRANTY_TMPL_ITEMS

750: -- cursor to check template item's enabled flag
751: CURSOR chk_tmpl_item_flag_csr (c_warranty_tmpl_id NUMBER, c_warranty_item_id NUMBER,
752: c_item_org_id NUMBER) IS
753: SELECT 'X'
754: FROM AHL_WARRANTY_TMPL_ITEMS
755: WHERE warranty_template_id = c_warranty_tmpl_id
756: AND inventory_item_id = c_warranty_item_id
757: AND inventory_org_id = c_item_org_id
758: AND enabled_flag = 'Y';