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 WSM_STARTING_JOBS_INTERFACE

Line 200: CURSOR C_NET_QUANTITY_MERGE(hdr_id wsm_starting_jobs_interface.header_id%TYPE) is

196: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
197: AND rj.process_status = WIP_CONSTANTS.RUNNING;
198:
199: /*BA#1732786*/
200: CURSOR C_NET_QUANTITY_MERGE(hdr_id wsm_starting_jobs_interface.header_id%TYPE) is
201: select (wdj.net_quantity - wdj.quantity_scrapped)
202: potential_supply,
203: wdj.quantity_scrapped, --FP bugfix 3403087
204: we.wip_entity_name

Line 205: from wsm_starting_jobs_interface wsji,

201: select (wdj.net_quantity - wdj.quantity_scrapped)
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;

Line 457: wsm_starting_jobs_interface sj

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')
461: /* where rj.class_code is null -- ST bug fix 3150692 Overwrite the class code in the resulting jobs with the parent jobs's value

Line 542: wsm_starting_jobs_interface wsji

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)
546: -- WHERE wrji.class_code is null -- Commented to fix bug #3150692

Line 596: from wsm_starting_jobs_interface wsji,

592: into sj_wip_entity_name,
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;

Line 893: | from intraoperation_stepin wsm_starting_jobs_interface table |

889:
890:
891: /*----------------------------------------------------------------------------+
892: | Default starting_intraoperation_step in wsm_resulting_jobs_interface table. |
893: | from intraoperation_stepin wsm_starting_jobs_interface table |
894: +----------------------------------------------------------------------------*/
895:
896: l_stmt_num := 20;
897: UPDATE wsm_resulting_jobs_interface rj

Line 900: from wsm_starting_jobs_interface sj

896: l_stmt_num := 20;
897: UPDATE wsm_resulting_jobs_interface rj
898: SET rj.starting_intraoperation_step =
899: (select sj.intraoperation_step
900: from wsm_starting_jobs_interface sj
901: where sj.header_id = rj.header_id
902: and sj.representative_flag = 'Y')
903: WHERE rj.process_status = WIP_CONSTANTS.RUNNING
904: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

Line 1058: wsm_starting_jobs_interface sj,

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--
1062: AND sj.header_id = rj.header_id --VJ: Added for NSLBJ--

Line 1110: wsm_starting_jobs_interface sj,

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
1114: AND sj.internal_group_id = WSMPLOAD.G_GROUP_ID

Line 1291: wsm_STARTING_JOBS_INTERFACE wsji

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
1295: AND we.wip_entity_name = wsji.wip_entity_name;

Line 1377: WSM_STARTING_JOBS_INTERFACE SJ

1373: TXN.TRANSACTION_ID,
1374: TXN.HEADER_ID
1375: , TXN.ORGANIZATION_ID -- 2804945
1376: FROM WSM_SPLIT_MERGE_TXN_INTERFACE TXN,
1377: WSM_STARTING_JOBS_INTERFACE SJ
1378: WHERE TXN.INTERNAL_GROUP_ID = WSMPLOAD.G_GROUP_ID
1379: AND SJ.HEADER_ID = TXN.HEADER_ID
1380: AND TXN.header_id = WSMPLOAD.G_HEADER_ID -- XleSplits
1381: AND TXN.PROCESS_STATUS = WIP_CONSTANTS.RUNNING

Line 1429: FROM wsm_starting_jobs_interface wsji,

1425: , wsji.primary_item_id
1426: , wsji.intraoperation_step
1427: , wsji.operation_seq_num
1428: /*EA WLTEnh*/
1429: FROM wsm_starting_jobs_interface wsji,
1430: wsm_split_merge_txn_interface wsmti --VJ: CodeRVW: Added for NSLBJ--
1431: WHERE wsji.process_status = WIP_CONSTANTS.RUNNING
1432: AND wsji.internal_group_id = WSMPLOAD.G_GROUP_ID
1433: AND wsmti.internal_group_id = WSMPLOAD.G_GROUP_ID --VJ: CodeRVW: Added for NSLBJ--

Line 1740: From wsm_starting_jobs_interface

1736: Begin
1737: l_stmt_num := 10;
1738:
1739: Select null into l_dummy
1740: From wsm_starting_jobs_interface
1741: where header_id = l_cur_wsmti_rec.header_id;
1742:
1743: Exception
1744:

Line 1831: Update wsm_starting_jobs_interface wsji

1827: l_stmt_num := 14; -- Bug 2682603
1828: If l_cur_wsmti_rec.transaction_type_id <> WSMPCNST.BONUS Then
1829: l_stmt_num := 15;
1830:
1831: Update wsm_starting_jobs_interface wsji
1832: SET wsji.error_message = l_fnd_generic_err_msg
1833: , wsji.process_status = WIP_CONSTANTS.ERROR
1834: Where wsji.header_id = l_cur_wsmti_rec.header_id;
1835:

Line 1914: | validate header_id in wsm_starting_jobs_interface table |

1910:
1911: WSMPVLDT.l_wsji_error_flag := 0; -- Important to reset this for every header.
1912:
1913: /*-----------------------------------------------------------------+
1914: | validate header_id in wsm_starting_jobs_interface table |
1915: +-----------------------------------------------------------------*/
1916:
1917:
1918: l_stmt_num := 19;

Line 1959: | validate organization_id in wsm_starting_jobs_interface table |

1955:
1956:
1957: --VJ: Start Additions for NSLBJ--
1958: /*----------------------------------------------------------------+
1959: | validate organization_id in wsm_starting_jobs_interface table |
1960: +-----------------------------------------------------------------*/
1961:
1962: --VJ: 0314: Switched order of these 2 sqls for NSLBJ--
1963: l_stmt_num := 21;

Line 2053: | validate rep_lot_flag in wsm_starting_jobs_interface |

2049:
2050: --VJ: End Additions for NSLBJ--
2051:
2052: /*-----------------------------------------------------------------+
2053: | validate rep_lot_flag in wsm_starting_jobs_interface |
2054: +-----------------------------------------------------------------*/
2055:
2056: l_stmt_num := 25;
2057:

Line 2062: From wsm_starting_jobs_interface wsji

2058: Begin
2059: l_stmt_num := 26;
2060:
2061: select count(header_id) into l_dummy
2062: From wsm_starting_jobs_interface wsji
2063: Where wsji.header_id = l_cur_wsji_rec.wsji_header_id
2064: and wsji.representative_flag = 'Y'
2065: and exists (select 1
2066: from wsm_split_merge_txn_interface wsmti

Line 2178: | validate wip_entity_id in wsm_starting_jobs_interface table, |

2174:
2175: l_stmt_num := 29;
2176:
2177: /*-----------------------------------------------------------------+
2178: | validate wip_entity_id in wsm_starting_jobs_interface table, |
2179: | if wip_entity_name IS NULL : |
2180: | Verify wip_entity_id is a standard open WSM job. |
2181: +-----------------------------------------------------------------*/
2182:

Line 2362: | populate wip_entity_name, if NULL, in wsm_starting_jobs_interface|

2358:
2359: --VJ: Start Additions for NSLBJ--
2360:
2361: /*-----------------------------------------------------------------+
2362: | populate wip_entity_name, if NULL, in wsm_starting_jobs_interface|
2363: | table : based on wip_entity_id |
2364: +-----------------------------------------------------------------*/
2365:
2366: Begin

Line 2454: FROM wsm_starting_jobs_interface wsji,

2450: l_stmt_num := 34;
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

Line 2484: | validate operation_seq_num in wsm_starting_jobs_interface table |

2480: --VJ: CodeRVW: End Additions for NSLBJ--
2481:
2482:
2483: /*-----------------------------------------------------------------+
2484: | validate operation_seq_num in wsm_starting_jobs_interface table |
2485: +-----------------------------------------------------------------*/
2486:
2487: l_stmt_num := 35;
2488:

Line 2529: | Validate intraoperation_step in wsm_starting_jobs_interface |

2525: End;
2526:
2527:
2528: /*-----------------------------------------------------------------+
2529: | Validate intraoperation_step in wsm_starting_jobs_interface |
2530: | table: For split, merge, and updates, the intraoperation step |
2531: | can only be Queue or To Move |
2532: +-----------------------------------------------------------------*/
2533:

Line 2589: | no wsm_starting_jobs_interface for bonus txn. |

2585: -- be OSP resources at an operation when a wip lot transaction is being
2586: -- carried out.
2587:
2588: /*-----------------------------------------------------------------+
2589: | no wsm_starting_jobs_interface for bonus txn. |
2590: +-----------------------------------------------------------------*/
2591:
2592:
2593: -- WLTEnh. Strictly this is not necessary.

Line 2649: FROM wsm_starting_jobs_interface wsji1,

2645: /* ST : Bug fix 3880193 : Commenting the below SQL as it fails when merging more than 2 jobs */
2646: /*
2647: SELECT count(*)
2648: INTO l_count
2649: FROM wsm_starting_jobs_interface wsji1,
2650: wsm_starting_jobs_interface wsji2
2651: WHERE wsji1.header_id = l_cur_wsji_rec.wsji_header_id
2652: AND wsji1.header_id = wsji2.header_id
2653: AND wsji1.rowid <> wsji2.rowid

Line 2650: wsm_starting_jobs_interface wsji2

2646: /*
2647: SELECT count(*)
2648: INTO l_count
2649: FROM wsm_starting_jobs_interface wsji1,
2650: wsm_starting_jobs_interface wsji2
2651: WHERE wsji1.header_id = l_cur_wsji_rec.wsji_header_id
2652: AND wsji1.header_id = wsji2.header_id
2653: AND wsji1.rowid <> wsji2.rowid
2654: AND (l_cur_wsji_rec.wip_entity_name = wsji2.wip_entity_name

Line 2664: FROM wsm_starting_jobs_interface wsji

2660: */
2661: /* ST : Bug fix 3880193 : Added the below SQL */
2662: SELECT count(*)
2663: INTO l_count
2664: FROM wsm_starting_jobs_interface wsji
2665: WHERE wsji.header_id = l_cur_wsji_rec.wsji_header_id
2666: AND (l_cur_wsji_rec.wip_entity_name = wsji.wip_entity_name
2667: OR
2668: l_cur_wsji_rec.wip_entity_id = wsji.wip_entity_id);

Line 2699: | wsm_starting_jobs_interface table, if NULL. |

2695: --VJ: Start Additions for NSLBJ--
2696:
2697: /*----------------------------------------------+
2698: | populate primary_item_id/routing_seq_id in |
2699: | wsm_starting_jobs_interface table, if NULL. |
2700: +----------------------------------------------*/
2701:
2702:
2703: --VJ: CodeRVW: Start Changes for NSLBJ--

Line 2759: | Validate common_routing_sequence_id in wsm_starting_jobs_interface|

2755:
2756: --VJ: End Additions for NSLBJ--
2757:
2758: /*-----------------------------------------------------------------+
2759: | Validate common_routing_sequence_id in wsm_starting_jobs_interface|
2760: +-----------------------------------------------------------------*/
2761:
2762: /*BA#1623701*/
2763:

Line 2844: FND_MESSAGE.SET_TOKEN('TABLE_NAME','WSM_STARTING_JOBS_INTERFACE');

2840: -- Then ERROR condition.
2841:
2842:
2843: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_ROUTING_ID');
2844: FND_MESSAGE.SET_TOKEN('TABLE_NAME','WSM_STARTING_JOBS_INTERFACE');
2845: l_fnd_err_msg := FND_MESSAGE.GET;
2846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2847:
2848: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 2875: UPDATE wsm_starting_jobs_interface wsji

2871: l_stmt_num := 49;
2872: --VJ: Start Changes for NSLBJ--
2873: --Changed the sql since org_id has been added to WSJI now--
2874:
2875: UPDATE wsm_starting_jobs_interface wsji
2876: SET wsji.error_message = l_fnd_generic_err_msg
2877: WHERE wsji.header_id = l_header_id
2878: and NOT EXISTS (select 1
2879: from bom_operational_routings bor

Line 2919: | is merge txn in wsm_starting_jobs_interface |

2915:
2916: -- Begin validation logic change for NSO-WLT
2917: /*---------------------------------------------------------------------+
2918: | Validate that the starting operation is a standard op when txn_type |
2919: | is merge txn in wsm_starting_jobs_interface |
2920: +---------------------------------------------------------------------*/
2921:
2922:
2923: if (l_cur_wsji_rec.transaction_type_id = WSMPCNST.MERGE) then

Line 2932: FROM wsm_starting_jobs_interface wsji,

2928: l_stmt_num := 50;
2929:
2930: SELECT bso.standard_operation_id
2931: INTO l_merge_std_op_id
2932: FROM wsm_starting_jobs_interface wsji,
2933: wip_operations wo,
2934: bom_standard_operations bso
2935: WHERE wsji.header_id = l_cur_wsji_rec.wsji_header_id
2936: --AND NVL(wsji.representative_flag, l_cur_wsji_rec.representative_flag) = 'Y'

Line 2989: UPDATE wsm_starting_jobs_interface wsji

2985:
2986: --Start Additions to fix bug #2265237--
2987: --Whenever there's error, error_message column in interface table should be updated.
2988: l_stmt_num := 51;
2989: UPDATE wsm_starting_jobs_interface wsji
2990: SET wsji.error_message = l_fnd_generic_err_msg
2991: WHERE wsji.header_id = l_header_id;
2992: --End Additions to fix bug #2265237--
2993:

Line 3065: Update wsm_starting_jobs_interface wsji

3061: -- primary_item_id, routing_seq_id
3062:
3063: l_stmt_num := 54;
3064:
3065: Update wsm_starting_jobs_interface wsji
3066: Set wsji.wip_entity_id = l_cur_wsji_rec.wip_entity_id
3067: , wsji.wip_entity_name = l_cur_wsji_rec.wip_entity_name
3068: , wsji.representative_flag = l_cur_wsji_rec.representative_flag
3069: , wsji.primary_item_id = l_cur_wsji_rec.primary_item_id

Line 3084: Update wsm_starting_jobs_interface wsji

3080: If l_wsji_error_flag = 1 Then -- Only a Single UPDATE on WSMTI
3081:
3082: l_stmt_num := 55;
3083:
3084: Update wsm_starting_jobs_interface wsji
3085: SET wsji.error_message = l_fnd_generic_err_msg
3086: , wsji.process_status = WIP_CONSTANTS.ERROR
3087: WHERE wsji.rowid = l_cur_wsji_rec.wsji_rowid;
3088:

Line 3239: from wsm_starting_jobs_interface wsji

3235: l_stmt_num := 62;
3236:
3237: select primary_item_id
3238: into l_sj_item_id
3239: from wsm_starting_jobs_interface wsji
3240: where header_id = l_header_id;
3241:
3242: if (l_split_has_update_assy = 0
3243: AND l_primary_item_id <> l_sj_item_id)

Line 3361: FROM wsm_starting_jobs_interface wsji,

3357:
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 (

Line 3538: wsm_starting_jobs_interface sj

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';
3542: EXCEPTION

Line 3866: FROM wsm_starting_jobs_interface wsji,

3862: l_st_bom_seq_id,
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';

Line 3892: FROM wsm_starting_jobs_interface wsji,

3888: l_st_bom_seq_id,
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;

Line 4271: wsm_starting_jobs_interface sj

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
4275: AND nvl(sj.representative_flag, 'N') = 'N');

Line 4569: from wsm_starting_jobs_interface sj

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
4570: where sj.header_id = wrji.header_id
4571: and ( sj.wip_entity_id = we.wip_entity_id OR
4572: (sj.wip_entity_name = we.wip_entity_name
4573: and sj.organization_id = we.organization_id)

Line 4611: from wsm_starting_jobs_interface sj,

4607: UPDATE wsm_resulting_jobs_interface wrji
4608: SET wrji.error_message = l_fnd_generic_err_msg
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

Line 4660: wsm_starting_jobs_interface wsji

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:
4664: IF (l_start_we_name = l_job_name) THEN -- Start and resulting job name are same--

Line 4898: from wsm_starting_jobs_interface sj,

4894: UPDATE wsm_resulting_jobs_interface wrji
4895: SET wrji.error_message = l_fnd_generic_err_msg
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)

Line 4992: wsm_starting_jobs_interface sj,

4988: WHERE wrji.header_id = l_header_id
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

Line 5031: wsm_starting_jobs_interface wsji

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:
5035: l_stmt_num := 118;

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 5680: wsm_starting_jobs_interface wsji

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:
5684: ELSIF (l_txn_type = WSMPCNST.MERGE) THEN

Line 5691: wsm_starting_jobs_interface wsji

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;
5695:

Line 5801: l_sj_intraoperation_step WSM_STARTING_JOBS_INTERFACE.INTRAOPERATION_STEP%TYPE default NULL; -- BBK NSOWLT

5797: l_op_seq_id NUMBER;
5798: l_bos_opseq_num NUMBER; -- BBK NSOWLT
5799: l_bos_stdop_id NUMBER; -- BBK NSOWLT
5800: l_bso_stdop_code BOM_STANDARD_OPERATIONS.OPERATION_CODE%TYPE default NULL; -- BBK NSOWLT
5801: l_sj_intraoperation_step WSM_STARTING_JOBS_INTERFACE.INTRAOPERATION_STEP%TYPE default NULL; -- BBK NSOWLT
5802: l_rj_rout_seq_id NUMBER;
5803: l_end_op_seq_id NUMBER;
5804: x_error_code NUMBER;
5805: x_error_msg VARCHAR2(255);

Line 5949: wsm_starting_jobs_interface sj,

5945: l_sj_intraoperation_step, -- BBK:NSO:WLT
5946: l_rj_rout_seq_id --VJ: Added for NSLBJ--
5947: FROM bom_operation_sequences bos,
5948: wsm_resulting_jobs_interface rj,
5949: wsm_starting_jobs_interface sj,
5950: wip_operations wo
5951: WHERE sj.header_id = l_header_id
5952: AND rj.rowid = l_wrji_rowid --SpUA add
5953: AND sj.header_id = rj.header_id

Line 6008: FROM wsm_starting_jobs_interface wsji,

6004:
6005: l_stmt_num := 148;
6006: SELECT wsji.intraoperation_step
6007: INTO l_st_iop
6008: FROM wsm_starting_jobs_interface wsji,
6009: wsm_split_merge_txn_interface wsmti
6010: WHERE wsji.header_id = l_header_id
6011: AND wsmti.header_id = l_header_id
6012: AND (wsmti.transaction_type_id in

Line 6093: from wsm_starting_jobs_interface sj,

6089: and wrji.process_status = WIP_CONSTANTS.RUNNING
6090: and wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
6091: and exists (
6092: select 1
6093: from wsm_starting_jobs_interface sj,
6094: wsm_split_merge_txn_interface txn
6095: where txn.header_id = wrji.header_id
6096: and txn.header_id = sj.header_id
6097: and (txn.transaction_type_id in

Line 6164: from wsm_starting_jobs_interface sj,

6160: and wrji.process_status = WIP_CONSTANTS.RUNNING
6161: and wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
6162: and exists (
6163: select 1
6164: from wsm_starting_jobs_interface sj,
6165: wsm_split_merge_txn_interface txn
6166: where txn.header_id = wrji.header_id
6167: and txn.header_id = sj.header_id
6168: and (txn.transaction_type_id in

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 7170: wsm_starting_jobs_interface wsji

7166: , l_sj_intraoperation_step
7167: from
7168: bom_operational_routings bor,
7169: wsm_resulting_jobs_interface wrji,
7170: wsm_starting_jobs_interface wsji
7171: where
7172: bor.assembly_item_id = wrji.primary_item_id
7173: and nvl(bor.alternate_routing_designator, '*') = nvl(wrji.alternate_routing_designator, '*')
7174: and wrji.header_id = l_header_id

Line 7202: wsm_starting_jobs_interface wsji

7198: , l_organization_id
7199: , l_sj_intraoperation_step
7200: from
7201: wsm_resulting_jobs_interface wrji,
7202: wsm_starting_jobs_interface wsji
7203: where
7204: wrji.header_id = l_header_id
7205: and wrji.rowid = l_wrji_rowid --SpUA add
7206: and wsji.header_id = wrji.header_id

Line 8216: wsm_starting_jobs_interface wsji

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:
8220: l_stmt_num := 219;

Line 8564: from wsm_starting_jobs_interface

8560: ELSE
8561: l_stmt_num := 230;
8562: select intraoperation_step
8563: into l_sj_intraoperation_step
8564: from wsm_starting_jobs_interface
8565: where header_id = l_header_id;
8566: END IF;
8567: --For Option C, Queue or ToMove, execute this. For Option A, only if it's Queue.
8568: if (l_sj_intraoperation_step <> WIP_CONSTANTS.TOMOVE OR l_profile_value = 1)

Line 8679: Update wsm_starting_jobs_interface wsji

8675: If l_txn_type <> WSMPCNST.BONUS Then
8676:
8677: l_stmt_num := 235;
8678:
8679: Update wsm_starting_jobs_interface wsji
8680: SET wsji.error_message = l_fnd_generic_err_msg
8681: , wsji.process_status = WIP_CONSTANTS.ERROR
8682: Where wsji.header_id = l_header_id;
8683:

Line 8737: UPDATE WSM_STARTING_JOBS_INTERFACE wsji

8733:
8734: FND_FILE.PUT_LINE(FND_FILE.LOG,'check_wmti returned error:Pending move txn in this lot');
8735:
8736: l_stmt_num := 238;
8737: UPDATE WSM_STARTING_JOBS_INTERFACE wsji
8738: SET wsji.error_message = l_fnd_generic_err_msg
8739: , wsji.process_status = WIP_CONSTANTS.ERROR
8740: WHERE wsji.header_id = l_header_id
8741: AND wsji.WIP_ENTITY_ID = l_wip_id;

Line 8799: UPDATE WSM_STARTING_JOBS_INTERFACE wsji

8795: IF (wsmputil.check_wsmt(l_wip_id, null, l_txn_id, l_txn_date, p_err_num, p_err_msg, l_organization_id) <> 0) THEN
8796: FND_FILE.PUT_LINE(FND_FILE.LOG,'check_wsmt returned error:Pending wip lot txns in this lot');
8797:
8798: l_stmt_num := 242;
8799: UPDATE WSM_STARTING_JOBS_INTERFACE wsji
8800: SET wsji.error_message = l_fnd_generic_err_msg
8801: , wsji.process_status = WIP_CONSTANTS.ERROR
8802: WHERE wsji.header_id = l_header_id
8803: AND wsji.WIP_ENTITY_ID = l_wip_id;

Line 8863: UPDATE WSM_STARTING_JOBS_INTERFACE wsji

8859: FND_FILE.PUT_LINE(FND_FILE.LOG,'check_wlmti returned error:Pending wip move interface txns in this lot');
8860: END IF;
8861:
8862: l_stmt_num := 246;
8863: UPDATE WSM_STARTING_JOBS_INTERFACE wsji
8864: SET wsji.error_message = l_fnd_generic_err_msg
8865: , wsji.process_status = WIP_CONSTANTS.ERROR
8866: WHERE wsji.header_id = l_header_id
8867: AND wsji.WIP_ENTITY_ID = l_wip_id;

Line 8949: UPDATE WSM_STARTING_JOBS_INTERFACE wsji

8945: ||'Record for Header Id '
8946: ||l_header_id
8947: ||' set to ERROR in WRJI for wip_entity_name='||l_job_name);
8948: l_stmt_num := 251;
8949: UPDATE WSM_STARTING_JOBS_INTERFACE wsji
8950: SET wsji.error_message = l_fnd_generic_err_msg
8951: , wsji.process_status = WIP_CONSTANTS.ERROR
8952: WHERE wsji.header_id = l_header_id;
8953:

Line 9013: UPDATE WSM_STARTING_JOBS_INTERFACE wsji

9009: ||l_header_id
9010: ||' set to ERROR in WRJI for wip_entity_name='||l_job_name);
9011:
9012: l_stmt_num := 255;
9013: UPDATE WSM_STARTING_JOBS_INTERFACE wsji
9014: SET wsji.error_message = l_fnd_generic_err_msg
9015: , wsji.process_status = WIP_CONSTANTS.ERROR
9016: WHERE wsji.header_id = l_header_id;
9017:

Line 9077: UPDATE WSM_STARTING_JOBS_INTERFACE wsji

9073: ||l_header_id
9074: ||' set to ERROR in WRJI for wip_entity_name='||l_job_name);
9075:
9076: l_stmt_num := 259;
9077: UPDATE WSM_STARTING_JOBS_INTERFACE wsji
9078: SET wsji.error_message = l_fnd_generic_err_msg
9079: , wsji.process_status = WIP_CONSTANTS.ERROR
9080: WHERE wsji.header_id = l_header_id;
9081:

Line 9234: FROM wsm_starting_jobs_interface

9230: UPDATE wsm_split_merge_txn_interface
9231: SET error_message = l_fnd_err_msg -- error_message = error_message || l_fnd_err_msg
9232: , process_status = WIP_CONSTANTS.ERROR -- WLTEnh
9233: WHERE header_id IN ( SELECT distinct header_id
9234: FROM wsm_starting_jobs_interface
9235: WHERE error_message IS NOT NULL)
9236: AND process_status = WIP_CONSTANTS.RUNNING;
9237:
9238: