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 829: FROM AHL_UNIT_EFFECTIVITIES_APP_V

825: CURSOR l_prior_initializations_csr(p_mr_id IN NUMBER,
826: p_item_instance_id IN NUMBER,
827: p_ue_id IN NUMBER) IS
828: SELECT 'x'
829: FROM AHL_UNIT_EFFECTIVITIES_APP_V
830: WHERE MR_HEADER_ID = p_mr_id AND
831: CSI_ITEM_INSTANCE_ID = p_item_instance_id AND
832: status_code IN ('INIT-DUE', 'INIT-ACCOMPLISHED') AND
833: UNIT_EFFECTIVITY_ID <> p_ue_id;

Line 837: FROM AHL_UNIT_EFFECTIVITIES_APP_V

833: UNIT_EFFECTIVITY_ID <> p_ue_id;
834:
835: CURSOR l_ue_details_csr(p_ue_id IN NUMBER) IS
836: SELECT MR_HEADER_ID, CSI_ITEM_INSTANCE_ID, REPETITIVE_MR_FLAG, STATUS_CODE
837: FROM AHL_UNIT_EFFECTIVITIES_APP_V
838: WHERE UNIT_EFFECTIVITY_ID = p_ue_id;
839:
840: l_api_version CONSTANT NUMBER := 1.0;
841: l_api_name CONSTANT VARCHAR2(30) := 'Validate_For_Initialize';

Line 1137: FROM csi_cp_counters_v co, ahl_unit_effectivities_app_v ue

1133:
1134: CURSOR l_get_counter_id(p_counter_name IN VARCHAR2,
1135: p_ue_id IN NUMBER) IS
1136: /*SELECT co.counter_id
1137: FROM csi_cp_counters_v co, ahl_unit_effectivities_app_v ue
1138: WHERE co.COUNTER_NAME = p_counter_name AND
1139: ue.UNIT_EFFECTIVITY_ID = p_ue_id AND
1140: ue.csi_item_instance_id = CUSTOMER_PRODUCT_ID;*/
1141:

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

1141:
1142: --performace tuning related change
1143:
1144: /*SELECT c.counter_id
1145: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS_KFV MSITEM, ahl_unit_effectivities_app_v ue
1146: WHERE C.COUNTER_GROUP_ID(+) = CTRGRP.COUNTER_GROUP_ID
1147: AND CTRGRP.SOURCE_OBJECT_CODE = 'CP'
1148: AND CTRGRP.SOURCE_OBJECT_ID = CII.INSTANCE_ID
1149: AND MSITEM.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID

Line 1209: FROM csi_cp_counters_v co, ahl_unit_effectivities_app_v ue

1205:
1206: CURSOR l_get_counter_id(p_counter_name IN VARCHAR2,
1207: p_ue_id IN NUMBER) IS
1208: /*SELECT co.counter_id
1209: FROM csi_cp_counters_v co, ahl_unit_effectivities_app_v ue
1210: WHERE co.COUNTER_NAME = p_counter_name AND
1211: ue.UNIT_EFFECTIVITY_ID = p_ue_id AND
1212: ue.csi_item_instance_id = CUSTOMER_PRODUCT_ID;*/
1213:

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

1213:
1214: --performace tuning related change
1215: /*
1216: SELECT c.counter_id
1217: FROM CS_COUNTERS C, CS_COUNTER_GROUPS CTRGRP, CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS_KFV MSITEM, ahl_unit_effectivities_app_v ue
1218: WHERE C.COUNTER_GROUP_ID(+) = CTRGRP.COUNTER_GROUP_ID
1219: AND CTRGRP.SOURCE_OBJECT_CODE = 'CP'
1220: AND CTRGRP.SOURCE_OBJECT_ID = CII.INSTANCE_ID
1221: AND MSITEM.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID

Line 1278: FROM ahl_unit_effectivities_app_v

1274: x_return_status IN OUT NOCOPY VARCHAR2) IS
1275:
1276: CURSOR l_invalid_descendents_csr(p_ue_id IN NUMBER) IS
1277: SELECT 'x'
1278: FROM ahl_unit_effectivities_app_v
1279: WHERE (status_code not in ('INIT-ACCOMPLISHED', 'TERMINATED', 'MR-TERMINATE', 'ACCOMPLISHED','SR-CLOSED','DEFERRED','CANCELLED') OR status_code IS NULL)
1280: AND unit_effectivity_id in (
1281: SELECT related_ue_id
1282: FROM ahl_ue_relationships

Line 1292: FROM AHL_UNIT_EFFECTIVITIES_APP_V

1288: CURSOR l_prior_initializations_csr(p_mr_id IN NUMBER,
1289: p_item_instance_id IN NUMBER,
1290: p_ue_id IN NUMBER) IS
1291: SELECT status_code
1292: FROM AHL_UNIT_EFFECTIVITIES_APP_V
1293: WHERE MR_HEADER_ID = p_mr_id AND
1294: CSI_ITEM_INSTANCE_ID = p_item_instance_id AND
1295: status_code IN ('INIT-DUE', 'INIT-ACCOMPLISHED','DEFERRED') AND
1296: UNIT_EFFECTIVITY_ID <> p_ue_id;

Line 1301: FROM AHL_UNIT_EFFECTIVITIES_APP_V

1297:
1298: CURSOR l_ue_details_csr(p_ue_id IN NUMBER) IS
1299: SELECT STATUS_CODE, OBJECT_VERSION_NUMBER, MR_HEADER_ID,
1300: CSI_ITEM_INSTANCE_ID, PRECEDING_UE_ID,SERVICE_LINE_ID
1301: FROM AHL_UNIT_EFFECTIVITIES_APP_V
1302: WHERE UNIT_EFFECTIVITY_ID = p_ue_id;
1303:
1304: -- Added p_service_line_id as part of bugfix 6903768(FP for bug# 5764351).
1305: CURSOR l_prior_ue_csr(p_mr_id IN NUMBER,

Line 1310: FROM AHL_UNIT_EFFECTIVITIES_APP_V

1306: p_item_instance_id IN NUMBER,
1307: p_service_line_id IN NUMBER) IS
1308: /*
1309: SELECT UNIT_EFFECTIVITY_ID
1310: FROM AHL_UNIT_EFFECTIVITIES_APP_V
1311: WHERE MR_HEADER_ID = p_mr_id AND
1312: CSI_ITEM_INSTANCE_ID = p_item_instance_id AND
1313: FORECAST_SEQUENCE = (SELECT MIN(FORECAST_SEQUENCE) FROM AHL_UNIT_EFFECTIVITIES_APP_V
1314: WHERE MR_HEADER_ID = p_mr_id AND

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

1309: SELECT UNIT_EFFECTIVITY_ID
1310: FROM AHL_UNIT_EFFECTIVITIES_APP_V
1311: WHERE MR_HEADER_ID = p_mr_id AND
1312: CSI_ITEM_INSTANCE_ID = p_item_instance_id AND
1313: FORECAST_SEQUENCE = (SELECT MIN(FORECAST_SEQUENCE) FROM AHL_UNIT_EFFECTIVITIES_APP_V
1314: WHERE MR_HEADER_ID = p_mr_id AND
1315: CSI_ITEM_INSTANCE_ID = p_item_instance_id AND
1316: (STATUS_CODE IS NULL OR
1317: STATUS_CODE = 'INIT-DUE'))

Line 1334: FROM AHL_UNIT_EFFECTIVITIES_APP_V

1330: STATUS_CODE IN ('INIT-DUE'));
1331:
1332: CURSOR l_get_pred_details_csr(p_pred_ue_id IN NUMBER) IS
1333: SELECT MR_HEADER_ID, CSI_ITEM_INSTANCE_ID
1334: FROM AHL_UNIT_EFFECTIVITIES_APP_V
1335: WHERE UNIT_EFFECTIVITY_ID = p_pred_ue_id;
1336:
1337: CURSOR l_validate_status_csr(p_status_code IN VARCHAR2) IS
1338: SELECT 'x'

Line 1768: FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE

1764: CURSOR l_validate_counter_csr(p_ue_id IN NUMBER,
1765: p_counter_id IN NUMBER) IS
1766: /*
1767: SELECT NVL(net_reading, 0)
1768: FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE
1769: WHERE co.customer_product_id = ue.csi_item_instance_id and
1770: ue.unit_effectivity_id = p_ue_id and
1771: co.counter_id = p_counter_id;
1772: */

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

