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 1041: ahl_workorder_operations WOP

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

Line 1059: ahl_workorder_operations WOP,

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

Line 1077: FROM ahl_workorder_operations WOP,

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

Line 1132: FROM ahl_workorder_operations WOP,

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

Line 2026: ahl_workorder_operations WOP,

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

Line 2044: FROM ahl_workorder_operations WOP,

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

Line 2100: FROM ahl_workorder_operations WOP,

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

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

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

Line 2935: FROM ahl_operation_resources a, ahl_workorder_operations b,

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