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_UMP_PROCESSUNIT_PVT dependencies on CSI_ITEM_INSTANCES

Line 1247: -- The contract number for which want to process csi_item_instances entitlement

1243: -- p_concurrent_flag IN VARCHAR2
1244: -- This flag will be 'Y' if called from a concurrent program. Based on this flag, the error
1245: -- and informational messages will be logged into the log file.
1246: -- p_contract_number IN VARCHAR2
1247: -- The contract number for which want to process csi_item_instances entitlement
1248: -- p_contract_number IN VARCHAR2
1249: -- The contract number modifier for above contract number
1250:
1251: PROCEDURE Process_PM_Contracts

Line 1503: FROM csi_item_instances csi,

1499: -- uncommented query to fix performance issue 6893404
1500: -- declare cursor to retrieve min/max instances from Installed Base for PM installation.
1501: CURSOR csi_pm_instance_csr IS
1502: SELECT min(instance_id), max(instance_id)
1503: FROM csi_item_instances csi,
1504: (select me.inventory_item_id
1505: from ahl_mr_effectivities me, ahl_mr_headers_app_v mr
1506: where mr.mr_header_id = me.mr_header_id
1507: and mr.type_code = 'PROGRAM') mre

Line 1594: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS

1590: x_expired_flag OUT NOCOPY VARCHAR2)
1591: IS
1592:
1593: -- To validate instance.
1594: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS
1595: SELECT instance_number, active_end_date,
1596: inventory_item_id,
1597: inv_master_organization_id
1598: FROM csi_item_instances

Line 1598: FROM csi_item_instances

1594: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS
1595: SELECT instance_number, active_end_date,
1596: inventory_item_id,
1597: inv_master_organization_id
1598: FROM csi_item_instances
1599: WHERE instance_id = p_csi_item_instance_id;
1600:
1601: l_inventory_item_id NUMBER;
1602: l_inv_master_organization_id NUMBER;

Line 1603: l_instance_number csi_item_instances.instance_number%TYPE;

1599: WHERE instance_id = p_csi_item_instance_id;
1600:
1601: l_inventory_item_id NUMBER;
1602: l_inv_master_organization_id NUMBER;
1603: l_instance_number csi_item_instances.instance_number%TYPE;
1604: l_active_end_date DATE;
1605: l_expired_flag VARCHAR2(1);
1606:
1607: BEGIN

Line 1618: OPEN csi_item_instances_csr (p_csi_item_instance_id);

1614: l_expired_flag := 'N';
1615:
1616: -- Validate csi_item_instance_id.
1617: IF (p_csi_item_instance_id IS NOT NULL) THEN
1618: OPEN csi_item_instances_csr (p_csi_item_instance_id);
1619: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date,
1620: l_inventory_item_id, l_inv_master_organization_id;
1621: IF (csi_item_instances_csr%NOTFOUND) THEN
1622: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');

Line 1619: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date,

1615:
1616: -- Validate csi_item_instance_id.
1617: IF (p_csi_item_instance_id IS NOT NULL) THEN
1618: OPEN csi_item_instances_csr (p_csi_item_instance_id);
1619: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date,
1620: l_inventory_item_id, l_inv_master_organization_id;
1621: IF (csi_item_instances_csr%NOTFOUND) THEN
1622: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
1623: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);

Line 1621: IF (csi_item_instances_csr%NOTFOUND) THEN

1617: IF (p_csi_item_instance_id IS NOT NULL) THEN
1618: OPEN csi_item_instances_csr (p_csi_item_instance_id);
1619: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date,
1620: l_inventory_item_id, l_inv_master_organization_id;
1621: IF (csi_item_instances_csr%NOTFOUND) THEN
1622: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
1623: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);
1624: FND_MSG_PUB.ADD;
1625: CLOSE csi_item_instances_csr;

Line 1625: CLOSE csi_item_instances_csr;