1772: */
1773:
1774: /*
1775: SELECT NVL(net_reading, 0)
1776: FROM csi_counter_values_v cv, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE
1777: WHERE cca.source_object_code = 'CP'
1778: AND cca.source_object_id = ue.csi_item_instance_id
1779: AND cca.counter_id = cv.counter_id
1780: AND ue.unit_effectivity_id = p_ue_id

Line 1788: FROM CSI_COUNTERS_VL CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE

1784: -- Added for R12 IB Uptake. If counter does not have any reading,
1785: -- csi_counter_values_v does not retrieve any row.
1786: -- split above cursor into 2 cursors.
1787: SELECT 'x'
1788: FROM CSI_COUNTERS_VL CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE
1789: WHERE cca.source_object_code = 'CP'
1790: AND cca.source_object_id = ue.csi_item_instance_id
1791: AND cca.counter_id = cc.counter_id
1792: AND ue.unit_effectivity_id = p_ue_id

Line 1961: FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE

1957: p_counter_id IN NUMBER) IS
1958:
1959: /*
1960: SELECT NVL(net_reading, 0)
1961: FROM CSI_CP_COUNTERS_V CO, AHL_UNIT_EFFECTIVITIES_APP_V UE
1962: WHERE co.customer_product_id = ue.csi_item_instance_id and
1963: ue.unit_effectivity_id = p_ue_id and
1964: co.counter_id = p_counter_id;
1965: */

Line 1970: FROM CSI_COUNTERS_VL CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE

1966: -- Added for R12 IB Uptake. If counter does not have any reading,
1967: -- csi_counter_values_v does not retrieve any row.
1968: -- split above cursor into 2 cursors.
1969: SELECT 'x'
1970: FROM CSI_COUNTERS_VL CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE
1971: WHERE cca.source_object_code = 'CP'
1972: AND cca.source_object_id = ue.csi_item_instance_id
1973: AND cca.counter_id = cc.counter_id
1974: AND ue.unit_effectivity_id = p_ue_id

Line 2264: FROM AHL_UNIT_EFFECTIVITIES_APP_V

2260: ATTRIBUTE12,
2261: ATTRIBUTE13,
2262: ATTRIBUTE14,
2263: ATTRIBUTE15
2264: FROM AHL_UNIT_EFFECTIVITIES_APP_V
2265: WHERE unit_effectivity_id = p_ue_id
2266: FOR UPDATE OF OBJECT_VERSION_NUMBER;
2267:
2268: CURSOR l_get_descendents(p_ue_id IN NUMBER) IS

Line 2826: FROM AHL_UNIT_EFFECTIVITIES_APP_V

2822: ATTRIBUTE12,
2823: ATTRIBUTE13,
2824: ATTRIBUTE14,
2825: ATTRIBUTE15
2826: FROM AHL_UNIT_EFFECTIVITIES_APP_V
2827: WHERE unit_effectivity_id = p_ue_id
2828: FOR UPDATE OF OBJECT_VERSION_NUMBER;
2829:
2830: l_ue_rec l_get_unit_effectivity_csr%rowtype;

Line 3882: FROM AHL_UNIT_EFFECTIVITIES_APP_V EFF

3878: EFF.OBJECT_VERSION_NUMBER,
3879: EFF.LAST_UPDATE_DATE,
3880: EFF.LAST_UPDATED_BY ,
3881: EFF.LAST_UPDATE_LOGIN
3882: FROM AHL_UNIT_EFFECTIVITIES_APP_V EFF
3883: WHERE EFF.MR_HEADER_ID = p_header_id
3884: AND object_type = 'MR'
3885: -- AND (EFF.status_code is null or EFF.status_code in ('INIT-DUE','DEFERRED'))
3886: AND (EFF.status_code is null or EFF.status_code = 'INIT-DUE')

