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 536: l_sql_from := 'FROM wip_discrete_jobs wdj ';

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

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

1465: delete from eam_forecasted_work_orders where
1466: group_id = l_pm_group_id and
1467: scheduled_start_date < l_start_date;
1468:
1469: --select count(*) into l_count from wip_discrete_jobs;
1470:
1471: --debug('BEFORE CONVERT, WDJ: ' || l_count);
1472:
1473: convert_work_orders(p_pm_group_id => l_pm_group_id,

Line 1805: FROM WIP_DISCRETE_JOBS

1801: ACTUAL_START_DATE,
1802: EXPEDITED, EXPECTED_HOLD_RELEASE_DATE,
1803: p_forecast_rec.forecast_id AS FORECAST_ID
1804:
1805: FROM WIP_DISCRETE_JOBS
1806: WHERE wip_entity_id = p_wip_id_table(j);
1807:
1808: debug('COMPLETE WDJ COPY: ');
1809: