eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSMPVLDT dependencies on WIP_ENTITIES

Line 206: wip_discrete_jobs wdj, wip_entities we

202: potential_supply,
203: wdj.quantity_scrapped, --FP bugfix 3403087
204: we.wip_entity_name
205: from wsm_starting_jobs_interface wsji,
206: wip_discrete_jobs wdj, wip_entities we
207: WHERE wsji.header_id = hdr_id
208: AND wsji.wip_entity_id = wdj.wip_entity_id
209: AND we.wip_entity_id = wsji.wip_entity_id;
210:

Line 597: wip_discrete_jobs wdj, wip_entities we

593: sj_start_quantity,
594: sj_net_quantity,
595: sj_scrap_quantity
596: from wsm_starting_jobs_interface wsji,
597: wip_discrete_jobs wdj, wip_entities we
598: WHERE wsji.header_id = c_net_quantity_rec.header_id
599: AND wsji.wip_entity_id = wdj.wip_entity_id
600: AND wsji.wip_entity_id = we.wip_entity_id;
601:

Line 618: wip_entities we

614: --Start FP bugfix 3403087
615: update wsm_resulting_jobs_interface wrji
616: set wrji.net_quantity = (select wdj.net_quantity
617: from wip_discrete_jobs wdj,
618: wip_entities we
619: where wdj.wip_entity_id = we.wip_entity_id
620: and wdj.organization_id = we.organization_id
621: and we.wip_entity_name = c_net_quantity_rec.wip_entity_name)
622: where wrji.net_quantity is null

Line 644: wip_entities we

640: --Start FP bugfix 3403087
641: update wsm_resulting_jobs_interface wrji
642: set wrji.net_quantity = (select wdj.net_quantity
643: from wip_discrete_jobs wdj,
644: wip_entities we
645: where wdj.wip_entity_id = we.wip_entity_id
646: and wdj.organization_id = we.organization_id
647: and we.wip_entity_name = c_net_quantity_rec.wip_entity_name)
648: where wrji.net_quantity is null

Line 707: from wip_discrete_jobs wdj, wip_entities we

703: -- (select (wrji.start_quantity-wdj.start_quantity+wdj.net_quantity)
704: (select (wrji.start_quantity*(wdj.net_quantity-wdj.quantity_scrapped)
705: *(1/(wdj.start_quantity-wdj.quantity_scrapped))+wdj.quantity_scrapped)
706: -- End : Changes for bug#3181486 - Net Planned Qty --
707: from wip_discrete_jobs wdj, wip_entities we
708: where wdj.wip_entity_id=we.wip_entity_id
709: and we.wip_entity_name=wrji.wip_entity_name)
710: WHERE wrji.net_quantity is NULL
711: AND wrji.header_id = c_net_quantity_rec.header_id;

Line 1290: FROM wip_entities we,

1286: CURSOR C_ST_WE_ID(l_header_id NUMBER) IS
1287: SELECT we.wip_entity_id,
1288: we.wip_entity_name,
1289: we.organization_id --VJ: CodeRVW: Added for NSLBJ--
1290: FROM wip_entities we,
1291: wsm_STARTING_JOBS_INTERFACE wsji
1292: WHERE wsji.header_id = l_header_id
1293: AND wsji.wip_entity_name IS NOT NULL
1294: AND we.organization_id = wsji.organization_id

Line 2198: from wip_discrete_jobs dis, wip_entities we

2194: Begin
2195: l_stmt_num := 31;
2196:
2197: select we.wip_entity_name into l_cur_wsji_rec.wip_entity_name
2198: from wip_discrete_jobs dis, wip_entities we
2199: where dis.wip_entity_id = l_cur_wsji_rec.wip_entity_id
2200: and dis.wip_entity_id = we.wip_entity_id
2201: and dis.organization_id = l_cur_wsji_rec.organization_id
2202: and dis.status_type = 3

Line 2268: wip_entities we

2264: l_stmt_num := 32;
2265:
2266: select dis.wip_entity_id into l_cur_wsji_rec.wip_entity_id
2267: from wip_discrete_jobs dis,
2268: wip_entities we
2269: where we.wip_entity_name = l_cur_wsji_rec.wip_entity_name
2270: and we.organization_id = l_cur_wsji_rec.organization_id
2271: and dis.wip_entity_id = we.wip_entity_id
2272: and dis.wip_entity_id = nvl(l_cur_wsji_rec.wip_entity_id, dis.wip_entity_id)

Line 2456: wip_entities we

2452: SELECT min(job_type), max(job_type)
2453: INTO l_min_job_type, l_max_job_type
2454: FROM wsm_starting_jobs_interface wsji,
2455: wip_discrete_jobs wdj,
2456: wip_entities we
2457: WHERE wsji.header_id = l_cur_wsji_rec.wsji_header_id
2458: AND NVL(wsji.wip_entity_name, l_cur_wsji_rec.wip_entity_name) = we.wip_entity_name
2459: AND NVL(wsji.organization_id, l_cur_wsji_rec.organization_id) = we.organization_id
2460: AND we.wip_entity_id = wdj.wip_entity_id;

Line 3363: wip_entities we

3359: SELECT min(wdj.job_type), max(wdj.job_type)
3360: INTO l_min_job_type, l_max_job_type
3361: FROM wsm_starting_jobs_interface wsji,
3362: wip_discrete_jobs wdj,
3363: wip_entities we
3364: WHERE wsji.header_id = l_header_id
3365: AND (
3366: (wsji.wip_entity_id = wdj.wip_entity_id
3367: and wsji.wip_entity_id = we.wip_entity_id)

Line 3692: wip_entities we

3688: l_wdj_bom_rev_dt,
3689: l_wdj_rtg_rev,
3690: l_wdj_rtg_rev_dt
3691: FROM wip_discrete_jobs wdj,
3692: wip_entities we
3693: --VJ: CodeRVW: Start Changes for NSLBJ--
3694: WHERE wdj.wip_entity_id = we.wip_entity_id
3695: AND wdj.organization_id = we.organization_id
3696: AND we.wip_entity_name = l_we_name --wrji.wip_entity_name

Line 4270: FROM wip_entities we,

4266: UPDATE wsm_resulting_jobs_interface wrji
4267: SET wrji.error_message = l_fnd_generic_err_msg
4268: WHERE wrji.header_id = l_header_id
4269: AND EXISTS (select 1
4270: FROM wip_entities we,
4271: wsm_starting_jobs_interface sj
4272: WHERE we.wip_entity_name = wrji.wip_entity_name
4273: AND we.wip_entity_id = sj.wip_entity_id
4274: AND wrji.header_id = sj.header_id

Line 4613: wip_entities we

4609: WHERE wrji.header_id = l_header_id
4610: and not exists ((select null
4611: from wsm_starting_jobs_interface sj,
4612: wsm_split_merge_txn_interface txn,
4613: wip_entities we
4614: where txn.header_id = wrji.header_id
4615: and sj.header_id = txn.header_id
4616: and wrji.wip_entity_name = we.wip_entity_name
4617: and we.organization_id = txn.organization_id

Line 4659: FROM wip_entities we,

4655: IF (l_txn_type = (WSMPCNST.UPDATE_LOT_NAME)) THEN
4656: l_stmt_num := 108;
4657: SELECT we.wip_entity_name
4658: INTO l_start_we_name
4659: FROM wip_entities we,
4660: wsm_starting_jobs_interface wsji
4661: WHERE wsji.wip_entity_id = we.wip_entity_id
4662: AND wsji.header_id = l_header_id;
4663: