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_UNITMAINT_PVT dependencies on AHL_UNIT_EFFECTIVITIES_APP_V

Line 992: FROM AHL_UNIT_EFFECTIVITIES_APP_V

988: CURSOR l_prior_initializations_csr(p_mr_id IN NUMBER,
989: p_item_instance_id IN NUMBER,
990: p_ue_id IN NUMBER) IS
991: SELECT 'x'
992: FROM AHL_UNIT_EFFECTIVITIES_APP_V
993: -- SALOGAN added outer join to MR Header id for Complex Mx
994: WHERE MR_HEADER_ID(+) = p_mr_id AND
995: CSI_ITEM_INSTANCE_ID = p_item_instance_id AND
996: status_code IN ('INIT-DUE', 'INIT-ACCOMPLISHED') AND

Line 1001: FROM AHL_UNIT_EFFECTIVITIES_APP_V

997: UNIT_EFFECTIVITY_ID <> p_ue_id;
998:
999: CURSOR l_ue_details_csr(p_ue_id IN NUMBER) IS
1000: SELECT MR_HEADER_ID, CSI_ITEM_INSTANCE_ID, REPETITIVE_MR_FLAG, STATUS_CODE
1001: FROM AHL_UNIT_EFFECTIVITIES_APP_V
1002: WHERE UNIT_EFFECTIVITY_ID = p_ue_id;
1003:
1004: -- SALOGAN added the following for Complex Mx - Begin
1005: CURSOR is_NR_UE(p_ue_id IN NUMBER) IS

Line 1316: FROM csi_cp_counters_v co, ahl_unit_effectivities_app_v ue

1312:
1313: CURSOR l_get_counter_id(p_counter_name IN VARCHAR2,
1314: p_ue_id IN NUMBER) IS
1315: /*SELECT co.counter_id
1316: FROM csi_cp_counters_v co, ahl_unit_effectivities_app_v ue
1317: WHERE co.COUNTER_NAME = p_counter_name AND
1318: ue.UNIT_EFFECTIVITY_ID = p_ue_id AND
1319: ue.csi_item_instance_id = CUSTOMER_PRODUCT_ID;*/
1320:

Line 1324: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS_KFV MSITEM, ahl_unit_effectivities_app_v ue

1320:
1321: --performace tuning related change
1322:
1323: /*SELECT c.counter_id
1324: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS_KFV MSITEM, ahl_unit_effectivities_app_v ue
1325: WHERE C.COUNTER_GROUP_ID(+) = CTRGRP.COUNTER_GROUP_ID
1326: AND CTRGRP.SOURCE_OBJECT_CODE = 'CP'
1327: AND CTRGRP.SOURCE_OBJECT_ID = CII.INSTANCE_ID
1328: AND MSITEM.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID

Line 1388: FROM csi_cp_counters_v co, ahl_unit_effectivities_app_v ue

1384:
1385: CURSOR l_get_counter_id(p_counter_name IN VARCHAR2,
1386: p_ue_id IN NUMBER) IS
1387: /*SELECT co.counter_id
1388: FROM csi_cp_counters_v co, ahl_unit_effectivities_app_v ue
1389: WHERE co.COUNTER_NAME = p_counter_name AND
1390: ue.UNIT_EFFECTIVITY_ID = p_ue_id AND
1391: ue.csi_item_instance_id = CUSTOMER_PRODUCT_ID;*/
1392:

Line 1396: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS_KFV MSITEM, ahl_unit_effectivities_app_v ue

1392:
1393: --performace tuning related change
1394: /*
1395: SELECT c.counter_id
1396: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS_KFV MSITEM, ahl_unit_effectivities_app_v ue
1397: WHERE C.COUNTER_GROUP_ID(+) = CTRGRP.COUNTER_GROUP_ID
1398: AND CTRGRP.SOURCE_OBJECT_CODE = 'CP'
1399: AND CTRGRP.SOURCE_OBJECT_ID = CII.INSTANCE_ID
1400: AND MSITEM.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID

Line 1457: FROM ahl_unit_effectivities_app_v

1453: x_return_status IN OUT NOCOPY VARCHAR2) IS
1454:
1455: CURSOR l_invalid_descendents_csr(p_ue_id IN NUMBER) IS
1456: SELECT 'x'
1457: FROM ahl_unit_effectivities_app_v
1458: WHERE (status_code not in ('INIT-ACCOMPLISHED', 'TERMINATED', 'MR-TERMINATE', 'ACCOMPLISHED','SR-CLOSED','DEFERRED','CANCELLED') OR status_code IS NULL)
1459: AND unit_effectivity_id in (
1460: SELECT related_ue_id
1461: FROM ahl_ue_relationships

Line 1471: FROM AHL_UNIT_EFFECTIVITIES_APP_V

1467: CURSOR l_prior_initializations_csr(p_mr_id IN NUMBER,
1468: p_item_instance_id IN NUMBER,
1469: p_ue_id IN NUMBER) IS
1470: SELECT status_code
1471: FROM AHL_UNIT_EFFECTIVITIES_APP_V
1472: -- SALOGAN added outer join to MR Header id for Complex Mx
1473: WHERE MR_HEADER_ID(+) = p_mr_id AND
1474: CSI_ITEM_INSTANCE_ID = p_item_instance_id AND
1475: status_code IN ('INIT-DUE', 'INIT-ACCOMPLISHED','DEFERRED') AND

Line 1481: FROM AHL_UNIT_EFFECTIVITIES_APP_V

1477:
1478: CURSOR l_ue_details_csr(p_ue_id IN NUMBER) IS
1479: SELECT STATUS_CODE, OBJECT_VERSION_NUMBER, MR_HEADER_ID,
1480: CSI_ITEM_INSTANCE_ID, PRECEDING_UE_ID,SERVICE_LINE_ID, MANUALLY_PLANNED_FLAG
1481: FROM AHL_UNIT_EFFECTIVITIES_APP_V
1482: WHERE UNIT_EFFECTIVITY_ID = p_ue_id;
1483:
1484: -- Added p_service_line_id as part of bugfix 6903768(FP for bug# 5764351).
1485: CURSOR l_prior_ue_csr(p_mr_id IN NUMBER,

Line 1490: FROM AHL_UNIT_EFFECTIVITIES_APP_V

1486: p_item_instance_id IN NUMBER,
1487: p_service_line_id IN NUMBER) IS
1488: /*
1489: SELECT UNIT_EFFECTIVITY_ID
1490: FROM AHL_UNIT_EFFECTIVITIES_APP_V
1491: WHERE MR_HEADER_ID = p_mr_id AND
1492: CSI_ITEM_INSTANCE_ID = p_item_instance_id AND
1493: FORECAST_SEQUENCE = (SELECT MIN(FORECAST_SEQUENCE) FROM AHL_UNIT_EFFECTIVITIES_APP_V
1494: WHERE MR_HEADER_ID = p_mr_id AND

Line 1493: FORECAST_SEQUENCE = (SELECT MIN(FORECAST_SEQUENCE) FROM AHL_UNIT_EFFECTIVITIES_APP_V

1489: SELECT UNIT_EFFECTIVITY_ID
1490: FROM AHL_UNIT_EFFECTIVITIES_APP_V
1491: WHERE MR_HEADER_ID = p_mr_id AND
1492: CSI_ITEM_INSTANCE_ID = p_item_instance_id AND
1493: FORECAST_SEQUENCE = (SELECT MIN(FORECAST_SEQUENCE) FROM AHL_UNIT_EFFECTIVITIES_APP_V
1494: WHERE MR_HEADER_ID = p_mr_id AND
1495: CSI_ITEM_INSTANCE_ID = p_item_instance_id AND
1496: (STATUS_CODE IS NULL OR
1497: STATUS_CODE = 'INIT-DUE'))

Line 1514: FROM AHL_UNIT_EFFECTIVITIES_APP_V

1510: STATUS_CODE IN ('INIT-DUE'));
1511:
1512: CURSOR l_get_pred_details_csr(p_pred_ue_id IN NUMBER) IS
1513: SELECT MR_HEADER_ID, CSI_ITEM_INSTANCE_ID
1514: FROM AHL_UNIT_EFFECTIVITIES_APP_V
1515: WHERE UNIT_EFFECTIVITY_ID = p_pred_ue_id;
1516:
1517: CURSOR l_validate_status_csr(p_status_code IN VARCHAR2) IS
1518: SELECT 'x'

Line 2024: FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE

2020: CURSOR l_validate_counter_csr(p_ue_id IN NUMBER,
2021: p_counter_id IN NUMBER) IS
2022: /*
2023: SELECT NVL(net_reading, 0)
2024: FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE
2025: WHERE co.customer_product_id = ue.csi_item_instance_id and
2026: ue.unit_effectivity_id = p_ue_id and
2027: co.counter_id = p_counter_id;
2028: */

Line 2032: FROM csi_counter_values_v cv, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE

2028: */
2029:
2030: /*
2031: SELECT NVL(net_reading, 0)
2032: FROM csi_counter_values_v cv, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE
2033: WHERE cca.source_object_code = 'CP'
2034: AND cca.source_object_id = ue.csi_item_instance_id
2035: AND cca.counter_id = cv.counter_id
2036: AND ue.unit_effectivity_id = p_ue_id

Line 2045: FROM CSI_COUNTERS_B CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE

2041: -- csi_counter_values_v does not retrieve any row.
2042: -- split above cursor into 2 cursors.
2043: -- SATRAJEN :: Changed for USAF Backporting :: Feb 2012 :: Changed to use only the base table.
2044: SELECT 'x'
2045: FROM CSI_COUNTERS_B CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE
2046: WHERE cca.source_object_code = 'CP'
2047: AND cca.source_object_id = ue.csi_item_instance_id
2048: AND cca.counter_id = cc.counter_id
2049: AND ue.unit_effectivity_id = p_ue_id

Line 2220: FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE

2216: p_counter_id IN NUMBER) IS
2217:
2218: /*
2219: SELECT NVL(net_reading, 0)
2220: FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE
2221: WHERE co.customer_product_id = ue.csi_item_instance_id and
2222: ue.unit_effectivity_id = p_ue_id and
2223: co.counter_id = p_counter_id;
2224: */

Line 2230: FROM CSI_COUNTERS_B CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE

2226: -- csi_counter_values_v does not retrieve any row.
2227: -- split above cursor into 2 cursors.
2228: -- SATRAJEN :: Changed for USAF Backporting :: Feb 2012
2229: SELECT 'x'
2230: FROM CSI_COUNTERS_B CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE
2231: WHERE cca.source_object_code = 'CP'
2232: AND cca.source_object_id = ue.csi_item_instance_id
2233: AND cca.counter_id = cc.counter_id
2234: AND ue.unit_effectivity_id = p_ue_id

Line 2573: FROM AHL_UNIT_EFFECTIVITIES_APP_V

2569: ATTRIBUTE12,
2570: ATTRIBUTE13,
2571: ATTRIBUTE14,
2572: ATTRIBUTE15
2573: FROM AHL_UNIT_EFFECTIVITIES_APP_V
2574: WHERE unit_effectivity_id = p_ue_id
2575: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2576:
2577: CURSOR l_get_descendents(p_ue_id IN NUMBER) IS

Line 3138: FROM AHL_UNIT_EFFECTIVITIES_APP_V

3134: ATTRIBUTE12,
3135: ATTRIBUTE13,
3136: ATTRIBUTE14,
3137: ATTRIBUTE15
3138: FROM AHL_UNIT_EFFECTIVITIES_APP_V
3139: WHERE unit_effectivity_id = p_ue_id
3140: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3141:
3142: l_ue_rec l_get_unit_effectivity_csr%rowtype;