1621: IF (csi_item_instances_csr%NOTFOUND) THEN
1622: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
1623: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);
1624: FND_MSG_PUB.ADD;
1625: CLOSE csi_item_instances_csr;
1626: --dbms_output.put_line('Instance not found');
1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1628: ELSIF l_active_end_date <= sysdate THEN
1629: /* Bypass error to fix bug# 8567880. For expired

Line 1639: CLOSE csi_item_instances_csr;

1635: */
1636: l_expired_flag := 'Y';
1637: END IF;
1638:
1639: CLOSE csi_item_instances_csr;
1640: END IF;
1641:
1642: x_inventory_item_id := l_inventory_item_id;
1643: x_inv_master_organization_id := l_inv_master_organization_id;

Line 1933: FROM ahl_uf_headers uh, ahl_uf_details ud, csi_item_instances csi

1929: WHERE csi_item_instance_id = p_csi_item_instance_id;
1930:
1931: CURSOR ahl_pm_item_uf_csr (p_csi_item_instance_id IN NUMBER) IS
1932: SELECT uom_code, start_date, end_date, usage_per_day
1933: FROM ahl_uf_headers uh, ahl_uf_details ud, csi_item_instances csi
1934: WHERE uh.uf_header_id = ud.uf_header_id
1935: AND csi.instance_id = p_csi_item_instance_id
1936: AND csi.inventory_item_id = uh.inventory_item_id
1937: AND trunc(nvl(end_date, sysdate)) >= trunc(sysdate)

Line 9593: FROM ahl_unit_effectivities_app_v ue, csi_item_instances cii

9589: -- added inventory_item_id, inv_master_organization_id to fix bug# 9284692
9590: CURSOR ahl_unit_effectivity_csr (p_unit_effectivity_id IN NUMBER) IS
9591: SELECT ue.csi_item_instance_id, ue.mr_header_id, cii.inventory_item_id,
9592: cii.inv_master_organization_id
9593: FROM ahl_unit_effectivities_app_v ue, csi_item_instances cii
9594: WHERE ue.unit_effectivity_id = p_unit_effectivity_id
9595: AND ue.csi_item_instance_id = cii.instance_id;
9596:
9597: -- Get MR details.

Line 11821: FROM csi_item_instances

11817: CURSOR get_minmax_inst_csr(c_inventory_item_id IN NUMBER,
11818: c_inventory_org_id IN NUMBER)
11819: IS
11820: SELECT min(instance_id), max(instance_id), count(instance_id)
11821: FROM csi_item_instances
11822: WHERE inventory_item_id = c_inventory_item_id
11823: AND inv_master_organization_id = c_inventory_org_id
11824: AND SYSDATE between trunc(nvl(active_start_date,sysdate)) and
11825: trunc(nvl(active_end_date,sysdate+1))

Line 11834: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi

11830: c_start_inst_id IN NUMBER,
11831: c_end_inst_id IN NUMBER)
11832: IS
11833: SELECT cii.instance_id
11834: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi
11835: WHERE cii.inventory_item_id = msi.inventory_item_id
11836: AND cii.inv_master_organization_id = msi.organization_id
11837: AND cii.inventory_item_id = mre.inventory_item_id
11838: AND mre.mr_header_id = p_mr_header_id

Line 12092: FROM csi_item_instances csi, ahl_mr_effectivities me

12088: cursor csi_inst_count_csr (p_start_inst_id in number,
12089: p_end_inst_id in number,
12090: p_mr_header_id in number) IS
12091: SELECT count(instance_id)
12092: FROM csi_item_instances csi, ahl_mr_effectivities me
12093: WHERE csi.instance_id >= p_start_inst_id and csi.instance_id <= p_end_inst_id
12094: AND csi.inventory_item_id = me.inventory_item_id
12095: AND me.mr_header_id = p_mr_header_id
12096: AND SYSDATE between trunc(nvl(active_start_date,sysdate)) and

Line 12287: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi

12283: c_start_inst_id IN NUMBER,
12284: c_end_inst_id IN NUMBER)
12285: IS
12286: SELECT cii.instance_id
12287: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi
12288: -- repalced mtl_system_items_kfv with mtl_system items_b.
12289: WHERE cii.inventory_item_id = msi.inventory_item_id
12290: AND cii.inv_master_organization_id = msi.organization_id
12291: AND cii.inventory_item_id = mre.inventory_item_id

Line 12303: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi,

12299: CURSOR get_all_inst( c_start_inst_id IN NUMBER,
12300: c_end_inst_id IN NUMBER)
12301: IS
12302: SELECT cii.instance_id
12303: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi,
12304: (select mr_header_id
12305: from ahl_mr_headers_app_v
12306: where type_code = 'PROGRAM') mr
12307: WHERE cii.inventory_item_id = msi.inventory_item_id

Line 12800: FROM ahl_unit_config_headers uc, csi_item_instances ii

12796: -- installed on a instance which is not a UC.
12797: -- see second issue reported in bug# 8326078
12798: CURSOR ahl_unit_config_header_csr IS
12799: SELECT csi_item_instance_id
12800: FROM ahl_unit_config_headers uc, csi_item_instances ii
12801: WHERE uc.csi_item_instance_id = ii.instance_id
12802: AND trunc(nvl(uc.active_start_date,sysdate)) <= trunc(sysdate)
12803: AND trunc(sysdate) < trunc(nvl(uc.active_end_date,sysdate+1))
12804: AND trunc(nvl(ii.active_start_date,sysdate)) <= trunc(sysdate)

Line 12822: FROM ahl_unit_config_headers uc, csi_item_instances ii

12818: -- installed on a instance which is not a UC.
12819: -- see second issue reported in bug# 8326078
12820: CURSOR ahl_unit_itemcat_csr(p_mtl_category_id IN NUMBER) IS
12821: SELECT csi_item_instance_id
12822: FROM ahl_unit_config_headers uc, csi_item_instances ii
12823: WHERE uc.csi_item_instance_id = ii.instance_id
12824: AND trunc(nvl(uc.active_start_date,sysdate)) <= trunc(sysdate)
12825: AND trunc(sysdate) < trunc(nvl(uc.active_end_date,sysdate+1))
12826: AND trunc(nvl(ii.active_start_date,sysdate)) <= trunc(sysdate)

Line 12839: csi_item_instances cii2

12835: and trunc(sysdate) < trunc(nvl(iir.active_end_date,sysdate+1))
12836: )
12837: AND exists (select 'x'
12838: from mtl_category_set_valid_cats cs, mtl_item_categories itc,
12839: csi_item_instances cii2
12840: where cs.category_set_id = fnd_profile.value('AHL_BUE_ITEM_CATEGORY_SET')
12841: AND cs.category_set_id = itc.category_set_id
12842: AND cs.category_id = itc.category_id
12843: AND itc.category_id = p_mtl_category_id

Line 12873: FROM csi_item_instances cii, ahl_mr_effectivities mre

12869: trunc(nvl(parent.active_start_date, sysdate)) <= trunc(sysdate) and
12870: trunc(sysdate) < trunc(nvl(parent.active_end_date, sysdate+1))
12871: ) Root_instance_id
12872:
12873: FROM csi_item_instances cii, ahl_mr_effectivities mre
12874: WHERE mre.inventory_item_id = nvl(null, mre.inventory_item_id)
12875: AND mre.mr_header_id = nvl(null,mre.mr_header_id)
12876: -- added nvl conditions above as this seems to force use of index on
12877: -- ahl_mr_headers_b and also brings query cost down.

Line 12950: FROM csi_item_instances cii,

12946: trunc(nvl(parent.active_start_date, sysdate)) <= trunc(sysdate) and
12947: trunc(sysdate) < trunc(nvl(parent.active_end_date, sysdate+1))
12948: ) Root_instance_id
12949:
12950: FROM csi_item_instances cii,
12951: (select distinct me.inventory_item_id
12952: from ahl_mr_headers_app_v mr, ahl_mr_effectivities me
12953: where mr.mr_header_id = me.mr_header_id AND
12954: mr.mr_status_code = 'COMPLETE' AND

Line 12967: csi_item_instances cii2

12963: )
12964: ) valid_inst
12965: WHERE exists (select 'x'
12966: from mtl_category_set_valid_cats cs, mtl_item_categories itc,
12967: csi_item_instances cii2
12968: where cs.category_set_id = fnd_profile.value('AHL_BUE_ITEM_CATEGORY_SET')
12969: AND cs.category_set_id = itc.category_set_id
12970: AND cs.category_id = itc.category_id
12971: AND itc.category_id = p_mtl_category_id

Line 13014: FROM csi_item_instances cii,

13010: -- added to fix bug#8543402
13011: -- check if UMP data exists for expired instances.
13012: CURSOR chk_expire_inst_csr IS
13013: SELECT cii.instance_id
13014: FROM csi_item_instances cii,
13015: (select distinct me.inventory_item_id
13016: from ahl_mr_headers_app_v mr, ahl_mr_effectivities me
13017: where mr.mr_header_id = me.mr_header_id AND
13018: mr.mr_status_code = 'COMPLETE' AND

Line 13688: FROM csi_item_instances cii, ahl_mr_instances_temp mr

13684: trunc(nvl(parent.active_start_date, sysdate)) <= trunc(sysdate) and
13685: trunc(sysdate) < trunc(nvl(parent.active_end_date, sysdate+1))
13686: ) Root_instance_id
13687:
13688: FROM csi_item_instances cii, ahl_mr_instances_temp mr
13689: WHERE trunc(nvl(cii.active_start_date, sysdate)) <= trunc(sysdate) AND
13690: trunc(sysdate) < trunc(nvl(cii.active_end_date, sysdate+1))
13691: AND mr.item_instance_id = cii.instance_id
13692: )

Line 13748: FROM csi_item_instances cii,ahl_mr_instances_temp mr

13744: trunc(nvl(parent.active_start_date, sysdate)) <= trunc(sysdate) and
13745: trunc(sysdate) < trunc(nvl(parent.active_end_date, sysdate+1))
13746: ) Root_instance_id
13747:
13748: FROM csi_item_instances cii,ahl_mr_instances_temp mr
13749: WHERE trunc(nvl(cii.active_start_date, sysdate)) <= trunc(sysdate) AND
13750: trunc(sysdate) < trunc(nvl(cii.active_end_date, sysdate+1))
13751: AND mr.item_instance_id = cii.instance_id
13752: )

Line 13756: csi_item_instances cii2

13752: )
13753: ) valid_inst
13754: WHERE exists (select 'x'
13755: from mtl_category_set_valid_cats cs, mtl_item_categories itc,
13756: csi_item_instances cii2
13757: where cs.category_set_id = fnd_profile.value('AHL_BUE_ITEM_CATEGORY_SET')
13758: AND cs.category_set_id = itc.category_set_id
13759: AND cs.category_id = itc.category_id
13760: AND itc.category_id = p_mtl_category_id

Line 14524: FROM csi_item_instances cii

14520:
14521: CURSOR ahl_item_instance_csr (p_item_instance_id IN NUMBER) IS
14522: SELECT cii.inventory_item_id,
14523: cii.inv_master_organization_id
14524: FROM csi_item_instances cii
14525: WHERE cii.instance_id = p_item_instance_id;
14526:
14527:
14528: -- get the configuration structure.(G_config_node_tbl).

Line 16229: FROM ahl_unit_effectivities_app_v ue, csi_item_instances cii

16225: -- added inventory_item_id, inv_master_organization_id to fix bug# 9284692
16226: CURSOR ahl_unit_effectivity_csr (p_unit_effectivity_id IN NUMBER) IS
16227: SELECT ue.csi_item_instance_id, ue.mr_header_id, cii.inventory_item_id,
16228: cii.inv_master_organization_id
16229: FROM ahl_unit_effectivities_app_v ue, csi_item_instances cii
16230: WHERE ue.unit_effectivity_id = p_unit_effectivity_id
16231: AND ue.csi_item_instance_id = cii.instance_id;
16232:
16233: -- Get MR details.