APPS.WIP_WS_SHORTAGE dependencies on STANDARD

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

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

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

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

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

1297: and trunc(wdj.scheduled_completion_date) = trunc(p_rcpt_date)
1298: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1299: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD)
1300: and (wdj.start_quantity - wdj.quantity_completed - wdj.quantity_scrapped) > 0
1301: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD);
1302: l_qty NUMBER := 0;
1303: BEGIN
1304: for c_job_csr in job_csr(p_org_id, p_inv_item_id, p_rcpt_date) loop
1305: l_qty := l_qty + (c_job_csr.item_qty - nvl(c_job_csr.reservation_qty,0));

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

1366: and wro.wip_entity_id = wdj.wip_entity_id
1367: and wro.wip_supply_type <> wip_constants.PHANTOM
1368: and wro.required_quantity < 0
1369: and wro.operation_seq_num > 0
1370: and wdj.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD)
1371: and wdj.status_type IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
1372: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD);
1373: l_qty NUMBER := 0;
1374: BEGIN