Line 4196: FROM AHL_UNIT_EFFECTIVITIES_APP_V EFF

4192: EFF.OBJECT_VERSION_NUMBER,
4193: EFF.LAST_UPDATE_DATE,
4194: EFF.LAST_UPDATED_BY ,
4195: EFF.LAST_UPDATE_LOGIN
4196: FROM AHL_UNIT_EFFECTIVITIES_APP_V EFF
4197: WHERE EFF.MR_HEADER_ID = p_header_id
4198: AND object_type = 'MR'
4199: -- AND (EFF.status_code is null or EFF.status_code in ('INIT-DUE','DEFERRED'))
4200: AND (EFF.status_code is null or EFF.status_code = 'INIT-DUE')

Line 4266: FROM AHL_UNIT_EFFECTIVITIES_APP_V EFF

4262: EFF.OBJECT_VERSION_NUMBER,
4263: EFF.LAST_UPDATE_DATE,
4264: EFF.LAST_UPDATED_BY,
4265: EFF.LAST_UPDATE_LOGIN
4266: FROM AHL_UNIT_EFFECTIVITIES_APP_V EFF
4267: WHERE EFF.UNIT_EFFECTIVITY_ID IN
4268: (SELECT REL.RELATED_UE_ID FROM AHL_UE_RELATIONSHIPS REL
4269: WHERE REL.ORIGINATOR_UE_ID = p_effectivity_id)
4270: FOR UPDATE NOWAIT;

Line 4293: FROM ahl_unit_effectivities_app_v UE1

4289:
4290: CURSOR ahl_sr_ue_valid_csr(p_mr_header_id IN NUMBER,
4291: p_unit_effectivity_id IN NUMBER) IS
4292: SELECT 'x'
4293: FROM ahl_unit_effectivities_app_v UE1
4294: WHERE UE1.unit_effectivity_id = p_unit_effectivity_id
4295: AND UE1.mr_header_id = p_mr_header_id;
4296:
4297: CURSOR ahl_sr_ue_csr IS

Line 4299: FROM ahl_unit_effectivities_app_v UE, ahl_ue_relationships UER

4295: AND UE1.mr_header_id = p_mr_header_id;
4296:
4297: CURSOR ahl_sr_ue_csr IS
4298: SELECT UER.related_ue_id
4299: FROM ahl_unit_effectivities_app_v UE, ahl_ue_relationships UER
4300: WHERE UER.ue_id = UE.unit_effectivity_id
4301: AND UER.relationship_code = 'PARENT'
4302: AND UE.object_type = 'SR'
4303: AND (UE.status_code is null or UE.status_code = 'INIT-DUE');

Line 4387: FROM AHL_UNIT_EFFECTIVITIES_APP_V EFF

4383: EFF.OBJECT_VERSION_NUMBER,
4384: EFF.LAST_UPDATE_DATE,
4385: EFF.LAST_UPDATED_BY ,
4386: EFF.LAST_UPDATE_LOGIN
4387: FROM AHL_UNIT_EFFECTIVITIES_APP_V EFF
4388: WHERE EFF.MR_HEADER_ID = p_header_id
4389: AND EFF.CSI_ITEM_INSTANCE_ID = p_csi_item_instance_id
4390: AND object_type = 'MR'
4391: -- AND (EFF.status_code is null or EFF.status_code in ('INIT-DUE','DEFERRED'))

Line 5624: FROM AHL_UNIT_EFFECTIVITIES_APP_V

5620: ATTRIBUTE12,
5621: ATTRIBUTE13,
5622: ATTRIBUTE14,
5623: ATTRIBUTE15
5624: FROM AHL_UNIT_EFFECTIVITIES_APP_V
5625: WHERE unit_effectivity_id = p_ue_id
5626: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
5627:
5628: l_ue_rec get_unit_effectivity_csr%rowtype;