DBA Data[Home] [Help]

APPS.AHL_PP_RESRC_ASSIGN_PVT dependencies on BOM_RESOURCES

Line 1060: bom_resources BOM

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

Line 2027: bom_resources BOM

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