Line 3951: FROM AHL_UNIT_EFFECTIVITIES_APP_V EFF

3947: EFF.OBJECT_VERSION_NUMBER,
3948: EFF.LAST_UPDATE_DATE,
3949: EFF.LAST_UPDATED_BY,
3950: EFF.LAST_UPDATE_LOGIN
3951: FROM AHL_UNIT_EFFECTIVITIES_APP_V EFF
3952: WHERE EFF.UNIT_EFFECTIVITY_ID IN
3953: (SELECT REL.RELATED_UE_ID FROM AHL_UE_RELATIONSHIPS REL
3954: WHERE REL.ORIGINATOR_UE_ID = p_effectivity_id)
3955: FOR UPDATE;

Line 3962: FROM ahl_unit_effectivities_app_v UE,

3958:
3959: -- For processsing object type = 'SR'
3960: /*CURSOR ahl_sr_ue_csr(p_mr_header_id IN NUMBER) IS
3961: SELECT UE1.unit_effectivity_id
3962: FROM ahl_unit_effectivities_app_v UE,
3963: ahl_ue_relationships UER, ahl_unit_effectivities_b UE1
3964: WHERE UER.ue_id = UE.unit_effectivity_id
3965: AND UER.related_ue_id = UE1.unit_effectivity_id
3966: AND UE.object_type = 'SR'

Line 3974: FROM ahl_unit_effectivities_app_v UE1

3970:
3971: CURSOR ahl_sr_ue_valid_csr(p_mr_header_id IN NUMBER,
3972: p_unit_effectivity_id IN NUMBER) IS
3973: SELECT 'x'
3974: FROM ahl_unit_effectivities_app_v UE1
3975: WHERE UE1.unit_effectivity_id = p_unit_effectivity_id
3976: AND UE1.mr_header_id = p_mr_header_id;
3977:
3978: CURSOR ahl_sr_ue_csr IS

Line 3980: FROM ahl_unit_effectivities_app_v UE, ahl_ue_relationships UER

3976: AND UE1.mr_header_id = p_mr_header_id;
3977:
3978: CURSOR ahl_sr_ue_csr IS
3979: SELECT UER.related_ue_id
3980: FROM ahl_unit_effectivities_app_v UE, ahl_ue_relationships UER
3981: WHERE UER.ue_id = UE.unit_effectivity_id
3982: AND UER.relationship_code = 'PARENT'
3983: AND UE.object_type = 'SR'
3984: AND (UE.status_code is null or UE.status_code = 'INIT-DUE');

Line 4067: FROM AHL_UNIT_EFFECTIVITIES_APP_V EFF

4063: EFF.OBJECT_VERSION_NUMBER,
4064: EFF.LAST_UPDATE_DATE,
4065: EFF.LAST_UPDATED_BY ,
4066: EFF.LAST_UPDATE_LOGIN
4067: FROM AHL_UNIT_EFFECTIVITIES_APP_V EFF
4068: WHERE EFF.MR_HEADER_ID = p_header_id
4069: AND EFF.CSI_ITEM_INSTANCE_ID = p_csi_item_instance_id
4070: AND object_type = 'MR'
4071: -- AND (EFF.status_code is null or EFF.status_code in ('INIT-DUE','DEFERRED'))

Line 5253: FROM AHL_UNIT_EFFECTIVITIES_APP_V

5249: ATTRIBUTE12,
5250: ATTRIBUTE13,
5251: ATTRIBUTE14,
5252: ATTRIBUTE15
5253: FROM AHL_UNIT_EFFECTIVITIES_APP_V
5254: WHERE unit_effectivity_id = p_ue_id
5255: FOR UPDATE OF OBJECT_VERSION_NUMBER;
5256:
5257: l_ue_rec get_unit_effectivity_csr%rowtype;