APPS.EAM_FORECAST_PVT dependencies on WIP_DISCRETE_JOBS

Line 146: FROM cst_distribution_lite_v cdv, org_acct_periods oap, wip_discrete_jobs wdj,

142: oap.period_start_date,
143: oap.period_num,
144: oap.period_year,
145: (cdv.base_transaction_value) value
146: FROM cst_distribution_lite_v cdv, org_acct_periods oap, wip_discrete_jobs wdj,
147: wip_eam_parameters ep, mfg_lookups mf
148: WHERE ep.organization_id = cdv.organization_id
149: and cdv.wip_entity_id = wdj.wip_entity_id
150: and cdv.organization_id = wdj.organization_id

Line 537: l_sql_from := 'FROM wip_discrete_jobs wdj ';

533:
534: debug('End date is ' || l_end_date);
535:
536: l_sql_select := 'SELECT wdj.wip_entity_id ';
537: l_sql_from := 'FROM wip_discrete_jobs wdj ';
538: l_sql_where := 'WHERE ';
539:
540: debug('Select stmt: ' || l_sql_select);
541: debug('FROM stmt: ' || l_sql_from);

Line 1490: --select count(*) into l_count from wip_discrete_jobs;

1486: delete from eam_forecasted_work_orders where
1487: group_id = l_pm_group_id and
1488: scheduled_start_date < l_start_date;
1489:
1490: --select count(*) into l_count from wip_discrete_jobs;
1491:
1492: --debug('BEFORE CONVERT, WDJ: ' || l_count);
1493:
1494: convert_work_orders(p_pm_group_id => l_pm_group_id,

Line 1826: FROM WIP_DISCRETE_JOBS

1822: ACTUAL_START_DATE,
1823: EXPEDITED, EXPECTED_HOLD_RELEASE_DATE,
1824: p_forecast_rec.forecast_id AS FORECAST_ID
1825:
1826: FROM WIP_DISCRETE_JOBS
1827: WHERE wip_entity_id = p_wip_id_table(j);
1828:
1829: debug('COMPLETE WDJ COPY: ');
1830: