APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_JOB_OPER_MATERIALS_V

Line 2923: AHL_JOB_OPER_MATERIALS_V B, WIP_OPERATIONS WO

2919: --sukhwsin: SB Effectivity code changes - ends
2920: --debadey; Marshalling FDD section 5.15
2921: A.aog_flag
2922: FROM AHL_SCHEDULE_MATERIALS A,
2923: AHL_JOB_OPER_MATERIALS_V B, WIP_OPERATIONS WO
2924: WHERE A.SCHEDULED_MATERIAL_ID = B.SCHEDULED_MATERIAL_ID
2925: AND B.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
2926: AND B.OPERATION_SEQUENCE = WO.OPERATION_SEQ_NUM
2927: AND A.SCHEDULED_MATERIAL_ID = c_schedule_material_id

Line 3834: AHL_JOB_OPER_MATERIALS_V B

3830: B.department_id,
3831: B.workorder_name,
3832: B.wip_entity_id
3833: FROM AHL_SCHEDULE_MATERIALS A,
3834: AHL_JOB_OPER_MATERIALS_V B
3835: WHERE A.SCHEDULED_MATERIAL_ID = B.SCHEDULED_MATERIAL_ID
3836: AND A.SCHEDULED_MATERIAL_ID = c_schedule_material_id;
3837: */
3838: /*

Line 3841: * instead of AHL_JOB_OPER_MATERIALS_V. Bug # 4919273

3837: */
3838: /*
3839: * R12 Perf Tuning
3840: * Balaji modified the query to use only base tables
3841: * instead of AHL_JOB_OPER_MATERIALS_V. Bug # 4919273
3842: */
3843: SELECT
3844: ASML.scheduled_material_id,
3845: ASML.inventory_item_id,