APPS.MRP_CRP_HORIZONTAL_PLAN dependencies on STANDARD

Line 40: WIP_NONSTANDARD CONSTANT INTEGER := 3;

36: M_REPETITIVE CONSTANT INTEGER := 4;
37: M_FLOW_SCHEDULES CONSTANT INTEGER := 27;
38:
39: WIP_DISCRETE CONSTANT INTEGER := 1; /* WIP_DISCRETE_JOB */
40: WIP_NONSTANDARD CONSTANT INTEGER := 3;
41:
42:
43: JOB_UNRELEASED CONSTANT INTEGER := 1;/* job status code*/
44: JOB_RELEASED CONSTANT INTEGER := 3;

Line 190: WIP_NONSTANDARD, NONSTD_JOBS, DISCRETE_JOBS),

186: list.number2,
187: res.resource_id,
188: -1,
189: DECODE(jobs.job_type,
190: WIP_NONSTANDARD, NONSTD_JOBS, DISCRETE_JOBS),
191: NVL(res.start_date, jobs.scheduled_start_date),
192: DECODE(g_spread_load,
193: SYS_YES, res.completion_date, to_date(NULL)),
194: DECODE(res.basis_type, BASIS_PER_ITEM,

Line 217: AND jobs.job_type in (WIP_NONSTANDARD,WIP_DISCRETE)

213: AND muc2.uom_class = muc1.uom_class
214: AND nvl(res.start_date,jobs.scheduled_start_date) 215: AND jobs.status_type IN (JOB_UNRELEASED,
216: JOB_COMPLETE, JOB_HOLD, JOB_RELEASED)
217: AND jobs.job_type in (WIP_NONSTANDARD,WIP_DISCRETE)
218: AND jobs.organization_id = op.organization_id
219: AND jobs.wip_entity_id = op.wip_entity_id
220: AND nvl((op.scheduled_quantity * res.usage_rate_or_amount -
221: res.applied_resource_units),1) > 0

Line 390: WIP_NONSTANDARD, NONSTD_JOBS,

386: -1,
387: -1,
388: jobs.line_id,
389: DECODE(jobs.job_type,
390: WIP_NONSTANDARD, NONSTD_JOBS,
391: WIP_DISCRETE, DISCRETE_JOBS),
392: jobs.scheduled_start_date,
393: to_date(NULL),
394: SUM(GREATEST( 0, (jobs.net_quantity - jobs.quantity_completed

Line 401: AND jobs.job_type in (WIP_NONSTANDARD,WIP_DISCRETE)

397: mrp_form_query list
398: WHERE jobs.scheduled_start_date 399: AND jobs.status_type IN (JOB_UNRELEASED,
400: JOB_COMPLETE, JOB_HOLD, JOB_RELEASED)
401: AND jobs.job_type in (WIP_NONSTANDARD,WIP_DISCRETE)
402: AND jobs.net_quantity > 0
403: AND jobs.wip_entity_id >= 0
404: AND jobs.organization_id = list.number1
405: AND jobs.line_id = list.number2