DBA Data[Home] [Help]

APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on WIP_OPERATION_RESOURCES

Line 1016: (select nvl(max(resource_seq_num),0) + 10 from wip_operation_resources

1012: Cursor get_oper_res_det(p_workorder_id IN NUMBER,
1013: p_operation_seq_num IN NUMBER)
1014: Is
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