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_DISCRETE_JOBS

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 456: from wip_discrete_jobs dis,

452: -- for txn not in bonus
453: l_stmt_num := 9;
454: update wsm_resulting_jobs_interface rj
455: set class_code = (select dis.class_code
456: from wip_discrete_jobs dis,
457: wsm_starting_jobs_interface sj
458: where sj.header_id = rj.header_id
459: and sj.wip_entity_id = dis.wip_entity_id
460: and sj.representative_flag = 'Y')

Line 541: FROM wip_discrete_jobs wdj,

537: --as well as for the starting job in other transactions (except Bonus)
538: l_stmt_num := 12;
539: UPDATE wsm_resulting_jobs_interface wrji
540: SET wrji.class_code = (SELECT wdj.class_code
541: FROM wip_discrete_jobs wdj,
542: wsm_starting_jobs_interface wsji
543: WHERE wsji.wip_entity_id = wdj.wip_entity_id
544: AND wsji.representative_flag = 'Y'
545: AND wsji.header_id = wrji.header_id)

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 617: from wip_discrete_jobs wdj,

613: ELSE
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)

Line 643: from wip_discrete_jobs wdj,

639: ELSE
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)

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 1057: FROM wip_discrete_jobs wdj,

1053: wdj.completion_locator_id /* ST bug 3336844 ) */ -- BBK- Bug#2795951
1054: -- NULL) -- CZH.BUG2398718
1055: -- This is for other locator types like Dynamic Entry (3) and
1056: -- Item level control (4), which are not supported by OSFM.
1057: FROM wip_discrete_jobs wdj,
1058: wsm_starting_jobs_interface sj,
1059: mtl_secondary_inventories msi -- CZH.BUG2398718
1060: WHERE wdj.wip_entity_id = sj.wip_entity_id
1061: AND wdj.organization_id = sj.organization_id --VJ: Added for NSLBJ--

Line 1109: FROM wip_discrete_jobs wdj,

1105: wdj.completion_locator_id /* ST bug fix 3336844 ) */ -- BBK- Bug#2795951
1106: -- NULL) -- CZH.BUG2398718
1107: -- This is for other locator types like Dynamic Entry (3) and
1108: -- Item level control (4), which are not supported by OSFM.
1109: FROM wip_discrete_jobs wdj,
1110: wsm_starting_jobs_interface sj,
1111: mtl_secondary_inventories msi -- CZH.BUG2398718
1112: WHERE wdj.wip_entity_id = sj.wip_entity_id
1113: AND sj.header_id = p_header_id -- WLTEnh --rj.header_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 2267: from wip_discrete_jobs dis,

2263: Begin
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

Line 2371: from wip_discrete_jobs dis

2367:
2368: l_stmt_num := 33;
2369:
2370: select null into l_dummy
2371: from wip_discrete_jobs dis
2372: where dis.wip_entity_id = l_cur_wsji_rec.wip_entity_id
2373: and dis.organization_id = l_cur_wsji_rec.organization_id
2374: and dis.status_type = 3;
2375:

Line 2455: wip_discrete_jobs wdj,

2451:
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

Line 2711: FROM wip_discrete_jobs wdj

2707: l_stmt_num := 43;
2708:
2709: SELECT wdj.primary_item_id, wdj.common_routing_sequence_id, wdj.job_type
2710: into l_cur_wsji_rec.primary_item_id, l_cur_wsji_rec.routing_seq_id, l_wsji_job_type
2711: FROM wip_discrete_jobs wdj
2712: WHERE wdj.organization_id = l_cur_wsji_rec.organization_id
2713: AND wdj.wip_entity_id = l_cur_wsji_rec.wip_entity_id
2714: AND (
2715: wdj.primary_item_id <> nvl(l_cur_wsji_rec.primary_item_id, -9999)

Line 2779: from wip_discrete_jobs wdj

2775: into l_rtg_seq_id
2776: , l_alt_rtg_desig
2777: , l_wsji_job_type -- Bug# 2679705
2778: , l_wsji_routing_reference_id -- Bug#2679705
2779: from wip_discrete_jobs wdj
2780: where wdj.wip_entity_id=l_cur_wsji_rec.wip_entity_id
2781: and l_cur_wsji_rec.representative_flag='Y' ;
2782:
2783:

Line 2803: from wip_discrete_jobs wdj

2799: into l_rtg_seq_id
2800: , l_alt_rtg_desig
2801: , l_wsji_job_type -- Bug# 2679705
2802: , l_wsji_routing_reference_id -- Bug#2679705
2803: from wip_discrete_jobs wdj
2804: where wdj.wip_entity_id=l_cur_wsji_rec.wip_entity_id
2805: and l_cur_wsji_rec.representative_flag='Y' ;
2806:
2807: Exception

Line 3362: wip_discrete_jobs wdj,

3358: --VJ: CodeRVW: Start Additions for NSLBJ--
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

Line 3537: from wip_discrete_jobs dis,

3533: select dis.scheduled_start_date,
3534: dis.scheduled_completion_date
3535: into l_scheduled_start_date,
3536: l_scheduled_completion_date
3537: from wip_discrete_jobs dis,
3538: wsm_starting_jobs_interface sj
3539: where sj.header_id = l_header_id
3540: and sj.wip_entity_id = dis.wip_entity_id
3541: and sj.representative_flag = 'Y';

Line 3691: FROM wip_discrete_jobs wdj,

3687: l_wdj_bom_rev,
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

Line 3867: wip_discrete_jobs wdj

3863: l_st_rtg_ref_id,
3864: l_st_alt_rtg_desig,
3865: l_st_rtg_seq_id
3866: FROM wsm_starting_jobs_interface wsji,
3867: wip_discrete_jobs wdj
3868: WHERE wsji.header_id = l_header_id
3869: AND wsji.wip_entity_id = wdj.wip_entity_id
3870: AND wsji.representative_flag='Y';
3871: ELSE

Line 3893: wip_discrete_jobs wdj

3889: l_st_rtg_ref_id,
3890: l_st_alt_rtg_desig,
3891: l_st_rtg_seq_id
3892: FROM wsm_starting_jobs_interface wsji,
3893: wip_discrete_jobs wdj
3894: WHERE wsji.header_id = l_header_id
3895: AND wsji.wip_entity_id = wdj.wip_entity_id;
3896: END IF;
3897:

Line 4565: from wip_discrete_jobs_all_v we

4561: UPDATE wsm_resulting_jobs_interface wrji
4562: SET wrji.error_message = l_fnd_generic_err_msg
4563: WHERE wrji.header_id = l_header_id
4564: and exists (select null
4565: from wip_discrete_jobs_all_v we
4566: where we.wip_entity_name = wrji.wip_entity_name
4567: and we.organization_id = wrji.organization_id
4568: and not exists (select null
4569: from wsm_starting_jobs_interface sj

Line 4900: wip_discrete_jobs dj

4896: WHERE wrji.header_id = l_header_id
4897: and exists (select null
4898: from wsm_starting_jobs_interface sj,
4899: wsm_split_merge_txn_interface txn,
4900: wip_discrete_jobs dj
4901: where sj.wip_entity_id = dj.wip_entity_id
4902: and dj.primary_item_id = nvl(wrji.primary_item_id,dj.primary_item_id)
4903: and txn.header_id = wrji.header_id
4904: and sj.header_id = txn.header_id

Line 4993: wip_discrete_jobs dj

4989: and ( (wrji.start_quantity < 0 OR nvl(wrji.start_quantity,0) = 0)
4990: or (exists (select null
4991: from wsm_split_merge_txn_interface txn,
4992: wsm_starting_jobs_interface sj,
4993: wip_discrete_jobs dj
4994: where txn.header_id = wrji.header_id
4995: and txn.header_id = sj.header_id
4996: and txn.transaction_type_id = WSMPCNST.UPDATE_QUANTITY
4997: and sj.wip_entity_id = dj.wip_entity_id

Line 5030: FROM wip_discrete_jobs wdj,

5026: WSMPCNST.UPDATE_LOT_NAME)) THEN
5027: l_stmt_num := 117;
5028: SELECT wdj.start_quantity
5029: INTO l_wdj_st_qty
5030: FROM wip_discrete_jobs wdj,
5031: wsm_starting_jobs_interface wsji
5032: WHERE wsji.header_id = l_header_id
5033: AND wsji.wip_entity_id = wdj.wip_entity_id;
5034:

Line 5128: from wip_discrete_jobs wdj, wsm_starting_jobs_interface wsji

5124: if (l_txn_type = WSMPCNST.MERGE) then
5125: l_stmt_num := 121;
5126: select common_routing_sequence_id, nvl(alternate_routing_designator, '-1')
5127: into l_rtg_seq_id, l_alt_rtg_desig
5128: from wip_discrete_jobs wdj, wsm_starting_jobs_interface wsji
5129: where wdj.wip_entity_id=wsji.wip_entity_id
5130: and wsji.representative_flag='Y'
5131: and wsji.header_id = l_header_id;
5132: else

Line 5136: from wip_discrete_jobs wdj, wsm_starting_jobs_interface wsji

5132: else
5133: l_stmt_num := 122;
5134: select common_routing_sequence_id, nvl(alternate_routing_designator, '-1')
5135: into l_rtg_seq_id, l_alt_rtg_desig
5136: from wip_discrete_jobs wdj, wsm_starting_jobs_interface wsji
5137: where wdj.wip_entity_id=wsji.wip_entity_id
5138: and wsji.header_id=l_header_id;
5139: end if;
5140:

Line 5528: from wip_discrete_jobs wdj, wsm_starting_jobs_interface wsji

5524: select nvl(common_routing_sequence_id, -1), nvl(alternate_routing_designator, '-1')
5525: , routing_revision, routing_revision_date -- Added for APS-WLT
5526: into l_rtg_seq_id, l_alt_rtg_desig
5527: , l_wdj_rtg_rev, l_wdj_rtg_rev_dt -- Added for APS-WLT
5528: from wip_discrete_jobs wdj, wsm_starting_jobs_interface wsji
5529: where wdj.wip_entity_id=wsji.wip_entity_id
5530: and wsji.header_id=l_header_id;
5531:
5532: SELECT nvl(common_routing_sequence_id, -1), nvl(alternate_routing_designator, '-1')

Line 5679: from wip_discrete_jobs wdj,

5675: select wdj.routing_revision,
5676: wdj.routing_revision_date
5677: into l_rtg_rev,
5678: l_rtg_rev_date
5679: from wip_discrete_jobs wdj,
5680: wsm_starting_jobs_interface wsji
5681: where wdj.wip_entity_id=wsji.wip_entity_id
5682: and wsji.header_id=l_header_id;
5683:

Line 5690: from wip_discrete_jobs wdj,

5686: select wdj.routing_revision,
5687: wdj.routing_revision_date
5688: into l_rtg_rev,
5689: l_rtg_rev_date
5690: from wip_discrete_jobs wdj,
5691: wsm_starting_jobs_interface wsji
5692: where wdj.wip_entity_id=wsji.wip_entity_id
5693: and wsji.representative_flag='Y'
5694: and wsji.header_id=l_header_id;

Line 6226: from wip_discrete_jobs wdj, wsm_starting_jobs_interface wsji

6222: if (l_txn_type = WSMPCNST.MERGE) then
6223: l_stmt_num := 153;
6224: select common_bom_sequence_id, nvl(alternate_bom_designator, '-1')
6225: into l_bom_seq_id, l_alt_bom_desig
6226: from wip_discrete_jobs wdj, wsm_starting_jobs_interface wsji
6227: where wdj.wip_entity_id=wsji.wip_entity_id
6228: and wsji.representative_flag='Y'
6229: and wsji.header_id=l_header_id;
6230: else

Line 6234: from wip_discrete_jobs wdj, wsm_starting_jobs_interface wsji

6230: else
6231: l_stmt_num := 154;
6232: select common_bom_sequence_id, nvl(alternate_bom_designator, '-1')
6233: into l_bom_seq_id, l_alt_bom_desig
6234: from wip_discrete_jobs wdj, wsm_starting_jobs_interface wsji
6235: where wdj.wip_entity_id=wsji.wip_entity_id
6236: and wsji.header_id=l_header_id;
6237: end if;
6238:

Line 6670: from wip_discrete_jobs wdj, wsm_starting_jobs_interface wsji

6666: if (l_txn_type in (WSMPCNST.UPDATE_ROUTING)) THEN
6667: l_stmt_num := 167;
6668: select nvl(common_bom_sequence_id, -1), nvl(alternate_bom_designator, '-1')
6669: into l_bom_seq_id, l_alt_bom_desig
6670: from wip_discrete_jobs wdj, wsm_starting_jobs_interface wsji
6671: where wdj.wip_entity_id=wsji.wip_entity_id
6672: and wsji.header_id=l_header_id;
6673:
6674: l_stmt_num := 168;

Line 8215: from wip_discrete_jobs wdj,

8211:
8212: l_stmt_num := 218;
8213: SELECT wdj.scheduled_completion_date
8214: into l_sch_comp_date
8215: from wip_discrete_jobs wdj,
8216: wsm_starting_jobs_interface wsji
8217: WHERE wdj.wip_entity_id = wsji.wip_entity_id
8218: AND wsji.header_id = l_header_id;
8219: