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 WSMPLOAD

Line 108: -- AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

104: -- --SpUA begin
105: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND rj.split_has_update_assy = 1))
106: -- --SpUA end
107: -- AND rj.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
108: -- AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
109: -- AND rj.process_status = WIP_CONSTANTS.RUNNING
110: -- ORDER BY TXN.TRANSACTION_DATE;
111:
112: -- Changed the cursor to fix bug #3150692--

Line 126: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

122: wsm_split_merge_txn_interface txn
123: WHERE rj.header_id = p_header_id
124: AND txn.header_id = rj.header_id
125: AND rj.job_type = WIP_CONSTANTS.STANDARD
126: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
127: AND rj.process_status = WIP_CONSTANTS.RUNNING
128: ORDER BY TXN.TRANSACTION_DATE;
129:
130: CURSOR C_VLDT_CLASS_CODE_RJ(p_header_id NUMBER) is

Line 140: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

136: wsm_split_merge_txn_interface txn
137: WHERE txn.header_id = rj.header_id
138: AND rj.header_id = p_header_id -- WLTEnh Add
139: AND txn.transaction_type_id = WSMPCNST.BONUS
140: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
141: AND rj.process_status = WIP_CONSTANTS.RUNNING
142: ORDER BY TXN.TRANSACTION_DATE;
143:
144: CURSOR C_NONSTD_NO_CLASS_CODE_RJ(p_header_id NUMBER) is

Line 157: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

153: -- AND rj.header_id = p_header_id -- Commented to fix bug #3150692--
154: WHERE rj.header_id = p_header_id
155: AND txn.header_id = rj.header_id
156: AND rj.job_type = WIP_CONSTANTS.NONSTANDARD
157: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
158: AND rj.process_status = WIP_CONSTANTS.RUNNING
159: ORDER BY TXN.TRANSACTION_DATE;
160:
161: CURSOR C_NET_QUANTITY(p_header_id NUMBER) is

Line 179: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

175: (WSMPCNST.SPLIT,
176: WSMPCNST.MERGE,
177: WSMPCNST.BONUS,
178: WSMPCNST.UPDATE_QUANTITY)
179: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
180: AND rj.process_status = WIP_CONSTANTS.RUNNING;
181:
182:
183: CURSOR C_COPRODUCTS_SUPPLY(p_header_id NUMBER) is

Line 196: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

192: AND txn.transaction_type_id in
193: (WSMPCNST.SPLIT,
194: WSMPCNST.MERGE,
195: WSMPCNST.BONUS)
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

Line 310: -- AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

306: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND
307: -- rj.split_has_update_assy = 1)))
308: -- --SpUA end
309: -- AND rj.rowid = c_no_class_code_rj_rec.rj_rowid --SpUA Add
310: -- AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
311: -- AND rj.process_status = WIP_CONSTANTS.RUNNING;
312:
313: -- Changed to fix bug #3150692 --
314: l_stmt_num := 3;

Line 324: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

320: WHERE rj.header_id = c_no_class_code_rj_rec.header_id
321: -- AND rj.class_code IS NULL /* ST bug fix 3150692 Added check for class_code to prevent overwrite of user entered value for Std Bonus txn*/
322: /* ST bug fix 3150692 review comments : Commented the class code check */
323: AND rj.rowid = c_no_class_code_rj_rec.rj_rowid --SpUA Add
324: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
325: AND rj.process_status = WIP_CONSTANTS.RUNNING;
326:
327:
328: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN

Line 378: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID

374: -- End : Fix for bug #3150692 --
375:
376: ST bug fix 3150692 review comments end */
377: AND wrji.rowid = c_no_class_code_rj_rec.rj_rowid --SpUA add
378: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
379: AND wrji.process_status = WIP_CONSTANTS.RUNNING;
380:
381: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
382: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code');

