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 AHL_UNIT_EFFECTIVITIES_APP_V

Line 2465: FROM AHL_UNIT_EFFECTIVITIES_APP_V

2461:
2462: /*
2463: CURSOR ahl_unit_effectivities_csr (p_csi_item_instance_id IN NUMBER) IS
2464: SELECT UNIT_EFFECTIVITY_ID
2465: FROM AHL_UNIT_EFFECTIVITIES_APP_V
2466: WHERE csi_item_instance_id = p_csi_item_instance_id
2467: AND (status_code IS NULL OR status_code = 'INIT-DUE')
2468: FOR UPDATE OF object_version_number NOWAIT;
2469: */

Line 2477: FROM AHL_UNIT_EFFECTIVITIES_APP_V

2473: -- 13 Jul 08: Modified query to use status_code instead of object_version_number
2474: CURSOR ahl_unit_effectivities_csr (p_csi_item_instance_id IN NUMBER) IS
2475: --SELECT UNIT_EFFECTIVITY_ID
2476: SELECT 1
2477: FROM AHL_UNIT_EFFECTIVITIES_APP_V
2478: WHERE csi_item_instance_id = p_csi_item_instance_id
2479: AND (status_code IS NULL OR status_code IN ('INIT-DUE','EXCEPTION'))
2480: FOR UPDATE OF status_code NOWAIT;
2481: */

Line 2499: --FROM AHL_UNIT_EFFECTIVITIES_APP_V UE, II

2495: AND SYSDATE BETWEEN TRUNC(NVL(ACTIVE_START_DATE,SYSDATE))
2496: AND TRUNC(NVL(ACTIVE_END_DATE, SYSDATE+1))
2497: )
2498: SELECT 1
2499: --FROM AHL_UNIT_EFFECTIVITIES_APP_V UE, II
2500: FROM AHL_UNIT_EFFECTIVITIES_B UE, II
2501: WHERE UE.csi_item_instance_id = II.INSTANCE_ID
2502: AND UE.application_usg_code = p_appln_usg_code
2503: AND (status_code IS NULL OR status_code IN ('INIT-DUE','EXCEPTION'))

Line 3194: l_acc_status_code ahl_unit_effectivities_app_v.status_code%TYPE;

3190: and (ue.status_code IS NULL or ue.status_code = 'INIT-DUE');
3191:
3192:
3193: l_acc_unit_effectivity_id NUMBER;
3194: l_acc_status_code ahl_unit_effectivities_app_v.status_code%TYPE;
3195:
3196: l_last_accomplishment_date DATE;
3197: l_last_acc_counter_val_tbl counter_values_tbl_type;
3198: l_due_counter_val_tbl counter_values_tbl_type;

Line 3394: FROM ahl_unit_effectivities_app_v UE, ahl_UE_relationships reln

3390: -- retrieve current unit effectivity records.
3391: CURSOR ahl_unit_effectivity_csr (p_mr_header_id IN NUMBER,
3392: p_csi_item_instance_id IN NUMBER) IS
3393: SELECT ue.unit_effectivity_id, ue.status_code, reln.related_ue_id, reln.originator_ue_id
3394: FROM ahl_unit_effectivities_app_v UE, ahl_UE_relationships reln
3395: WHERE UE.unit_effectivity_id = RELN.RELATED_UE_ID(+)
3396: AND mr_header_id = p_mr_header_id
3397: AND csi_item_instance_id = p_csi_item_instance_id
3398: AND (UE.Status_code IS NULL OR status_code = 'INIT-DUE')

Line 3413: --FROM ahl_unit_effectivities_app_v UE, ahl_UE_relationships reln,

3409: CURSOR ahl_unit_effectivity_csr (p_title IN VARCHAR2,
3410: p_csi_item_instance_id IN NUMBER,
3411: p_appln_usg_code IN VARCHAR2) IS
3412: SELECT ue.unit_effectivity_id, ue.status_code, reln.related_ue_id, reln.originator_ue_id, ue.mr_header_id
3413: --FROM ahl_unit_effectivities_app_v UE, ahl_UE_relationships reln,
3414: FROM ahl_unit_effectivities_b UE, ahl_UE_relationships reln,
3415: ahl_mr_headers_b mr
3416: WHERE UE.unit_effectivity_id = RELN.RELATED_UE_ID(+)
3417: AND UE.mr_header_id = mr.mr_header_id

