DBA Data[Home] [Help]

APPS.OPI_EDW_JOB_RSRC_PVT dependencies on WIP_OPERATIONS

Line 26: FROM WIP_OPERATIONS

22:
23:
24: SELECT min(operation_seq_num)
25: INTO l_operation_seq_num
26: FROM WIP_OPERATIONS
27: WHERE organization_id = p_organization_id
28: AND wip_entity_id = p_wip_entity_id
29: AND nvl(repetitive_schedule_id ,-99)= nvl(p_repetitive_schedule_id,-99) ;
30:

Line 97: FROM WIP_OPERATIONS

93: l_cmpl_date DATE := to_date(NULL);
94: BEGIN
95: SELECT max(operation_seq_num)
96: INTO l_operation_seq_num
97: FROM WIP_OPERATIONS
98: WHERE organization_id = p_organization_id
99: AND wip_entity_id = p_wip_entity_id
100: AND nvl(repetitive_schedule_id,-99) = nvl(p_repetitive_schedule_id,-99) ;
101: