APPS.WIP_WS_SHORTAGE dependencies on STANDARD

Line 215: * This procedure returns the string for applicable job types - right now it includes only standard jobs

211: END get_pref_job_statuses ;
212:
213:
214: /*
215: * This procedure returns the string for applicable job types - right now it includes only standard jobs
216: */
217: FUNCTION get_job_types RETURN VARCHAR2 IS
218: job_type_str VARCHAR2(240) := null;
219: BEGIN

Line 220: job_type_str := to_char(wip_constants.STANDARD);

216: */
217: FUNCTION get_job_types RETURN VARCHAR2 IS
218: job_type_str VARCHAR2(240) := null;
219: BEGIN
220: job_type_str := to_char(wip_constants.STANDARD);
221: return job_type_str;
222: END get_job_types;
223:
224:

Line 1372: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD);

1368: and trunc(wdj.scheduled_completion_date) = trunc(p_rcpt_date)
1369: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1370: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
1371: and (wdj.start_quantity - wdj.quantity_completed - wdj.quantity_scrapped) > 0
1372: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD);
1373: l_qty NUMBER := 0;
1374: BEGIN
1375: for c_job_csr in job_csr(p_org_id, p_inv_item_id, p_rcpt_date) loop
1376: l_qty := l_qty + (c_job_csr.item_qty - nvl(c_job_csr.reservation_qty,0));

Line 1441: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD)

1437: and wro.wip_entity_id = wdj.wip_entity_id
1438: and wro.wip_supply_type <> wip_constants.PHANTOM
1439: and wro.required_quantity < 0
1440: and wro.operation_seq_num > 0
1441: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD)
1442: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1443: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD);
1444: l_qty NUMBER := 0;
1445: BEGIN