DBA Data[Home] [Help]

APPS.AHL_PP_RESRC_ASSIGN_PVT dependencies on BOM_RESOURCES

Line 1058: bom_resources BOM

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
1062: AND OPR.resource_sequence_num = x_res

Line 2025: bom_resources BOM

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
2029: AND WOA.assignment_id = x_id;