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;
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,
213: AND muc2.uom_class = muc1.uom_class
214: AND nvl(res.start_date,jobs.scheduled_start_date)
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
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
397: mrp_form_query list
398: WHERE jobs.scheduled_start_date
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