APPS.AHL_PP_MATERIALS_PVT dependencies on WIP_OPERATIONS

Line 1324: -- derive dept. from wip-operations.

1320: SELECT operation_sequence_num
1321: FROM ahl_workorder_operations
1322: WHERE workorder_operation_id = c_operation_id;
1323: -- sracha: added for bug# 6802777.
1324: -- derive dept. from wip-operations.
1325: CURSOR get_oper_dept(c_wip_entity_id IN NUMBER,
1326: c_oper_seq_num IN NUMBER)
1327: IS
1328: SELECT wo.department_id

Line 1329: FROM WIP_OPERATIONS WO

1325: CURSOR get_oper_dept(c_wip_entity_id IN NUMBER,
1326: c_oper_seq_num IN NUMBER)
1327: IS
1328: SELECT wo.department_id
1329: FROM WIP_OPERATIONS WO
1330: WHERE wo.wip_entity_id = c_wip_entity_id
1331: AND wo.operation_seq_num = c_oper_seq_num;
1332: --sukhwsin: SB Effectivity - Added Cursor to get uc_header_id
1333: CURSOR Get_Wo_Uc_Header_Id(c_workorder_id IN NUMBER)

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 3870: WIP_OPERATIONS WOP

3866: MTL_SYSTEM_ITEMS_VL MSIV,
3867: AHL_VISITS_VL AVST,
3868: AHL_WORKORDER_OPERATIONS AWOP,
3869: -- added for FP bug# 6802777
3870: WIP_OPERATIONS WOP
3871: WHERE
3872: AWOP.WORKORDER_OPERATION_ID = ASML.WORKORDER_OPERATION_ID AND
3873: AWOS.VISIT_TASK_ID = ASML.VISIT_TASK_ID AND
3874: ASML.VISIT_ID = AVST.VISIT_ID AND