Line 464: and rj.internal_group_id = WSMPLOAD.G_GROUP_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
462: and rj.process_status = WIP_CONSTANTS.RUNNING */ /* ST bug fix 3150692 : Commented the where condition */
463: where rj.process_status = WIP_CONSTANTS.RUNNING
464: and rj.internal_group_id = WSMPLOAD.G_GROUP_ID
465: and rj.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
466: and exists (
467: SELECT null
468: FROM wsm_split_merge_txn_interface txn2

Line 508: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID

504: UPDATE wsm_resulting_jobs_interface wrji
505: SET wrji.error_message = l_fnd_generic_err_msg
506: WHERE wrji.class_code is null
507: AND wrji.header_id = C_NONSTD_NO_CLASS_CODE_RJ_rec.header_id
508: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
509: AND wrji.process_status = WIP_CONSTANTS.RUNNING;
510:
511: IF (SQL%ROWCOUNT > 0) THEN
512: /* Added if stmt to fix bug #3722383 */

Line 548: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_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
547: WHERE wrji.header_id = C_NONSTD_NO_CLASS_CODE_RJ_rec.header_id
548: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
549: AND wrji.process_status = WIP_CONSTANTS.RUNNING;
550:
551: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
552: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code in Resulting Jobs');

Line 904: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

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
905: AND rj.header_id = p_header_id -- WLTEnh
906: AND rj.starting_intraoperation_step is null;
907:
908: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN

Line 926: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID

922: UPDATE wsm_resulting_jobs_interface wrji
923: SET wrji.starting_intraoperation_step = WIP_CONSTANTS.QUEUE
924: WHERE wrji.starting_intraoperation_step IS NULL
925: AND wrji.process_status = WIP_CONSTANTS.RUNNING
926: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
927: AND wrji.header_id = p_header_id -- WLTEnh
928: AND EXISTS(SELECT 1
929: FROM wsm_split_merge_txn_interface sji
930: WHERE sji.header_id = wrji.header_id

Line 953: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

949: l_stmt_num := 22;
950: UPDATE wsm_resulting_jobs_interface rj
951: SET rj.forward_op_option = 4
952: WHERE rj.process_status = WIP_CONSTANTS.RUNNING
953: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
954: AND rj.forward_op_option <> 4
955: AND rj.header_id = p_header_id -- WLTEnh
956: AND rj.header_id IN (SELECT header_id
957: FROM wsm_split_merge_txn_interface

Line 958: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID

954: AND rj.forward_op_option <> 4
955: AND rj.header_id = p_header_id -- WLTEnh
956: AND rj.header_id IN (SELECT header_id
957: FROM wsm_split_merge_txn_interface
958: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID
959: AND process_status = WIP_CONSTANTS.RUNNING
960: AND (transaction_type_id IN
961: --SpUA begin
962: ( --WSMPCNST.SPLIT,

Line 1013: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

1009: AND msi.organization_id = bor.organization_id -- CZH.BUG2398718
1010: )
1011: --VJ: End Changes for NSLBJ--
1012: WHERE rj.process_status = WIP_CONSTANTS.RUNNING
1013: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
1014: AND rj.rowid = l_wrji_rowid --SpUA Add
1015: AND rj.completion_subinventory is null
1016: AND rj.common_routing_sequence_id is not null -- CZH.BUG2398718
1017: AND rj.header_id IN (SELECT header_id

Line 1019: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID

1015: AND rj.completion_subinventory is null
1016: AND rj.common_routing_sequence_id is not null -- CZH.BUG2398718
1017: AND rj.header_id IN (SELECT header_id
1018: FROM wsm_split_merge_txn_interface
1019: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID
1020: and header_id = p_header_id -- WLTEnh
1021: AND process_status = WIP_CONSTANTS.RUNNING
1022: AND (transaction_type_id IN (WSMPCNST.UPDATE_ASSEMBLY,
1023: WSMPCNST.BONUS,

Line 1063: AND sj.internal_group_id = WSMPLOAD.G_GROUP_ID

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--
1063: AND sj.internal_group_id = WSMPLOAD.G_GROUP_ID
1064: AND msi.secondary_inventory_name = wdj.completion_subinventory -- CZH.BUG2398718
1065: AND msi.organization_id = wdj.organization_id -- CZH.BUG2398718
1066: )
1067: WHERE rj.process_status = WIP_CONSTANTS.RUNNING

Line 1068: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

1064: AND msi.secondary_inventory_name = wdj.completion_subinventory -- CZH.BUG2398718
1065: AND msi.organization_id = wdj.organization_id -- CZH.BUG2398718
1066: )
1067: WHERE rj.process_status = WIP_CONSTANTS.RUNNING
1068: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
1069: AND rj.header_id = p_header_id -- WLTEnh
1070: AND rj.completion_subinventory is null
1071: AND rj.header_id IN (SELECT header_id
1072: FROM wsm_split_merge_txn_interface

Line 1073: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID

1069: AND rj.header_id = p_header_id -- WLTEnh
1070: AND rj.completion_subinventory is null
1071: AND rj.header_id IN (SELECT header_id
1072: FROM wsm_split_merge_txn_interface
1073: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID
1074: and header_id = p_header_id -- WLTEnh
1075: AND process_status = WIP_CONSTANTS.RUNNING
1076: --SpUA begin
1077: AND (transaction_type_id IN ( --WSMPCNST.SPLIT,

Line 1114: AND sj.internal_group_id = WSMPLOAD.G_GROUP_ID

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
1115: AND sj.representative_flag = 'Y'
1116: AND msi.secondary_inventory_name = wdj.completion_subinventory -- CZH.BUG2398718
1117: AND msi.organization_id = wdj.organization_id -- CZH.BUG2398718
1118: )

Line 1120: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

1116: AND msi.secondary_inventory_name = wdj.completion_subinventory -- CZH.BUG2398718
1117: AND msi.organization_id = wdj.organization_id -- CZH.BUG2398718
1118: )
1119: WHERE rj.process_status = WIP_CONSTANTS.RUNNING
1120: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
1121: AND rj.completion_subinventory is null
1122: AND rj.header_id IN (SELECT header_id
1123: FROM wsm_split_merge_txn_interface
1124: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID

Line 1124: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID

1120: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
1121: AND rj.completion_subinventory is null
1122: AND rj.header_id IN (SELECT header_id
1123: FROM wsm_split_merge_txn_interface
1124: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID
1125: and header_id = p_header_id -- WLTEnh
1126: AND process_status = WIP_CONSTANTS.RUNNING
1127: AND transaction_type_id IN ( WSMPCNST.MERGE ))
1128: RETURNING rj.completion_subinventory, -- WLTEnh

Line 1304: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

1300: rj.organization_id org_id,
1301: rj.primary_item_id item_id
1302: FROM wsm_resulting_jobs_interface rj
1303: WHERE rj.process_status = WIP_CONSTANTS.RUNNING
1304: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
1305: AND rj.header_id = l_header_id
1306: AND (rj.scheduled_start_date is null
1307: or rj.scheduled_completion_date is null)
1308: AND rownum < 2;

Line 1324: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID

1320: , wrji.routing_revision
1321: /*EA WLTEnh */
1322: FROM wsm_resulting_jobs_interface wrji
1323: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
1324: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
1325: AND wrji.header_id = l_header_id
1326: AND wrji.wip_entity_name = l_we_name; --VJ: Added condition to fix bug #2315397--
1327:
1328:

Line 1361: AND RJ.GROUP_ID = WSMPLOAD.G_GROUP_ID

1357: CURSOR REV_CUR(p_header_id NUMBER) IS -- WLTEnh to fix incorrect update
1358: SELECT ROWIDTOCHAR(RJ.ROWID) "X_ROWID", RJ.ORGANIZATION_ID, RJ.HEADER_ID
1359: FROM WSM_RESULTING_JOBS_INTERFACE RJ
1360: WHERE RJ.HEADER_ID = p_header_id
1361: AND RJ.GROUP_ID = WSMPLOAD.G_GROUP_ID
1362: AND RJ.PROCESS_STATUS = WIP_CONSTANTS.RUNNING
1363: AND (RJ.BOM_REVISION IS NOT NULL OR RJ.BOM_REVISION_DATE IS NOT NULL)
1364: AND RJ.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
1365:

Line 1378: WHERE TXN.INTERNAL_GROUP_ID = WSMPLOAD.G_GROUP_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
1382: AND SJ.PROCESS_STATUS = WIP_CONSTANTS.RUNNING

Line 1380: AND TXN.header_id = WSMPLOAD.G_HEADER_ID -- XleSplits

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
1382: AND SJ.PROCESS_STATUS = WIP_CONSTANTS.RUNNING
1383: ORDER BY TXN.TRANSACTION_DATE;
1384:

Line 1393: WHERE TXN.INTERNAL_GROUP_ID = WSMPLOAD.G_GROUP_ID

1389: TXN.HEADER_ID
1390: , TXN.ORGANIZATION_ID -- 2804945
1391: FROM WSM_SPLIT_MERGE_TXN_INTERFACE TXN,
1392: WSM_RESULTING_JOBS_INTERFACE RJ
1393: WHERE TXN.INTERNAL_GROUP_ID = WSMPLOAD.G_GROUP_ID
1394: AND RJ.HEADER_ID = TXN.HEADER_ID
1395: AND TXN.header_id = WSMPLOAD.G_HEADER_ID -- XleSplits
1396: AND TXN.PROCESS_STATUS = WIP_CONSTANTS.RUNNING
1397: AND RJ.PROCESS_STATUS = WIP_CONSTANTS.RUNNING

Line 1395: AND TXN.header_id = WSMPLOAD.G_HEADER_ID -- XleSplits

1391: FROM WSM_SPLIT_MERGE_TXN_INTERFACE TXN,
1392: WSM_RESULTING_JOBS_INTERFACE RJ
1393: WHERE TXN.INTERNAL_GROUP_ID = WSMPLOAD.G_GROUP_ID
1394: AND RJ.HEADER_ID = TXN.HEADER_ID
1395: AND TXN.header_id = WSMPLOAD.G_HEADER_ID -- XleSplits
1396: AND TXN.PROCESS_STATUS = WIP_CONSTANTS.RUNNING
1397: AND RJ.PROCESS_STATUS = WIP_CONSTANTS.RUNNING
1398: ORDER BY TXN.TRANSACTION_DATE;
1399: ********************************************/

Line 1411: AND internal_group_id = WSMPLOAD.G_GROUP_ID

1407: , organization_id
1408: , rowid /*EA WLTEnh */
1409: FROM wsm_split_merge_txn_interface
1410: WHERE process_status = WIP_CONSTANTS.RUNNING
1411: AND internal_group_id = WSMPLOAD.G_GROUP_ID
1412: AND header_id = WSMPLOAD.G_HEADER_ID -- XleSplits
1413: ORDER BY TRANSACTION_DATE; --VJ: Added for NSLBJ--
1414:
1415: CURSOR C_WSJI IS

Line 1412: AND header_id = WSMPLOAD.G_HEADER_ID -- XleSplits

1408: , rowid /*EA WLTEnh */
1409: FROM wsm_split_merge_txn_interface
1410: WHERE process_status = WIP_CONSTANTS.RUNNING
1411: AND internal_group_id = WSMPLOAD.G_GROUP_ID
1412: AND header_id = WSMPLOAD.G_HEADER_ID -- XleSplits
1413: ORDER BY TRANSACTION_DATE; --VJ: Added for NSLBJ--
1414:
1415: CURSOR C_WSJI IS
1416: SELECT wsji.header_id wsji_header_id ,

Line 1432: AND wsji.internal_group_id = WSMPLOAD.G_GROUP_ID

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--
1434: AND wsji.header_id = wsmti.header_id --VJ: CodeRVW: Added for NSLBJ--
1435: AND wsmti.header_id = WSMPLOAD.G_HEADER_ID
1436: AND wsmti.process_status = WIP_CONSTANTS.RUNNING;

Line 1433: AND wsmti.internal_group_id = WSMPLOAD.G_GROUP_ID --VJ: CodeRVW: Added for NSLBJ--

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--
1434: AND wsji.header_id = wsmti.header_id --VJ: CodeRVW: Added for NSLBJ--
1435: AND wsmti.header_id = WSMPLOAD.G_HEADER_ID
1436: AND wsmti.process_status = WIP_CONSTANTS.RUNNING;
1437:

Line 1435: AND wsmti.header_id = WSMPLOAD.G_HEADER_ID

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--
1434: AND wsji.header_id = wsmti.header_id --VJ: CodeRVW: Added for NSLBJ--
1435: AND wsmti.header_id = WSMPLOAD.G_HEADER_ID
1436: AND wsmti.process_status = WIP_CONSTANTS.RUNNING;
1437:
1438: CURSOR C_WRJI IS
1439: SELECT wsmti.header_id ,

Line 1470: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID

1466: , nvl(wrji.split_has_update_assy, 0) --SpUA add
1467: FROM wsm_resulting_jobs_interface wrji,
1468: wsm_split_merge_txn_interface wsmti
1469: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
1470: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
1471: AND wsmti.internal_group_id = WSMPLOAD.G_GROUP_ID
1472: AND wrji.header_id=wsmti.header_id
1473: AND wsmti.header_id = WSMPLOAD.G_HEADER_ID
1474: AND wsmti.process_status = WIP_CONSTANTS.RUNNING;

Line 1471: AND wsmti.internal_group_id = WSMPLOAD.G_GROUP_ID

1467: FROM wsm_resulting_jobs_interface wrji,
1468: wsm_split_merge_txn_interface wsmti
1469: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
1470: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
1471: AND wsmti.internal_group_id = WSMPLOAD.G_GROUP_ID
1472: AND wrji.header_id=wsmti.header_id
1473: AND wsmti.header_id = WSMPLOAD.G_HEADER_ID
1474: AND wsmti.process_status = WIP_CONSTANTS.RUNNING;
1475: --end modification

Line 1473: AND wsmti.header_id = WSMPLOAD.G_HEADER_ID

1469: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
1470: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
1471: AND wsmti.internal_group_id = WSMPLOAD.G_GROUP_ID
1472: AND wrji.header_id=wsmti.header_id
1473: AND wsmti.header_id = WSMPLOAD.G_HEADER_ID
1474: AND wsmti.process_status = WIP_CONSTANTS.RUNNING;
1475: --end modification
1476:
1477: l_error_num NUMBER ;

Line 1526: 'WSMPVLDT.VALIDATE_RECORDS(START): WSMPLOAD.G_HEADER_ID='||WSMPLOAD.G_HEADER_ID);

1522: p_err_num := 0;
1523:
1524: IF (l_debug = 'Y') THEN
1525: FND_FILE.PUT_LINE(FND_FILE.LOG,
1526: 'WSMPVLDT.VALIDATE_RECORDS(START): WSMPLOAD.G_HEADER_ID='||WSMPLOAD.G_HEADER_ID);
1527: fnd_file.put_line(fnd_file.log, 'WSMPVLDT.VALIDATE_RECORDS:Start Time:'
1528: ||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1529:
1530: END IF;

Line 1926: and txn.internal_group_id = WSMPLOAD.G_GROUP_ID;

1922:
1923: select null into l_dummy
1924: from wsm_split_merge_txn_interface txn
1925: where txn.header_id = l_cur_wsji_rec.wsji_header_id
1926: and txn.internal_group_id = WSMPLOAD.G_GROUP_ID;
1927:
1928: Exception
1929:
1930: When NO_DATA_FOUND Then

Line 1973: AND internal_group_id = WSMPLOAD.G_GROUP_ID;

1969:
1970: SELECT organization_id into l_cur_wsji_rec.organization_id
1971: FROM wsm_split_merge_txn_interface
1972: WHERE header_id = l_cur_wsji_rec.wsji_header_id
1973: AND internal_group_id = WSMPLOAD.G_GROUP_ID;
1974:
1975: Exception
1976:
1977: When NO_DATA_FOUND Then

Line 2020: and txn.internal_group_id = WSMPLOAD.G_GROUP_ID;

2016: select null into l_dummy
2017: from wsm_split_merge_txn_interface txn
2018: where txn.header_id = l_cur_wsji_rec.wsji_header_id
2019: and txn.organization_id = l_cur_wsji_rec.organization_id
2020: and txn.internal_group_id = WSMPLOAD.G_GROUP_ID;
2021:
2022: Exception
2023:
2024: When NO_DATA_FOUND Then

Line 3469: AND internal_group_id = WSMPLOAD.G_GROUP_ID)

3465: SET organization_id = (SELECT organization_id
3466: FROM wsm_split_merge_txn_interface
3467: WHERE header_id = wrji.header_id
3468: AND process_status = WIP_CONSTANTS.RUNNING
3469: AND internal_group_id = WSMPLOAD.G_GROUP_ID)
3470: WHERE wrji.header_id = l_header_id
3471: AND wrji.organization_id IS NULL;
3472:
3473: IF (SQL%ROWCOUNT > 0) THEN

Line 3506: AND txn.internal_group_id = WSMPLOAD.G_GROUP_ID);

3502: from wsm_split_merge_txn_interface txn
3503: where txn.header_id = wrji.header_id
3504: and txn.organization_id = wrji.organization_id
3505: and txn.process_status = WIP_CONSTANTS.RUNNING
3506: AND txn.internal_group_id = WSMPLOAD.G_GROUP_ID);
3507:
3508:
3509: IF (SQL%ROWCOUNT > 0) THEN
3510: set_wrji_error(); -- WLTEnh

Line 3565: and rj.internal_group_id = WSMPLOAD.G_GROUP_ID

3561: update wsm_resulting_jobs_interface rj
3562: set scheduled_start_date = l_scheduled_start_date,
3563: scheduled_completion_date = l_scheduled_completion_date
3564: where rj.process_status = WIP_CONSTANTS.RUNNING
3565: and rj.internal_group_id = WSMPLOAD.G_GROUP_ID
3566: and rj.header_id = l_header_id;
3567:
3568: IF (SQL%ROWCOUNT > 0) THEN
3569: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

Line 3599: --Moved this call from WSMPLOAD.VALIDATE_AND_LOAD to here--

3595: --VJ: End move following code to start of validations to fix bug #2315397--
3596:
3597: --Start fix for bug #2345536, Moved this call to first populate columns--
3598: --VJ: Start Additions for NSLBJ--
3599: --Moved this call from WSMPLOAD.VALIDATE_AND_LOAD to here--
3600: /*-----------------------------------------------------------------+
3601: | Default values and populate some column values |
3602: +-----------------------------------------------------------------*/
3603: l_stmt_num := 72;

Line 3635: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID

3631: l_completion_subinventory,
3632: l_completion_locator_id
3633: FROM wsm_resulting_jobs_interface wrji
3634: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
3635: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
3636: AND wrji.header_id = l_header_id
3637: AND wrji.wip_entity_name = l_we_name;
3638:
3639: IF (l_debug = 'Y') THEN

Line 4245: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID

4241: l_completion_subinventory,
4242: l_completion_locator_id
4243: FROM wsm_resulting_jobs_interface wrji
4244: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
4245: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
4246: AND wrji.header_id = l_header_id
4247: AND wrji.wip_entity_name = l_we_name;
4248:
4249: IF (l_debug = 'Y') THEN

Line 4359: WHERE wrji.internal_group_id = WSMPLOAD.G_GROUP_ID

4355: l_stmt_num := 99;
4356:
4357: UPDATE wsm_resulting_jobs_interface wrji
4358: SET wrji.scheduled_completion_date = l_sch_completion_date
4359: WHERE wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
4360: AND wrji.header_id = l_header_id;
4361:
4362: IF (SQL%ROWCOUNT > 0) THEN
4363: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

Line 4404: WHERE wrji.internal_group_id = WSMPLOAD.G_GROUP_ID

4400: l_stmt_num := 101;
4401:
4402: UPDATE wsm_resulting_jobs_interface wrji
4403: SET wrji.scheduled_start_date = l_sch_start_date
4404: WHERE wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
4405: AND wrji.header_id = l_header_id;
4406:
4407: IF (SQL%ROWCOUNT > 0) THEN
4408: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

Line 4557: ||'; WSMPLOAD.G_HEADER_ID='||WSMPLOAD.G_HEADER_ID);

4553: If l_debug = 'Y' Then
4554: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
4555: ||l_stmt_num
4556: ||'): l_header_id='||l_header_id
4557: ||'; WSMPLOAD.G_HEADER_ID='||WSMPLOAD.G_HEADER_ID);
4558: End If;
4559: l_stmt_num := 106;
4560:
4561: UPDATE wsm_resulting_jobs_interface wrji

Line 5081: and wrji.internal_group_id = WSMPLOAD.G_GROUP_ID

5077: bom_reference_id = NULL
5078: WHERE wrji.header_id = l_header_id
5079: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
5080: and wrji.process_status = WIP_CONSTANTS.RUNNING
5081: and wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
5082: and (wrji.routing_reference_id IS NOT NULL
5083: OR wrji.bom_reference_id IS NOT NULL);
5084:
5085: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

Line 5633: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

5629: AND msi.secondary_inventory_name = bor.completion_subinventory -- CZH.BUG2398718
5630: AND msi.organization_id = bor.organization_id -- CZH.BUG2398718
5631: )
5632: WHERE rj.process_status = WIP_CONSTANTS.RUNNING
5633: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
5634: AND rj.completion_subinventory is null
5635: AND rj.common_routing_sequence_id is not null -- CZH.BUG2398718
5636: AND rj.rowid = l_wrji_rowid --SpUA add
5637: AND rj.header_id IN (SELECT header_id

Line 5639: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID

5635: AND rj.common_routing_sequence_id is not null -- CZH.BUG2398718
5636: AND rj.rowid = l_wrji_rowid --SpUA add
5637: AND rj.header_id IN (SELECT header_id
5638: FROM wsm_split_merge_txn_interface
5639: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID
5640: AND process_status = WIP_CONSTANTS.RUNNING
5641: AND (transaction_type_id IN (WSMPCNST.UPDATE_ASSEMBLY,
5642: WSMPCNST.BONUS,
5643: WSMPCNST.UPDATE_ROUTING)

Line 6090: and wrji.internal_group_id = WSMPLOAD.G_GROUP_ID

6086: starting_operation_code = l_bso_stdop_code
6087: WHERE wrji.header_id = l_header_id
6088: and wrji.rowid = l_wrji_rowid --SpUA add
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

Line 6161: and wrji.internal_group_id = WSMPLOAD.G_GROUP_ID

6157: WHERE wrji.header_id = l_header_id
6158: AND wrji.rowid = l_wrji_rowid --SpUA add
6159: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
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

Line 7312: and wrji.internal_group_id = WSMPLOAD.G_GROUP_ID;

7308: starting_operation_code = l_start_op_code
7309: WHERE wrji.header_id = l_header_id
7310: and wrji.rowid = l_wrji_rowid --SpUA add
7311: and wrji.process_status = WIP_CONSTANTS.RUNNING
7312: and wrji.internal_group_id = WSMPLOAD.G_GROUP_ID;
7313:
7314:
7315: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
7316: FND_MESSAGE.SET_TOKEN('FLD_NAME',

Line 7782: and wrji.internal_group_id = WSMPLOAD.G_GROUP_ID;

7778: UPDATE wsm_resulting_jobs_interface wrji
7779: SET starting_operation_seq_num = l_bos_op_seq_num
7780: WHERE wrji.header_id = l_header_id
7781: and wrji.process_status = WIP_CONSTANTS.RUNNING
7782: and wrji.internal_group_id = WSMPLOAD.G_GROUP_ID;
7783: -- EA: BUG 2686319
7784:
7785: IF (l_debug = 'Y') THEN
7786: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num

Line 9265: Where internal_group_id = WSMPLOAD.G_GROUP_ID

9261: l_stmt_num := 266;
9262:
9263: select 1 into l_errored_rows
9264: from wsm_split_merge_txn_interface
9265: Where internal_group_id = WSMPLOAD.G_GROUP_ID
9266: and header_id = WSMPLOAD.G_HEADER_ID
9267: and process_status = WIP_CONSTANTS.ERROR;
9268:
9269: Exception

Line 9266: and header_id = WSMPLOAD.G_HEADER_ID

9262:
9263: select 1 into l_errored_rows
9264: from wsm_split_merge_txn_interface
9265: Where internal_group_id = WSMPLOAD.G_GROUP_ID
9266: and header_id = WSMPLOAD.G_HEADER_ID
9267: and process_status = WIP_CONSTANTS.ERROR;
9268:
9269: Exception
9270: When no_data_found Then

Line 9279: p_err_msg := 'WSMPVLDT.VALIDATE_RECORDS: Passed validation for Header Id: '||WSMPLOAD.G_HEADER_ID;

9275:
9276: End;
9277:
9278: If (l_errored_rows = 0) Then
9279: p_err_msg := 'WSMPVLDT.VALIDATE_RECORDS: Passed validation for Header Id: '||WSMPLOAD.G_HEADER_ID;
9280: IF (l_debug = 'Y') THEN
9281: FND_FILE.PUT_LINE(FND_FILE.LOG, p_err_msg);
9282: END IF;
9283: Else

Line 9284: p_err_msg := ('Failed validation for Header Id '||WSMPLOAD.G_HEADER_ID);

9280: IF (l_debug = 'Y') THEN
9281: FND_FILE.PUT_LINE(FND_FILE.LOG, p_err_msg);
9282: END IF;
9283: Else
9284: p_err_msg := ('Failed validation for Header Id '||WSMPLOAD.G_HEADER_ID);
9285: p_err_num := l_errored_rows;
9286: FND_FILE.PUT_LINE(FND_FILE.LOG, p_err_msg);
9287:
9288: End If;