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 1060: -- The contract number for which want to process csi_item_instances entitlement

1056: -- p_concurrent_flag IN VARCHAR2
1057: -- This flag will be 'Y' if called from a concurrent program. Based on this flag, the error
1058: -- and informational messages will be logged into the log file.
1059: -- p_contract_number IN VARCHAR2
1060: -- The contract number for which want to process csi_item_instances entitlement
1061: -- p_contract_number IN VARCHAR2
1062: -- The contract number modifier for above contract number
1063:
1064: PROCEDURE Process_PM_Contracts

Line 1314: FROM csi_item_instances csi,

1310: -- uncommented query to fix performance issue 6893404
1311: -- declare cursor to retrieve min/max instances from Installed Base for PM installation.
1312: CURSOR csi_pm_instance_csr IS
1313: SELECT min(instance_id), max(instance_id)
1314: FROM csi_item_instances csi,
1315: (select me.inventory_item_id
1316: from ahl_mr_effectivities me, ahl_mr_headers_app_v mr
1317: where mr.mr_header_id = me.mr_header_id
1318: and mr.type_code = 'PROGRAM') mre

Line 1383: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS

1379: x_inv_master_organization_id OUT NOCOPY NUMBER)
1380: IS
1381:
1382: -- To validate instance.
1383: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS
1384: SELECT instance_number, active_end_date, inventory_item_id,
1385: inv_master_organization_id
1386: FROM csi_item_instances
1387: WHERE instance_id = p_csi_item_instance_id;

Line 1386: FROM csi_item_instances

1382: -- To validate instance.
1383: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS
1384: SELECT instance_number, active_end_date, inventory_item_id,
1385: inv_master_organization_id
1386: FROM csi_item_instances
1387: WHERE instance_id = p_csi_item_instance_id;
1388:
1389: l_inventory_item_id NUMBER;
1390: l_inv_master_organization_id NUMBER;

Line 1391: l_instance_number csi_item_instances.instance_number%TYPE;

1387: WHERE instance_id = p_csi_item_instance_id;
1388:
1389: l_inventory_item_id NUMBER;
1390: l_inv_master_organization_id NUMBER;
1391: l_instance_number csi_item_instances.instance_number%TYPE;
1392: l_active_end_date DATE;
1393:
1394: BEGIN
1395:

Line 1402: OPEN csi_item_instances_csr (p_csi_item_instance_id);

1398: END IF;
1399:
1400: -- Validate csi_item_instance_id.
1401: IF (p_csi_item_instance_id IS NOT NULL) THEN
1402: OPEN csi_item_instances_csr (p_csi_item_instance_id);
1403: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date,
1404: l_inventory_item_id, l_inv_master_organization_id;
1405: IF (csi_item_instances_csr%NOTFOUND) THEN
1406: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');

Line 1403: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date,

1399:
1400: -- Validate csi_item_instance_id.
1401: IF (p_csi_item_instance_id IS NOT NULL) THEN
1402: OPEN csi_item_instances_csr (p_csi_item_instance_id);
1403: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date,
1404: l_inventory_item_id, l_inv_master_organization_id;
1405: IF (csi_item_instances_csr%NOTFOUND) THEN
1406: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
1407: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);

Line 1405: IF (csi_item_instances_csr%NOTFOUND) THEN

1401: IF (p_csi_item_instance_id IS NOT NULL) THEN
1402: OPEN csi_item_instances_csr (p_csi_item_instance_id);
1403: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date,
1404: l_inventory_item_id, l_inv_master_organization_id;
1405: IF (csi_item_instances_csr%NOTFOUND) THEN
1406: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
1407: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);
1408: FND_MSG_PUB.ADD;
1409: CLOSE csi_item_instances_csr;

Line 1409: CLOSE csi_item_instances_csr;

1405: IF (csi_item_instances_csr%NOTFOUND) THEN
1406: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
1407: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);
1408: FND_MSG_PUB.ADD;
1409: CLOSE csi_item_instances_csr;
1410: --dbms_output.put_line('Instance not found');
1411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1412: ELSIF (trunc(l_active_end_date) < trunc(sysdate)) THEN
1413: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INST_EXPIRED');

Line 1419: CLOSE csi_item_instances_csr;

1415: FND_MSG_PUB.ADD;
1416: --dbms_output.put_line('Instance has expired');
1417: END IF;
1418:
1419: CLOSE csi_item_instances_csr;
1420: END IF;
1421:
1422: x_inventory_item_id := l_inventory_item_id;
1423: x_inv_master_organization_id := l_inv_master_organization_id;

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

1708: WHERE csi_item_instance_id = p_csi_item_instance_id;
1709:
1710: CURSOR ahl_pm_item_uf_csr (p_csi_item_instance_id IN NUMBER) IS
1711: SELECT uom_code, start_date, end_date, usage_per_day
1712: FROM ahl_uf_headers uh, ahl_uf_details ud, csi_item_instances csi
1713: WHERE uh.uf_header_id = ud.uf_header_id
1714: AND csi.instance_id = p_csi_item_instance_id
1715: AND csi.inventory_item_id = uh.inventory_item_id
1716: AND trunc(nvl(end_date, sysdate)) >= trunc(sysdate)

Line 10212: FROM csi_item_instances

10208: CURSOR get_minmax_inst_csr(c_inventory_item_id IN NUMBER,
10209: c_inventory_org_id IN NUMBER)
10210: IS
10211: SELECT min(instance_id), max(instance_id), count(instance_id)
10212: FROM csi_item_instances
10213: WHERE inventory_item_id = c_inventory_item_id
10214: AND inv_master_organization_id = c_inventory_org_id
10215: AND SYSDATE between trunc(nvl(active_start_date,sysdate)) and
10216: trunc(nvl(active_end_date,sysdate+1))

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

10221: c_start_inst_id IN NUMBER,
10222: c_end_inst_id IN NUMBER)
10223: IS
10224: SELECT cii.instance_id
10225: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi
10226: WHERE cii.inventory_item_id = msi.inventory_item_id
10227: AND cii.inv_master_organization_id = msi.organization_id
10228: AND cii.inventory_item_id = mre.inventory_item_id
10229: AND mre.mr_header_id = p_mr_header_id

Line 10483: FROM csi_item_instances csi, ahl_mr_effectivities me

10479: cursor csi_inst_count_csr (p_start_inst_id in number,
10480: p_end_inst_id in number,
10481: p_mr_header_id in number) IS
10482: SELECT count(instance_id)
10483: FROM csi_item_instances csi, ahl_mr_effectivities me
10484: WHERE csi.instance_id >= p_start_inst_id and csi.instance_id <= p_end_inst_id
10485: AND csi.inventory_item_id = me.inventory_item_id
10486: AND me.mr_header_id = p_mr_header_id
10487: AND SYSDATE between trunc(nvl(active_start_date,sysdate)) and

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

10674: c_start_inst_id IN NUMBER,
10675: c_end_inst_id IN NUMBER)
10676: IS
10677: SELECT cii.instance_id
10678: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi
10679: -- repalced mtl_system_items_kfv with mtl_system items_b.
10680: WHERE cii.inventory_item_id = msi.inventory_item_id
10681: AND cii.inv_master_organization_id = msi.organization_id
10682: AND cii.inventory_item_id = mre.inventory_item_id

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

10690: CURSOR get_all_inst( c_start_inst_id IN NUMBER,
10691: c_end_inst_id IN NUMBER)
10692: IS
10693: SELECT cii.instance_id
10694: FROM csi_item_instances cii, ahl_mr_effectivities mre, mtl_system_items_b msi,
10695: (select mr_header_id
10696: from ahl_mr_headers_app_v
10697: where type_code = 'PROGRAM') mr
10698: WHERE cii.inventory_item_id = msi.inventory_item_id

Line 11152: csi_item_instances cii2

