DBA Data[Home] [Help]

APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on WIP_OPERATION_RESOURCES

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

1011: Cursor get_oper_res_det(p_workorder_id IN NUMBER,
1012: p_operation_seq_num IN NUMBER)
1013: Is
1014: Select WOP.FIRST_UNIT_START_DATE, WOP.LAST_UNIT_COMPLETION_DATE,
1015: (select nvl(max(resource_seq_num),0) + 10 from wip_operation_resources
1016: where wip_entity_id = WOP.wip_entity_id and operation_seq_num = WOP.operation_seq_num),
1017: WOP.Department_id
1018: From WIP_OPERATIONS WOP, AHL_WORKORDERS AW
1019: Where AW.wip_entity_id = WOP.wip_entity_id