APPS.WSMPUTIL dependencies on WIP_ENTITIES

Line 2732: from wip_discrete_jobs wdj, wip_entities we

2728:
2729: l_stmt_no := 10;
2730: select wdj.organization_id, wdj.job_type
2731: into l_organization_id, l_job_type
2732: from wip_discrete_jobs wdj, wip_entities we
2733: where wdj.wip_entity_id = p_wip_entity_id
2734: and wdj.wip_entity_id = we.wip_entity_id
2735: and we.entity_type = 5;
2736:

Line 2795: from wip_discrete_jobs wdj, wip_entities we

2791:
2792: begin
2793: select 1
2794: into ret_val1
2795: from wip_discrete_jobs wdj, wip_entities we
2796: where wdj.organization_id = p_org_id
2797: and wdj.wip_entity_id = we.wip_entity_id
2798: and we.entity_type = 5
2799: and wdj.status_type = 6

Line 2817: from wip_discrete_jobs wdj, wip_entities we

2813: select 1
2814: into ret_val1
2815: from dual
2816: where exists (select 1
2817: from wip_discrete_jobs wdj, wip_entities we
2818: where wdj.organization_id = p_org_id
2819: and wdj.wip_entity_id = we.wip_entity_id
2820: and we.entity_type = 5
2821: and wdj.status_type not in (1,7,12,6)

Line 3246: wip_entities we

3242: select 1
3243: into l_dummy
3244: from wsm_split_merge_transactions wsmt,
3245: wsm_sm_resulting_jobs wrj,
3246: wip_entities we
3247: where wrj.wip_entity_id = p_wip_entity_id
3248: and wrj.transaction_id = wsmt.transaction_id
3249: and wsmt.transaction_type_id in (1,2,6)
3250: and we.wip_entity_id = wrj.wip_entity_id

Line 4042: select '1' from wip_entities we

4038: where wt.group_id = p_group_id
4039: and wt.organization_id = p_organization_id
4040: and wt.status_type <> 99
4041: and exists (
4042: select '1' from wip_entities we
4043: where we.wip_entity_id = wt.wip_entity_id
4044: and we.organization_id = wt.organization_id
4045: and we.entity_type = 5) -- check only LBJs
4046: and (exists (

Line 4111: from wip_dj_close_temp wt, wip_entities we

4107: update wip_discrete_jobs
4108: set status_type = 15 -- Failed Close.
4109: where wip_entity_id in
4110: (select wt.wip_entity_id
4111: from wip_dj_close_temp wt, wip_entities we
4112: where wt.group_id = p_group_id
4113: and wt.organization_id = p_organization_id
4114: and wt.status_type = 99
4115: and wt.wip_entity_id = we.wip_entity_id

Line 4127: from wip_dj_close_temp tm, wip_entities we

4123: fnd_file.put_line(fnd_file.log, 'Following jobs failed the close process because of unprocessed/uncosted WIP lot transactions:');
4124:
4125: -- Print the entities which FAILED CLOSE
4126: for rec in (select tm.wip_entity_id, we.wip_entity_name
4127: from wip_dj_close_temp tm, wip_entities we
4128: where tm.wip_entity_id = we.wip_entity_id
4129: and tm.organization_id = we.organization_id
4130: and tm.group_id = p_group_id
4131: and tm.organization_id = p_organization_id

Line 5273: FROM WIP_MOVE_TRANSACTIONS WMT, WIP_ENTITIES WE

5269:
5270: -- Processed WMT Record exists with a Later Txn Date
5271: SELECT 1
5272: INTO l_rowcount
5273: FROM WIP_MOVE_TRANSACTIONS WMT, WIP_ENTITIES WE
5274: WHERE WMT.wip_entity_id = we.wip_entity_id
5275: AND we.wip_entity_name = p_wip_entity_name
5276: AND we.organization_id = p_organization_id
5277: AND WMT.transaction_date > nvl(p_transaction_date, SYSDATE)

Line 5331: l_wip_entity_name WIP_ENTITIES.WIP_ENTITY_NAME%TYPE;

5327: l_rj_rowcount NUMBER := 0;
5328: l_stmt_num NUMBER := 0;
5329:
5330: l_organization_id NUMBER := 0;
5331: l_wip_entity_name WIP_ENTITIES.WIP_ENTITY_NAME%TYPE;
5332:
5333: BEGIN
5334:
5335: x_err_code := 0;

Line 5389: from wip_entities

5385: l_stmt_num := 30;
5386:
5387: select wip_entity_name, organization_id
5388: into l_wip_entity_name, l_organization_id
5389: from wip_entities
5390: Where wip_entity_id = p_wip_entity_id;
5391:
5392: l_stmt_num := 40;
5393: