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_PP_RESRC_ASSIGN_PVT dependencies on AHL_WORKORDER_OPERATIONS

Line 1039: ahl_workorder_operations WOP

1035: SELECT OPR.operation_resource_id requirement_id ,
1036: WOP.workorder_operation_id operation_id ,
1037: OPR.resource_id
1038: FROM ahl_operation_resources OPR,
1039: ahl_workorder_operations WOP
1040: WHERE OPR.workorder_operation_id = WOP.workorder_operation_id
1041: AND WOP.operation_sequence_num = x_oper
1042: AND OPR.resource_sequence_num = x_resrc
1043: AND WOP.workorder_id = x_id;

Line 1057: ahl_workorder_operations WOP,

1053: --Modified by Srini for performance fix
1054: CURSOR c_resource (x_oper IN NUMBER, x_res IN NUMBER, x_id IN NUMBER) IS
1055: SELECT resource_type resource_type_code
1056: FROM ahl_operation_resources OPR,
1057: ahl_workorder_operations WOP,
1058: bom_resources BOM
1059: WHERE OPR.workorder_operation_id = WOP.workorder_operation_id
1060: AND OPR.resource_id = BOM.resource_id
1061: AND WOP.operation_sequence_num = x_oper

Line 1075: FROM ahl_workorder_operations WOP,

1071: */
1072: --Modified by Srini for performance fix
1073: CURSOR c_assign (x_id IN NUMBER, x_oper IN NUMBER, x_resrc IN NUMBER) IS
1074: SELECT OPR.resource_id
1075: FROM ahl_workorder_operations WOP,
1076: ahl_operation_resources OPR
1077: WHERE WOP.workorder_operation_id = OPR.workorder_operation_id
1078: AND WOP.operation_sequence_num = x_oper
1079: AND OPR.resource_sequence_num = x_resrc

Line 1130: FROM ahl_workorder_operations WOP,

1126:
1127: -- cursor to get the resource req dates
1128: /* CURSOR resrc_req_dates(x_id IN NUMBER, x_oper IN NUMBER, x_resrc IN NUMBER) IS
1129: SELECT scheduled_start_date, scheduled_end_date
1130: FROM ahl_workorder_operations WOP,
1131: ahl_operation_resources OPR
1132: WHERE WOP.workorder_operation_id = OPR.workorder_operation_id
1133: AND WOP.operation_sequence_num = x_oper
1134: AND OPR.resource_sequence_num = x_resrc

Line 2024: ahl_workorder_operations WOP,

2020: BOM.resource_type resource_type_code,
2021: OPR.resource_id
2022: FROM ahl_operation_resources OPR,
2023: ahl_work_assignments WOA,
2024: ahl_workorder_operations WOP,
2025: bom_resources BOM
2026: WHERE OPR.operation_resource_id = WOA.operation_resource_id
2027: AND OPR.workorder_operation_id = WOP.workorder_operation_id
2028: AND OPR.resource_id = BOM.resource_id

Line 2042: FROM ahl_workorder_operations WOP,

2038: */
2039: --Modified by Srini for Performance fix
2040: CURSOR c_assign1 (x_id IN NUMBER, x_oper IN NUMBER, x_resrc IN NUMBER) IS
2041: SELECT OPR.resource_id
2042: FROM ahl_workorder_operations WOP,
2043: ahl_operation_resources OPR
2044: WHERE WOP.workorder_operation_id = OPR.workorder_operation_id
2045: AND WOP.operation_sequence_num = x_oper
2046: AND OPR.resource_sequence_num = x_resrc

Line 2098: FROM ahl_workorder_operations WOP,

2094:
2095: -- cursor to get the resource req dates
2096: CURSOR resrc_req_dates(x_id IN NUMBER, x_oper IN NUMBER, x_resrc IN NUMBER) IS
2097: SELECT scheduled_start_date, scheduled_end_date
2098: FROM ahl_workorder_operations WOP,
2099: ahl_operation_resources OPR
2100: WHERE WOP.workorder_operation_id = OPR.workorder_operation_id
2101: AND WOP.operation_sequence_num = x_oper
2102: AND OPR.resource_sequence_num = x_resrc

Line 2922: FROM ahl_operation_resources a, ahl_workorder_operations b, ahl_workorders_v c

2918: IS
2919: SELECT operation_resource_id,resource_sequence_num,
2920: operation_sequence_num,resource_id,b.workorder_operation_id,
2921: c.workorder_id,wip_entity_id,organization_id,department_id
2922: FROM ahl_operation_resources a, ahl_workorder_operations b, ahl_workorders_v c
2923: WHERE a.WORKORDER_OPERATION_id = b.workorder_operation_id
2924: AND b.workorder_id = c.workorder_id
2925: AND a.operation_resource_id = c_oper_resource_id;
2926: */

Line 2933: FROM ahl_operation_resources a, ahl_workorder_operations b,

2929: IS
2930: SELECT operation_resource_id,resource_sequence_num,
2931: operation_sequence_num,resource_id,b.workorder_operation_id,
2932: c.workorder_id,c.wip_entity_id, d.organization_id,department_id
2933: FROM ahl_operation_resources a, ahl_workorder_operations b,
2934: ahl_workorders c , wip_discrete_jobs d, wip_operations e
2935: WHERE a.WORKORDER_OPERATION_id = b.workorder_operation_id
2936: AND b.workorder_id = c.workorder_id
2937: AND c.wip_entity_id = d.wip_entity_id