DBA Data[Home] [Help]

APPS.WIP_SFCB_UTILITIES dependencies on WIP_OPEN_FLOW_SCHEDULES_V

Line 1352: -- Replacing view wip_open_flow_schedules_v

1348:
1349: begin
1350:
1351: -- Bug 4890953
1352: -- Replacing view wip_open_flow_schedules_v
1353: -- With the view query to avoid redundant joins
1354: -- and improve performance.
1355: /*
1356: select min(scheduled_start_date), max(scheduled_completion_date)

Line 1358: from wip_open_flow_schedules_v

1354: -- and improve performance.
1355: /*
1356: select min(scheduled_start_date), max(scheduled_completion_date)
1357: into x_sim_date_from, x_sim_date_to
1358: from wip_open_flow_schedules_v
1359: where line_id = p_line_id
1360: and standard_operation_id = p_line_op_id
1361: -- for the sake of performance
1362: and

Line 1517: wip_open_flow_schedules_v wofsv

1513: bom_operation_resources bors,
1514: bom_operation_sequences bos2, /* event seqs */
1515: bom_operation_sequences bos, /* line operations */
1516: bom_operational_routings bor,
1517: wip_open_flow_schedules_v wofsv
1518: where
1519: wofsv.organization_id = p_organization_id
1520: and wofsv.line_id = p_line_id
1521: and wofsv.standard_operation_id = p_line_op_id