APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on WIP_OPERATIONS

Line 592: wip_operations wop

588:
589: Select awo.workorder_operation_id, wop.department_id, bd.department_code,
590: wo.organization_id
591: from ahl_workorder_tasks_v wo, ahl_workorder_operations awo, bom_departments bd,
592: wip_operations wop
593: where wo.wip_entity_id = wop.wip_entity_id
594: and wop.operation_seq_num = c_Oper_seq
595: and wop.department_id = bd.department_id
596: and wo.workorder_id = awo.workorder_id

Line 1019: From WIP_OPERATIONS WOP, AHL_WORKORDERS AW

1015: Select WOP.FIRST_UNIT_START_DATE, WOP.LAST_UNIT_COMPLETION_DATE,
1016: (select nvl(max(resource_seq_num),0) + 10 from wip_operation_resources
1017: where wip_entity_id = WOP.wip_entity_id and operation_seq_num = WOP.operation_seq_num),
1018: WOP.Department_id
1019: From WIP_OPERATIONS WOP, AHL_WORKORDERS AW
1020: Where AW.wip_entity_id = WOP.wip_entity_id
1021: and AW.workorder_id = p_workorder_id
1022: and WOP.operation_seq_num = p_operation_seq_num;
1023:

Line 1029: opseqno WIP_OPERATIONS.operation_seq_num%TYPE,

1025: j NUMBER;
1026:
1027: TYPE RES_SEQ_CT_REC_TYPE IS RECORD (
1028: woid AHL_WORKORDERS.workorder_id%TYPE,
1029: opseqno WIP_OPERATIONS.operation_seq_num%TYPE,
1030: res_seq_ct NUMBER);
1031:
1032: TYPE RES_SEQ_TABLE_TYPE IS TABLE OF RES_SEQ_CT_REC_TYPE
1033: INDEX BY BINARY_INTEGER;