Line 3569: --FROM ahl_unit_effectivities_app_v ue

3565: CURSOR ahl_unplanned_MRs_csr(p_item_instance_id IN NUMBER,
3566: p_title IN VARCHAR2,
3567: p_appln_usg_code IN VARCHAR2) IS
3568: SELECT ue.unit_effectivity_id
3569: --FROM ahl_unit_effectivities_app_v ue
3570: FROM ahl_unit_effectivities_b ue
3571: WHERE ue.csi_item_instance_id = p_item_instance_id
3572: AND ue.application_usg_code = p_appln_usg_code
3573: AND ue.mr_header_id IN (select amh.mr_header_id from ahl_mr_headers_b amh where amh.title = p_title)

Line 4654: --FROM ahl_unit_effectivities_app_v ue, ahl_unit_deferrals_vl ud

4650: -- modified query to fix bug# 9264774. Replaced input p_mr_header_id with p_title.
4651: CURSOR ahl_init_due_csr (p_csi_item_instance_id IN NUMBER,
4652: p_title IN VARCHAR2) IS
4653: SELECT ud.set_due_date, ue.unit_effectivity_id, ud.unit_deferral_id
4654: --FROM ahl_unit_effectivities_app_v ue, ahl_unit_deferrals_vl ud
4655: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b ud
4656: WHERE ue.unit_effectivity_id = ud.unit_effectivity_id AND
4657: ud.unit_deferral_type = 'INIT-DUE' AND
4658: ue.csi_item_instance_id = p_csi_item_instance_id AND

Line 7431: --FROM ahl_unit_effectivities_app_v ue1, ahl_unit_effectivities_app_v ue2

7427: p_related_ue_id IN NUMBER ) IS
7428: SELECT ue1.mr_header_id, ue1.csi_item_instance_id,
7429: ue2.mr_header_id related_mr_header_id,
7430: ue2.csi_item_instance_id related_csi_item_instance_id
7431: --FROM ahl_unit_effectivities_app_v ue1, ahl_unit_effectivities_app_v ue2
7432: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2
7433: WHERE ue1.unit_effectivity_id = p_ue_id AND
7434: ue2.unit_effectivity_id = p_related_ue_id;
7435:

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 10150: l_calc_tolerance_flag ahl_unit_effectivities_app_v.tolerance_flag%TYPE;

10146: l_return_val BOOLEAN;
10147:
10148: l_calc_due_date DATE;
10149: l_calc_counter_id NUMBER;
10150: l_calc_tolerance_flag ahl_unit_effectivities_app_v.tolerance_flag%TYPE;
10151: l_calc_message_code ahl_unit_effectivities_app_v.message_code%TYPE;
10152: l_calc_due_counter_value NUMBER;
10153:
10154: l_visit_start_date DATE;

Line 10151: l_calc_message_code ahl_unit_effectivities_app_v.message_code%TYPE;

10147:
10148: l_calc_due_date DATE;
10149: l_calc_counter_id NUMBER;
10150: l_calc_tolerance_flag ahl_unit_effectivities_app_v.tolerance_flag%TYPE;
10151: l_calc_message_code ahl_unit_effectivities_app_v.message_code%TYPE;
10152: l_calc_due_counter_value NUMBER;
10153:
10154: l_visit_start_date DATE;
10155: l_visit_end_date DATE;

Line 10634: FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue

10630: -- Read immediate children of the SR.
10631: CURSOR ahl_ue_reln_csr (p_ue_id IN NUMBER) IS
10632: SELECT ue.unit_effectivity_id, ue.status_code,
10633: UE.CSI_ITEM_INSTANCE_ID, UE.MR_HEADER_ID
10634: FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue
10635: WHERE ue.unit_effectivity_id = uer.related_ue_id
10636: AND uer.ue_id = p_ue_id;
10637:
10638:

Line 10639: l_calc_tolerance_flag ahl_unit_effectivities_app_v.tolerance_flag%TYPE;

10635: WHERE ue.unit_effectivity_id = uer.related_ue_id
10636: AND uer.ue_id = p_ue_id;
10637:
10638:
10639: l_calc_tolerance_flag ahl_unit_effectivities_app_v.tolerance_flag%TYPE;
10640: l_calc_message_code ahl_unit_effectivities_app_v.message_code%TYPE;
10641:
10642: l_visit_start_date DATE;
10643: l_visit_end_date DATE;

Line 10640: l_calc_message_code ahl_unit_effectivities_app_v.message_code%TYPE;

10636: AND uer.ue_id = p_ue_id;
10637:
10638:
10639: l_calc_tolerance_flag ahl_unit_effectivities_app_v.tolerance_flag%TYPE;
10640: l_calc_message_code ahl_unit_effectivities_app_v.message_code%TYPE;
10641:
10642: l_visit_start_date DATE;
10643: l_visit_end_date DATE;
10644: l_visit_assign_code fnd_lookups.lookup_code%TYPE;

Line 11015: --FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue1

11011: ue.status_code
11012: FROM ahl_unit_effectivities_b ue
11013: /*
11014: WHERE NOT EXISTS ( SELECT 'x'
11015: --FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue1
11016: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1
11017: WHERE uer.related_ue_id = ue.unit_effectivity_id AND
11018: uer.originator_ue_id = ue1.unit_effectivity_id AND
11019: ue1.object_type <> 'SR' )

Line 13819: FROM ahl_unit_effectivities_app_v UE

13815: trunc(nvl(parent.active_start_date, sysdate)) <= trunc(sysdate) and
13816: trunc(sysdate) < trunc(nvl(parent.active_end_date, sysdate+1))
13817: ) Root_instance_id
13818:
13819: FROM ahl_unit_effectivities_app_v UE
13820: WHERE UE.mr_header_id = p_mr_header_id
13821: AND (UE.status_code IS NULL OR UE.status_code IN ('INIT-DUE','EXCEPTION'))
13822: AND NOT EXISTS (Select 1
13823: FROM ahl_mr_instances_temp

Line 14188: --FROM ahl_unit_effectivities_app_v ue1, ahl_unit_effectivities_app_v ue2

14184: p_related_ue_id IN NUMBER ) IS
14185: SELECT ue1.mr_header_id, ue1.csi_item_instance_id,
14186: ue2.mr_header_id related_mr_header_id,
14187: ue2.csi_item_instance_id related_csi_item_instance_id
14188: --FROM ahl_unit_effectivities_app_v ue1, ahl_unit_effectivities_app_v ue2
14189: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2
14190: WHERE ue1.unit_effectivity_id = p_ue_id AND
14191: ue2.unit_effectivity_id = p_related_ue_id;
14192:

Line 14399: FROM ahl_unit_effectivities_app_v UE, ahl_mr_headers_b mr

14395: (
14396: SELECT ue.csi_item_instance_id,
14397: mr.Title,
14398: max(mr.version_number) version_number
14399: FROM ahl_unit_effectivities_app_v UE, ahl_mr_headers_b mr
14400: -- pick up only top nodes.
14401: WHERE ue.mr_header_id = mr.mr_header_id
14402: AND NOT EXISTS (SELECT 'x'
14403: FROM ahl_ue_relationships uer

Line 15010: l_lc_acc_status_code ahl_unit_effectivities_app_v.status_code%TYPE;

15006:
15007: l_lc_mr_accomplishment_date DATE;
15008: l_lc_acc_ue_id NUMBER;
15009: l_lc_acc_deferral_flag BOOLEAN;
15010: l_lc_acc_status_code ahl_unit_effectivities_app_v.status_code%TYPE;
15011: l_lc_return_val BOOLEAN;
15012:
15013: l_max_acc_date DATE;
15014: l_last_acc_ue_id NUMBER;

Line 15325: l_lc_acc_status_code ahl_unit_effectivities_app_v.status_code%TYPE;

15321:
15322: l_lc_mr_accomplishment_date DATE;
15323: l_lc_acc_ue_id NUMBER;
15324: l_lc_acc_deferral_flag BOOLEAN;
15325: l_lc_acc_status_code ahl_unit_effectivities_app_v.status_code%TYPE;
15326: l_lc_return_val BOOLEAN;
15327:
15328: l_max_acc_date DATE;
15329: --l_last_acc_ue_id NUMBER;

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.