11148: AND unit_config_status_code <> 'DRAFT'
11149: AND parent_uc_header_id IS NULL
11150: AND exists (select 'x'
11151: from mtl_category_set_valid_cats cs, mtl_item_categories itc,
11152: csi_item_instances cii2
11153: where cs.category_set_id = fnd_profile.value('AHL_BUE_ITEM_CATEGORY_SET')
11154: AND cs.category_set_id = itc.category_set_id
11155: AND cs.category_id = itc.category_id
11156: AND itc.category_id = p_mtl_category_id

Line 11186: FROM csi_item_instances cii, ahl_mr_effectivities mre

11182: trunc(nvl(parent.active_start_date, sysdate)) <= trunc(sysdate) and
11183: trunc(sysdate) < trunc(nvl(parent.active_end_date, sysdate+1))
11184: ) Root_instance_id
11185:
11186: FROM csi_item_instances cii, ahl_mr_effectivities mre
11187: WHERE mre.inventory_item_id = nvl(null, mre.inventory_item_id)
11188: AND mre.mr_header_id = nvl(null,mre.mr_header_id)
11189: -- added nvl conditions above as this seems to force use of index on
11190: -- ahl_mr_headers_b and also brings query cost down.

Line 11263: FROM csi_item_instances cii,

11259: trunc(nvl(parent.active_start_date, sysdate)) <= trunc(sysdate) and
11260: trunc(sysdate) < trunc(nvl(parent.active_end_date, sysdate+1))
11261: ) Root_instance_id
11262:
11263: FROM csi_item_instances cii,
11264: (select distinct me.inventory_item_id
11265: from ahl_mr_headers_app_v mr, ahl_mr_effectivities me
11266: where mr.mr_header_id = me.mr_header_id AND
11267: mr.mr_status_code = 'COMPLETE' AND

Line 11280: csi_item_instances cii2

11276: )
11277: ) valid_inst
11278: WHERE exists (select 'x'
11279: from mtl_category_set_valid_cats cs, mtl_item_categories itc,
11280: csi_item_instances cii2
11281: where cs.category_set_id = fnd_profile.value('AHL_BUE_ITEM_CATEGORY_SET')
11282: AND cs.category_set_id = itc.category_set_id
11283: AND cs.category_id = itc.category_id
11284: AND itc.category_id = p_mtl_category_id

Line 11826: FROM csi_item_instances cii, ahl_mr_instances_temp mr

11822: trunc(nvl(parent.active_start_date, sysdate)) <= trunc(sysdate) and
11823: trunc(sysdate) < trunc(nvl(parent.active_end_date, sysdate+1))
11824: ) Root_instance_id
11825:
11826: FROM csi_item_instances cii, ahl_mr_instances_temp mr
11827: WHERE trunc(nvl(cii.active_start_date, sysdate)) <= trunc(sysdate) AND
11828: trunc(sysdate) < trunc(nvl(cii.active_end_date, sysdate+1))
11829: AND mr.item_instance_id = cii.instance_id
11830: )

Line 11886: FROM csi_item_instances cii,ahl_mr_instances_temp mr

11882: trunc(nvl(parent.active_start_date, sysdate)) <= trunc(sysdate) and
11883: trunc(sysdate) < trunc(nvl(parent.active_end_date, sysdate+1))
11884: ) Root_instance_id
11885:
11886: FROM csi_item_instances cii,ahl_mr_instances_temp mr
11887: WHERE trunc(nvl(cii.active_start_date, sysdate)) <= trunc(sysdate) AND
11888: trunc(sysdate) < trunc(nvl(cii.active_end_date, sysdate+1))
11889: AND mr.item_instance_id = cii.instance_id
11890: )

Line 11894: csi_item_instances cii2

11890: )
11891: ) valid_inst
11892: WHERE exists (select 'x'
11893: from mtl_category_set_valid_cats cs, mtl_item_categories itc,
11894: csi_item_instances cii2
11895: where cs.category_set_id = fnd_profile.value('AHL_BUE_ITEM_CATEGORY_SET')
11896: AND cs.category_set_id = itc.category_set_id
11897: AND cs.category_id = itc.category_id
11898: AND itc.category_id = p_mtl_category_id