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 STANDARD

Line 107: -- AND rj.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

103: -- WSMPCNST.UPDATE_ROUTING)
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:

Line 125: AND rj.job_type = WIP_CONSTANTS.STANDARD

121: FROM wsm_resulting_jobs_interface rj,
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:

Line 156: AND rj.job_type = WIP_CONSTANTS.NONSTANDARD

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

Line 258: | For Standard Lot Based Jobs : |

254: l_wrji_rowid ROWID; --SpUA
255:
256: BEGIN
257: /*-----------------------------------------------------------------+
258: | For Standard Lot Based Jobs : |
259: | Default class_code in wsm_resulting_jobs_interface table. If |
260: | transaction type is bonus, then default the class_code as defined|
261: | in wip_parameters, otherwise, copying over the class_code from |
262: | parent lots. |

Line 465: and rj.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

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
469: WHERE txn2.header_id = rj.header_id

Line 490: | For Non-Standard Lot Based Jobs : |

486: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
487: END IF;
488:
489: /*-------------------------------------------------------------------+
490: | For Non-Standard Lot Based Jobs : |
491: | If class_code in wsm_resulting_jobs_interface table is NULL, error.|
492: +-------------------------------------------------------------------*/
493:
494: --VJ: Start Additions for NSLBJ--

Line 810: SET wrji.net_quantity = decode ( c_net_quantity_rec.job_type, WIP_CONSTANTS.STANDARD,wrji.start_quantity

806: IF ( c_net_quantity_rec.transaction_type_id = WSMPCNST.BONUS) THEN
807: l_stmt_num := 18;
808: UPDATE wsm_resulting_jobs_interface wrji
809: /* ST : fix for bug 3766859 : added decode : in case of non-std bonus default to 0 */
810: SET wrji.net_quantity = decode ( c_net_quantity_rec.job_type, WIP_CONSTANTS.STANDARD,wrji.start_quantity
811: ,0)
812: WHERE wrji.header_id = c_net_quantity_rec.header_id
813: AND wrji.net_quantity is NULL ;
814:

Line 1005: WIP_CONSTANTS.STANDARD, rj.primary_item_id,

1001: WHERE bor.common_routing_sequence_id = rj.common_routing_sequence_id
1002: AND bor.organization_id = rj.organization_id
1003: --VJ: Start Changes for NSLBJ--
1004: AND bor.assembly_item_id = decode(rj.job_type,
1005: WIP_CONSTANTS.STANDARD, rj.primary_item_id,
1006: WIP_CONSTANTS.NONSTANDARD, rj.routing_reference_id,
1007: rj.primary_item_id)
1008: AND msi.secondary_inventory_name = bor.completion_subinventory -- CZH.BUG2398718
1009: AND msi.organization_id = bor.organization_id -- CZH.BUG2398718

Line 1006: WIP_CONSTANTS.NONSTANDARD, rj.routing_reference_id,

1002: AND bor.organization_id = rj.organization_id
1003: --VJ: Start Changes for NSLBJ--
1004: AND bor.assembly_item_id = decode(rj.job_type,
1005: WIP_CONSTANTS.STANDARD, rj.primary_item_id,
1006: WIP_CONSTANTS.NONSTANDARD, rj.routing_reference_id,
1007: rj.primary_item_id)
1008: AND msi.secondary_inventory_name = bor.completion_subinventory -- CZH.BUG2398718
1009: AND msi.organization_id = bor.organization_id -- CZH.BUG2398718
1010: )

Line 1364: AND RJ.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--

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:
1366: --VJ: End Changes for NSLBJ--
1367:
1368: -- Start : Comments to fix bug #3453139 --

Line 2180: | Verify wip_entity_id is a standard open WSM job. |

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:
2183: /*----------------------------------------------------------------------+
2184: | IF WIP_ENTITY_ID exists, default the WIP ENTITY NAME. |

Line 2203: and dis.job_type in (WIP_CONSTANTS.STANDARD,

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
2203: and dis.job_type in (WIP_CONSTANTS.STANDARD,
2204: WIP_CONSTANTS.NONSTANDARD) --VJ: Added for NSLBJ--
2205: and we.entity_type = 5;
2206:
2207: IF (SQL%ROWCOUNT > 0) THEN

Line 2204: WIP_CONSTANTS.NONSTANDARD) --VJ: Added for NSLBJ--

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
2203: and dis.job_type in (WIP_CONSTANTS.STANDARD,
2204: WIP_CONSTANTS.NONSTANDARD) --VJ: Added for NSLBJ--
2205: and we.entity_type = 5;
2206:
2207: IF (SQL%ROWCOUNT > 0) THEN
2208: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

Line 2275: and dis.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD)

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)
2273: and dis.organization_id = we.organization_id
2274: and dis.status_type = 3
2275: and dis.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD)
2276: and we.entity_type = 5;
2277:
2278: IF (SQL%ROWCOUNT > 0) THEN
2279: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

Line 2882: and l_wsji_job_type = WIP_CONSTANTS.STANDARD) -- Bug#2679705

2878: and NOT EXISTS (select 1
2879: from bom_operational_routings bor
2880: where bor.routing_sequence_id = l_cur_wsji_rec.routing_seq_id
2881: and ((bor.assembly_item_id = l_cur_wsji_rec.primary_item_id
2882: and l_wsji_job_type = WIP_CONSTANTS.STANDARD) -- Bug#2679705
2883: OR
2884: (bor.assembly_item_id = l_wsji_routing_reference_id
2885: and l_wsji_job_type = WIP_CONSTANTS.NONSTANDARD) -- Bug#2679705
2886: )

Line 2885: and l_wsji_job_type = WIP_CONSTANTS.NONSTANDARD) -- Bug#2679705

2881: and ((bor.assembly_item_id = l_cur_wsji_rec.primary_item_id
2882: and l_wsji_job_type = WIP_CONSTANTS.STANDARD) -- Bug#2679705
2883: OR
2884: (bor.assembly_item_id = l_wsji_routing_reference_id
2885: and l_wsji_job_type = WIP_CONSTANTS.NONSTANDARD) -- Bug#2679705
2886: )
2887: and bor.organization_id = l_cur_wsji_rec.organization_id
2888: and bor.cfm_routing_flag=3);
2889:

Line 2918: | Validate that the starting operation is a standard op when txn_type |

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

Line 2930: SELECT bso.standard_operation_id

2926: BEGIN
2927:
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

Line 2934: bom_standard_operations bso

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'
2937: AND NVL(wsji.wip_entity_id, l_cur_wsji_rec.wip_entity_id) = wo.wip_entity_id
2938: AND wsji.operation_seq_num = wo.operation_seq_num

Line 2939: AND wo.standard_operation_id = bso.standard_operation_id;

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'
2937: AND NVL(wsji.wip_entity_id, l_cur_wsji_rec.wip_entity_id) = wo.wip_entity_id
2938: AND wsji.operation_seq_num = wo.operation_seq_num
2939: AND wo.standard_operation_id = bso.standard_operation_id;
2940:
2941: EXCEPTION
2942:
2943: when NO_DATA_FOUND then

Line 2972: ||l_stmt_num||') Standard Operation Id ' ||

2968: when too_many_rows Then
2969:
2970: IF (l_debug = 'Y') THEN
2971: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
2972: ||l_stmt_num||') Standard Operation Id ' ||
2973: l_merge_std_op_id || ' Repeats. Valid for Merge;' );
2974: END IF;
2975: null;
2976:

Line 3297: AND wrji.job_type NOT IN (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD); --Fixed bug #2341915

3293: , wrji.process_status = WIP_CONSTANTS.ERROR -- WLTEnh
3294: WHERE wrji.header_id = l_header_id
3295: AND l_txn_type = WSMPCNST.BONUS --VJ: CodeRVW: Added for NSLBJ--
3296: AND wrji.job_type IS NOT NULL
3297: AND wrji.job_type NOT IN (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD); --Fixed bug #2341915
3298:
3299: IF (SQL%ROWCOUNT > 0) THEN
3300:
3301: set_wrji_error(); -- WLTEnh

Line 3324: SET wrji.job_type = WIP_CONSTANTS.STANDARD

3320:
3321: l_stmt_num := 65;
3322: --VJ: Start additions to fix bug #2341915--
3323: update wsm_resulting_jobs_interface wrji
3324: SET wrji.job_type = WIP_CONSTANTS.STANDARD
3325: WHERE wrji.header_id = l_header_id
3326: AND l_txn_type = WSMPCNST.BONUS
3327: AND wrji.job_type IS NULL;
3328:

Line 3652: IF (l_job_type = WIP_CONSTANTS.NONSTANDARD) THEN --End beforel_stmt_num := 94;--

3648: --VJ: End Additions to fix bug #2315397--
3649:
3650: --VJ: Start Additions for NSLBJ--
3651:
3652: IF (l_job_type = WIP_CONSTANTS.NONSTANDARD) THEN --End beforel_stmt_num := 94;--
3653:
3654: l_stmt_num := 74;
3655: --VJ: 0313: Start Additions for NSLBJ--
3656: IF (l_wrji_alt_rtg_desig = '-1') THEN -- it is NULL

Line 4198: END IF; --(l_job_type = WIP_CONSTANTS.NONSTANDARD) Begin @ _stmt_num := 166

4194: END IF;
4195:
4196: END IF; --IF (l_txn_type IN (WSMPCNST.BONUS, WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING))
4197:
4198: END IF; --(l_job_type = WIP_CONSTANTS.NONSTANDARD) Begin @ _stmt_num := 166
4199:
4200: -- BA: CZH.BUG2398718
4201: IF (l_job_type = WIP_CONSTANTS.STANDARD) THEN
4202: -- We should have the same code for Standard LBJ !!!!!!!!!

Line 4201: IF (l_job_type = WIP_CONSTANTS.STANDARD) THEN

4197:
4198: END IF; --(l_job_type = WIP_CONSTANTS.NONSTANDARD) Begin @ _stmt_num := 166
4199:
4200: -- BA: CZH.BUG2398718
4201: IF (l_job_type = WIP_CONSTANTS.STANDARD) THEN
4202: -- We should have the same code for Standard LBJ !!!!!!!!!
4203: NULL;
4204: END IF; -- (l_job_type = WIP_CONSTANTS.STANDARD)
4205: -- EA: CZH.BUG2398718

Line 4202: -- We should have the same code for Standard LBJ !!!!!!!!!

4198: END IF; --(l_job_type = WIP_CONSTANTS.NONSTANDARD) Begin @ _stmt_num := 166
4199:
4200: -- BA: CZH.BUG2398718
4201: IF (l_job_type = WIP_CONSTANTS.STANDARD) THEN
4202: -- We should have the same code for Standard LBJ !!!!!!!!!
4203: NULL;
4204: END IF; -- (l_job_type = WIP_CONSTANTS.STANDARD)
4205: -- EA: CZH.BUG2398718
4206:

Line 4204: END IF; -- (l_job_type = WIP_CONSTANTS.STANDARD)

4200: -- BA: CZH.BUG2398718
4201: IF (l_job_type = WIP_CONSTANTS.STANDARD) THEN
4202: -- We should have the same code for Standard LBJ !!!!!!!!!
4203: NULL;
4204: END IF; -- (l_job_type = WIP_CONSTANTS.STANDARD)
4205: -- EA: CZH.BUG2398718
4206:
4207: --VJ: End Additions for NSLBJ--
4208:

Line 5069: | for a STANDARD Job |

5065:
5066: --VJ: 0313: Start Additions for NSLBJ--
5067: /*---------------------------------------------------------+
5068: | routing_reference_id and bom_reference_id should be NULL |
5069: | for a STANDARD Job |
5070: +---------------------------------------------------------*/
5071:
5072: l_stmt_num := 119;
5073: IF (l_job_type = WIP_CONSTANTS.STANDARD) THEN

Line 5073: IF (l_job_type = WIP_CONSTANTS.STANDARD) THEN

5069: | for a STANDARD Job |
5070: +---------------------------------------------------------*/
5071:
5072: l_stmt_num := 119;
5073: IF (l_job_type = WIP_CONSTANTS.STANDARD) THEN
5074: l_stmt_num := 120;
5075: UPDATE wsm_resulting_jobs_interface wrji
5076: SET routing_reference_id = NULL,
5077: bom_reference_id = NULL

Line 5079: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

5075: UPDATE wsm_resulting_jobs_interface wrji
5076: SET routing_reference_id = NULL,
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);

Line 5245: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

5241: l_stmt_num := 126;
5242: UPDATE wsm_resulting_jobs_interface wrji
5243: SET alternate_routing_designator=l_alt_rtg_desig
5244: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
5245: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
5246: AND wrji.header_id=l_header_id
5247: AND wrji.rowid = l_wrji_rowid;
5248:
5249: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

Line 5278: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

5274: l_stmt_num := 127;
5275: UPDATE wsm_resulting_jobs_interface wrji
5276: SET alternate_routing_designator=NULL
5277: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
5278: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
5279: AND wrji.header_id=l_header_id
5280: AND wrji.rowid = l_wrji_rowid;
5281:
5282: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

Line 5315: WIP_CONSTANTS.STANDARD, wrji.primary_item_id,

5311: SET common_routing_sequence_id=
5312: (select bor.common_routing_sequence_id
5313: from bom_operational_routings bor
5314: where bor.assembly_item_id = decode(wrji.job_type,
5315: WIP_CONSTANTS.STANDARD, wrji.primary_item_id,
5316: wrji.routing_reference_id) -- Fix for bug #2369822
5317: and bor.alternate_routing_designator is null
5318: and bor.organization_id = l_organization_id --bugfix 1922146: added orgn_id condn
5319: and bor.cfm_routing_flag = 3)

Line 5349: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

5345: UPDATE wsm_resulting_jobs_interface wrji
5346: SET wrji.error_message = l_fnd_generic_err_msg
5347: WHERE wrji.header_id = l_header_id
5348: AND wrji.rowid = l_wrji_rowid --SpUA add
5349: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
5350: AND NOT EXISTS (select 1
5351: from bom_operational_routings bor
5352: where bor.routing_sequence_id = wrji.common_routing_sequence_id
5353: and bor.alternate_routing_designator = wrji.alternate_routing_designator

Line 5387: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

5383: UPDATE wsm_resulting_jobs_interface wrji
5384: SET wrji.error_message = l_fnd_generic_err_msg
5385: WHERE wrji.header_id = l_header_id
5386: AND wrji.rowid = l_wrji_rowid --SpUA add
5387: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
5388: AND NOT EXISTS (select 1
5389: from bom_operational_routings bor
5390: where bor.routing_sequence_id = wrji.common_routing_sequence_id
5391: --and bor.assembly_item_id=wrji.primary_item_id --bugfix 2077930

Line 5407: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--

5403: and bor.organization_id = l_organization_id --bugfix 1922146: added orgn_id condn
5404: and bor.cfm_routing_flag=3)
5405: WHERE wrji.header_id = l_header_id
5406: AND wrji.rowid = l_wrji_rowid --SpUA add
5407: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
5408:
5409: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5410: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');
5411: l_fnd_err_msg := FND_MESSAGE.GET;

Line 5457: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

5453: UPDATE wsm_resulting_jobs_interface wrji
5454: SET wrji.error_message = l_fnd_generic_err_msg
5455: WHERE wrji.header_id = l_header_id
5456: AND wrji.rowid = l_wrji_rowid --SpUA add
5457: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
5458: AND NOT EXISTS (select 1
5459: from bom_operational_routings bor
5460: where bor.alternate_routing_designator = wrji.alternate_routing_designator
5461: and bor.assembly_item_id = wrji.primary_item_id

Line 5477: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--

5473: and bor.organization_id = l_organization_id --bugfix 1922146: added orgn_id condn
5474: and bor.cfm_routing_flag=3)
5475: WHERE wrji.header_id = l_header_id
5476: AND wrji.rowid = l_wrji_rowid --SpUA add
5477: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
5478:
5479: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5480: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5481: l_fnd_err_msg := FND_MESSAGE.GET;

Line 5626: WIP_CONSTANTS.STANDARD, rj.primary_item_id,

5622: mtl_secondary_inventories msi -- CZH.BUG2398718
5623: WHERE bor.common_routing_sequence_id = rj.common_routing_sequence_id
5624: AND bor.organization_id = rj.organization_id
5625: AND bor.assembly_item_id = decode(rj.job_type,
5626: WIP_CONSTANTS.STANDARD, rj.primary_item_id,
5627: WIP_CONSTANTS.NONSTANDARD, rj.routing_reference_id,
5628: rj.primary_item_id)
5629: AND msi.secondary_inventory_name = bor.completion_subinventory -- CZH.BUG2398718
5630: AND msi.organization_id = bor.organization_id -- CZH.BUG2398718

Line 5627: WIP_CONSTANTS.NONSTANDARD, rj.routing_reference_id,

5623: WHERE bor.common_routing_sequence_id = rj.common_routing_sequence_id
5624: AND bor.organization_id = rj.organization_id
5625: AND bor.assembly_item_id = decode(rj.job_type,
5626: WIP_CONSTANTS.STANDARD, rj.primary_item_id,
5627: WIP_CONSTANTS.NONSTANDARD, rj.routing_reference_id,
5628: rj.primary_item_id)
5629: AND msi.secondary_inventory_name = bor.completion_subinventory -- CZH.BUG2398718
5630: AND msi.organization_id = bor.organization_id -- CZH.BUG2398718
5631: )

Line 5698: IF (l_job_type = WIP_CONSTANTS.STANDARD) THEN

5694: and wsji.header_id=l_header_id;
5695:
5696: ELSE -- updAsm, updRtg, bonus,
5697: /* ST bug fix 3327459 also jobs in split with change of assembly */
5698: IF (l_job_type = WIP_CONSTANTS.STANDARD) THEN
5699: l_item_id := l_primary_item_id;
5700: ELSIF (l_job_type = WIP_CONSTANTS.NONSTANDARD) THEN
5701: l_item_id := l_routing_reference_id;
5702: END IF;

Line 5700: ELSIF (l_job_type = WIP_CONSTANTS.NONSTANDARD) THEN

5696: ELSE -- updAsm, updRtg, bonus,
5697: /* ST bug fix 3327459 also jobs in split with change of assembly */
5698: IF (l_job_type = WIP_CONSTANTS.STANDARD) THEN
5699: l_item_id := l_primary_item_id;
5700: ELSIF (l_job_type = WIP_CONSTANTS.NONSTANDARD) THEN
5701: l_item_id := l_routing_reference_id;
5702: END IF;
5703:
5704: If (l_debug = 'Y') Then

Line 5800: l_bso_stdop_code BOM_STANDARD_OPERATIONS.OPERATION_CODE%TYPE default NULL; -- BBK NSOWLT

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

Line 5938: nvl(bos.standard_operation_id, -9999), -- BBK: NSO:WLT

5934: l_stmt_num := 144;
5935: begin
5936: SELECT bos.operation_sequence_id,
5937: bos.operation_seq_num, -- BBK: NSO:WLT
5938: nvl(bos.standard_operation_id, -9999), -- BBK: NSO:WLT
5939: sj.intraoperation_step,
5940: nvl(rj.common_routing_sequence_id,-1) --VJ: Added for NSLBJ--
5941: --Combined with sql at stmt 345--
5942: INTO l_op_seq_id,

Line 5957: AND nvl(wo.standard_operation_id, -9999) = nvl(bos.standard_operation_id, -9999) -- BBK:NSOWLT

5953: AND sj.header_id = rj.header_id
5954: AND sj.operation_seq_num = wo.operation_seq_num
5955: AND sj.wip_entity_id = wo.wip_entity_id
5956: AND rj.common_routing_sequence_id = bos.routing_sequence_id
5957: AND nvl(wo.standard_operation_id, -9999) = nvl(bos.standard_operation_id, -9999) -- BBK:NSOWLT
5958: -- BC: CZH.I_OED-1, should get routing_revision date
5959: --AND bos.effectivity_date <= SYSDATE
5960: --AND nvl(bos.disable_date, SYSDATE+2) > SYSDATE ;
5961: ---HH24MISS --AND bos.effectivity_date <= l_rtg_rev_date

Line 5997: From BOM_STANDARD_OPERATIONS

5993: If (l_bos_stdop_id <> -9999) Then --Fix for bug #2358941--
5994:
5995: l_stmt_num := 147;
5996: Select operation_code into l_bso_stdop_code
5997: From BOM_STANDARD_OPERATIONS
5998: Where standard_operation_id = l_bos_stdop_id;
5999:
6000: End If;
6001:

Line 5998: Where standard_operation_id = l_bos_stdop_id;

5994:
5995: l_stmt_num := 147;
5996: Select operation_code into l_bso_stdop_code
5997: From BOM_STANDARD_OPERATIONS
5998: Where standard_operation_id = l_bos_stdop_id;
5999:
6000: End If;
6001:
6002: -- Start : Fix for bug #3196985 --

Line 6159: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

6155: SET starting_operation_seq_num = NULL,
6156: starting_operation_code = NULL
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

Line 6249: AND wrji.job_type = WIP_CONSTANTS.STANDARD

6245: l_stmt_num := 155;
6246: UPDATE wsm_resulting_jobs_interface wrji
6247: SET wrji.error_message = l_fnd_generic_err_msg
6248: WHERE wrji.header_id = l_header_id
6249: AND wrji.job_type = WIP_CONSTANTS.STANDARD
6250: AND wrji.rowid = l_wrji_rowid;
6251: --VJ: End Additions for NSLBJ--
6252:
6253: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

Line 6284: AND wrji.job_type = WIP_CONSTANTS.STANDARD

6280: l_stmt_num := 156;
6281: UPDATE wsm_resulting_jobs_interface wrji
6282: SET wrji.error_message = l_fnd_generic_err_msg
6283: WHERE wrji.header_id = l_header_id
6284: AND wrji.job_type = WIP_CONSTANTS.STANDARD
6285: AND wrji.rowid = l_wrji_rowid;
6286: --VJ: End Additions for NSLBJ--
6287:
6288: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

Line 6314: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

6310: UPDATE wsm_resulting_jobs_interface wrji
6311: SET common_bom_sequence_id=l_bom_seq_id
6312: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
6313: AND wrji.header_id=l_header_id
6314: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6315: AND wrji.rowid = l_wrji_rowid;
6316:
6317: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6318: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');

Line 6345: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

6341: UPDATE wsm_resulting_jobs_interface wrji
6342: SET alternate_bom_designator=l_alt_bom_desig
6343: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
6344: AND wrji.header_id=l_header_id
6345: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6346: AND wrji.rowid = l_wrji_rowid;
6347:
6348: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6349: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');

Line 6378: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

6374: UPDATE wsm_resulting_jobs_interface wrji
6375: SET alternate_bom_designator=NULL
6376: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
6377: AND wrji.header_id=l_header_id
6378: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6379: AND wrji.rowid = l_wrji_rowid;
6380:
6381: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6382: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');

Line 6436: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--

6432: or (bom.assembly_type = 2)))
6433: -- and bom.assembly_type = 1) --endfix
6434: WHERE wrji.header_id = l_header_id
6435: AND wrji.rowid = l_wrji_rowid --SpUA add
6436: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
6437:
6438: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6439: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6440: l_fnd_err_msg := FND_MESSAGE.GET;

Line 6471: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

6467: UPDATE wsm_resulting_jobs_interface wrji
6468: SET wrji.error_message = l_fnd_generic_err_msg
6469: WHERE wrji.header_id = l_header_id
6470: AND wrji.rowid = l_wrji_rowid --SpUA add
6471: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6472: AND NOT EXISTS (select 1
6473: from bom_bill_of_materials bom,
6474: mtl_system_items msi --bugfix 1828859
6475: where bom.bill_sequence_id = wrji.common_bom_sequence_id

Line 6513: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

6509: UPDATE wsm_resulting_jobs_interface wrji
6510: SET wrji.error_message = l_fnd_generic_err_msg
6511: WHERE wrji.header_id = l_header_id
6512: AND wrji.rowid = l_wrji_rowid --SpUA add
6513: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6514: AND NOT EXISTS (select 1
6515: from bom_bill_of_materials bom,
6516: mtl_system_items msi --bugfix 1828859
6517: where bom.bill_sequence_id = wrji.common_bom_sequence_id

Line 6543: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--

6539: or (bom.assembly_type = 2)))
6540: -- and bom.assembly_type=1) --endfix
6541: WHERE wrji.header_id = l_header_id
6542: AND wrji.rowid = l_wrji_rowid --SpUA add
6543: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
6544:
6545: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6546: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6547: l_fnd_err_msg := FND_MESSAGE.GET;

Line 6592: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

6588: UPDATE wsm_resulting_jobs_interface wrji
6589: SET wrji.error_message = l_fnd_generic_err_msg
6590: WHERE wrji.header_id = l_header_id
6591: AND wrji.rowid = l_wrji_rowid --SpUA add
6592: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6593: and NOT EXISTS (select 1
6594: from bom_bill_of_materials bom,
6595: mtl_system_items msi --bugfix 1828859
6596: where bom.alternate_bom_designator = wrji.alternate_bom_designator

Line 6622: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--

6618: or (bom.assembly_type = 2)))
6619: -- and bom.assembly_type=1) --endfix
6620: WHERE wrji.header_id = l_header_id
6621: AND wrji.rowid = l_wrji_rowid
6622: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
6623:
6624: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6625: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6626: l_fnd_err_msg := FND_MESSAGE.GET;

Line 6733: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

6729:
6730: UPDATE wsm_resulting_jobs_interface wrji
6731: SET wrji.error_message = l_fnd_generic_err_msg
6732: WHERE wrji.header_id = l_header_id
6733: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6734: and not exists (select null
6735: from bom_routing_alternates_v bor
6736: where bor.assembly_item_id = wrji.primary_item_id
6737: and bor.organization_id = wrji.organization_id

Line 6778: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

6774: --Changed the sql since org_id has been added to WRJI now--
6775: UPDATE wsm_resulting_jobs_interface wrji
6776: SET wrji.error_message = l_fnd_generic_err_msg
6777: WHERE wrji.header_id = l_header_id
6778: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6779: and not exists
6780: (select null
6781: from bom_bill_alternates_v bba,
6782: mtl_system_items msi --bugfix 1828859

Line 6830: IF (c_bom_rtg_revision_rec.job_type = WIP_CONSTANTS.STANDARD) THEN

6826: FOR c_bom_rtg_revision_rec IN bom_rtg_revision(l_header_id, l_we_name) LOOP
6827: --VJ: Added param to fix bug #2315397--
6828: l_stmt_num := 172;
6829: -- Get the Routing Revision and Routing Revision Date first --
6830: IF (c_bom_rtg_revision_rec.job_type = WIP_CONSTANTS.STANDARD) THEN
6831: l_temp := c_bom_rtg_revision_rec.item_id;
6832: ELSIF (c_bom_rtg_revision_rec.job_type = WIP_CONSTANTS.NONSTANDARD) THEN
6833: l_temp := c_bom_rtg_revision_rec.rtg_ref_id;
6834: END IF;

Line 6832: ELSIF (c_bom_rtg_revision_rec.job_type = WIP_CONSTANTS.NONSTANDARD) THEN

6828: l_stmt_num := 172;
6829: -- Get the Routing Revision and Routing Revision Date first --
6830: IF (c_bom_rtg_revision_rec.job_type = WIP_CONSTANTS.STANDARD) THEN
6831: l_temp := c_bom_rtg_revision_rec.item_id;
6832: ELSIF (c_bom_rtg_revision_rec.job_type = WIP_CONSTANTS.NONSTANDARD) THEN
6833: l_temp := c_bom_rtg_revision_rec.rtg_ref_id;
6834: END IF;
6835:
6836: -- BA: CZH.I_OED-1: the following logic is not right,

Line 6908: IF (c_bom_rtg_revision_rec.job_type = WIP_CONSTANTS.STANDARD) THEN

6904: END IF;
6905: END IF;
6906:
6907: l_stmt_num := 175;
6908: IF (c_bom_rtg_revision_rec.job_type = WIP_CONSTANTS.STANDARD) THEN
6909: l_stmt_num := 176;
6910: l_temp := c_bom_rtg_revision_rec.item_id;
6911: ELSIF (c_bom_rtg_revision_rec.job_type = WIP_CONSTANTS.NONSTANDARD) THEN
6912: l_stmt_num := 177;

Line 6911: ELSIF (c_bom_rtg_revision_rec.job_type = WIP_CONSTANTS.NONSTANDARD) THEN

6907: l_stmt_num := 175;
6908: IF (c_bom_rtg_revision_rec.job_type = WIP_CONSTANTS.STANDARD) THEN
6909: l_stmt_num := 176;
6910: l_temp := c_bom_rtg_revision_rec.item_id;
6911: ELSIF (c_bom_rtg_revision_rec.job_type = WIP_CONSTANTS.NONSTANDARD) THEN
6912: l_stmt_num := 177;
6913: l_temp := c_bom_rtg_revision_rec.bom_ref_id;
6914: END IF;
6915:

Line 7008: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

7004: --Changed the sql since org_id has been added to WRJI now--
7005: UPDATE wsm_resulting_jobs_interface wrji
7006: SET wrji.error_message = l_fnd_generic_err_msg
7007: WHERE wrji.header_id = l_header_id
7008: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
7009: and not exists (select null
7010: from mtl_routing_rev_highdate_v rou
7011: where wrji.organization_id = rou.organization_id
7012: --VJ: Start Changes for NSLBJ--

Line 7014: WIP_CONSTANTS.STANDARD,

7010: from mtl_routing_rev_highdate_v rou
7011: where wrji.organization_id = rou.organization_id
7012: --VJ: Start Changes for NSLBJ--
7013: and rou.inventory_item_id = decode(l_job_type,
7014: WIP_CONSTANTS.STANDARD,
7015: wrji.primary_item_id,
7016: WIP_CONSTANTS.NONSTANDARD,
7017: wrji.routing_reference_id)
7018: --VJ: End Changes for NSLBJ--

Line 7016: WIP_CONSTANTS.NONSTANDARD,

7012: --VJ: Start Changes for NSLBJ--
7013: and rou.inventory_item_id = decode(l_job_type,
7014: WIP_CONSTANTS.STANDARD,
7015: wrji.primary_item_id,
7016: WIP_CONSTANTS.NONSTANDARD,
7017: wrji.routing_reference_id)
7018: --VJ: End Changes for NSLBJ--
7019: and rou.process_revision = nvl(wrji.routing_revision,
7020: rou.process_revision)

Line 7149: IF(l_job_type = WIP_CONSTANTS.STANDARD) THEN --VJ: Added for NSLBJ--

7145:
7146: l_upd_rtg_asly_err := 0;
7147:
7148: l_stmt_num := 182;
7149: IF(l_job_type = WIP_CONSTANTS.STANDARD) THEN --VJ: Added for NSLBJ--
7150: l_stmt_num := 183;
7151: select
7152: bor.common_routing_sequence_id,
7153: wrji.primary_item_id,

Line 7179: and wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--

7175: and wrji.rowid = l_wrji_rowid --SpUA add
7176: and wsji.header_id = wrji.header_id
7177: and bor.organization_id = wrji.organization_id --VJ: Added for NSLBJ--
7178: --Above condition also a fix for bug #2269765--
7179: and wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
7180:
7181: --VJ: Start Additions for NSLBJ--
7182: ELSIF(l_job_type = WIP_CONSTANTS.NONSTANDARD) THEN
7183: l_stmt_num := 184;

Line 7182: ELSIF(l_job_type = WIP_CONSTANTS.NONSTANDARD) THEN

7178: --Above condition also a fix for bug #2269765--
7179: and wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
7180:
7181: --VJ: Start Additions for NSLBJ--
7182: ELSIF(l_job_type = WIP_CONSTANTS.NONSTANDARD) THEN
7183: l_stmt_num := 184;
7184: select
7185: wrji.common_routing_sequence_id,
7186: wrji.primary_item_id,

Line 7207: and wrji.job_type = WIP_CONSTANTS.NONSTANDARD; --VJ: Added for NSLBJ--

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
7207: and wrji.job_type = WIP_CONSTANTS.NONSTANDARD; --VJ: Added for NSLBJ--
7208:
7209: END IF;
7210: --VJ: End Additions for NSLBJ--
7211:

Line 7233: WSMPUTIL.operation_is_standard_repeats (

7229:
7230: l_stmt_num := 185;
7231: -- This is called to get information about the starting operation --
7232: -- in the target routing --
7233: WSMPUTIL.operation_is_standard_repeats (
7234: p_routing_sequence_id => l_com_rtg_seq_id,
7235: p_routing_revision_date => l_rtg_rev_date, -- sysdate
7236: p_standard_operation_id => l_start_std_op_id,
7237: p_operation_code => l_start_op_code,

Line 7236: p_standard_operation_id => l_start_std_op_id,

7232: -- in the target routing --
7233: WSMPUTIL.operation_is_standard_repeats (
7234: p_routing_sequence_id => l_com_rtg_seq_id,
7235: p_routing_revision_date => l_rtg_rev_date, -- sysdate
7236: p_standard_operation_id => l_start_std_op_id,
7237: p_operation_code => l_start_op_code,
7238: p_organization_id => l_organization_id, --BBK
7239: p_op_is_std_op => l_op_is_std,
7240: p_op_repeated_times => l_op_rptd_times,

Line 7254: 'Returned success from WSMPUTIL.operation_is_standard_repeats;'

7250:
7251: If (l_debug = 'Y') Then
7252:
7253: FND_FILE.PUT_LINE(FND_FILE.LOG,
7254: 'Returned success from WSMPUTIL.operation_is_standard_repeats;'
7255: || ' Job currently at intraoperation Step: '|| l_sj_intraoperation_step
7256: ||'; l_op_is_std: ' || l_op_is_std
7257: || '; l_op_rptd_times '|| l_op_rptd_times);
7258:

Line 7287: select standard_operation_id

7283:
7284: --BA: BUGFIX 2686319 get the start_op_seq_num
7285: if( l_start_std_op_id IS NULL) then
7286: l_stmt_num := 189;
7287: select standard_operation_id
7288: into l_start_std_op_id
7289: from bom_standard_operations
7290: where organization_id = l_organization_id -- BBK
7291: and operation_type = 1 -- Standard Operation Type BBK

Line 7289: from bom_standard_operations

7285: if( l_start_std_op_id IS NULL) then
7286: l_stmt_num := 189;
7287: select standard_operation_id
7288: into l_start_std_op_id
7289: from bom_standard_operations
7290: where organization_id = l_organization_id -- BBK
7291: and operation_type = 1 -- Standard Operation Type BBK
7292: and line_id is NULL -- Not for a WIP Line BBK
7293: and operation_code = l_start_op_code;

Line 7291: and operation_type = 1 -- Standard Operation Type BBK

7287: select standard_operation_id
7288: into l_start_std_op_id
7289: from bom_standard_operations
7290: where organization_id = l_organization_id -- BBK
7291: and operation_type = 1 -- Standard Operation Type BBK
7292: and line_id is NULL -- Not for a WIP Line BBK
7293: and operation_code = l_start_op_code;
7294: end if;
7295:

Line 7302: and bos.STANDARD_OPERATION_ID = l_start_std_op_id;

7298: into l_start_op_seq_num
7299: from bom_operation_sequences bos
7300: where bos.routing_sequence_id = l_com_rtg_seq_id
7301: and bos.operation_type = 1
7302: and bos.STANDARD_OPERATION_ID = l_start_std_op_id;
7303: --BA: BUGFIX 2686319 get the start_op_seq_num
7304: l_stmt_num := 191;
7305: UPDATE wsm_resulting_jobs_interface wrji
7306: SET starting_std_op_id = l_start_std_op_id,

Line 7351: -- A Nonstandard operation OR

7347: (l_op_is_std = 0 and l_sj_intraoperation_step = WIP_CONSTANTS.TOMOVE)
7348: OR (l_op_rptd_times <> 1 and l_sj_intraoperation_step = WIP_CONSTANTS.TOMOVE)
7349: ) then
7350: -- At TO_MOVE, if current operation is
7351: -- A Nonstandard operation OR
7352: -- A standard operation but is not repeated in tgrtouting
7353: -- A Standard Operation but is repeated more than once.
7354: -- Null out the starting opseqnum/code..but done already.
7355:

Line 7352: -- A standard operation but is not repeated in tgrtouting

7348: OR (l_op_rptd_times <> 1 and l_sj_intraoperation_step = WIP_CONSTANTS.TOMOVE)
7349: ) then
7350: -- At TO_MOVE, if current operation is
7351: -- A Nonstandard operation OR
7352: -- A standard operation but is not repeated in tgrtouting
7353: -- A Standard Operation but is repeated more than once.
7354: -- Null out the starting opseqnum/code..but done already.
7355:
7356: null;

Line 7353: -- A Standard Operation but is repeated more than once.

7349: ) then
7350: -- At TO_MOVE, if current operation is
7351: -- A Nonstandard operation OR
7352: -- A standard operation but is not repeated in tgrtouting
7353: -- A Standard Operation but is repeated more than once.
7354: -- Null out the starting opseqnum/code..but done already.
7355:
7356: null;
7357:

Line 7443: ( SELECT bso.standard_operation_id

7439: AND txn.transaction_type_id = WSMPCNST.BONUS)
7440: AND wrji.starting_std_op_id is not null
7441: AND wrji.starting_operation_code is not null
7442: AND wrji.starting_std_op_id <>
7443: ( SELECT bso.standard_operation_id
7444: FROM bom_standard_operations bso
7445: WHERE bso.organization_id = wrji.organization_id
7446: AND bso.operation_code = wrji.starting_operation_code);
7447:

Line 7444: FROM bom_standard_operations bso

7440: AND wrji.starting_std_op_id is not null
7441: AND wrji.starting_operation_code is not null
7442: AND wrji.starting_std_op_id <>
7443: ( SELECT bso.standard_operation_id
7444: FROM bom_standard_operations bso
7445: WHERE bso.organization_id = wrji.organization_id
7446: AND bso.operation_code = wrji.starting_operation_code);
7447:
7448: --VJ: End Changes for NSLBJ--

Line 7584: bos.standard_operation_id

7580: END IF;
7581:
7582: l_stmt_num := 199;
7583: select bos.operation_seq_num,
7584: bos.standard_operation_id
7585: into l_bos_op_seq_num,
7586: l_bos_std_op_id
7587: from bom_operation_sequences bos
7588: where bos.operation_sequence_id = l_start_op_seq_id;

Line 7595: FROM bom_standard_operations

7591: IF (nvl(l_bos_std_op_id, -9999) <> -9999) THEN -- Get the op_code
7592: l_stmt_num := 200;
7593: SELECT operation_code
7594: INTO l_bso_op_code
7595: FROM bom_standard_operations
7596: WHERE standard_operation_id = l_bos_std_op_id
7597: AND organization_id = l_organization_id;
7598: END IF;
7599:

Line 7596: WHERE standard_operation_id = l_bos_std_op_id

7592: l_stmt_num := 200;
7593: SELECT operation_code
7594: INTO l_bso_op_code
7595: FROM bom_standard_operations
7596: WHERE standard_operation_id = l_bos_std_op_id
7597: AND organization_id = l_organization_id;
7598: END IF;
7599:
7600: l_stmt_num := 201;

Line 7655: -- use wsmputil.operation_is_standard_repeats to find out if it repeats in

7651: begin
7652:
7653: -- BA NSO-WLT
7654: -- Find the routing seq id for this bonus job, using this rtg_seq_id and op_code,
7655: -- use wsmputil.operation_is_standard_repeats to find out if it repeats in
7656: -- the n/w rtg.
7657:
7658: l_stmt_num := 202;
7659: --VJ: Start Changes for NSLBJ--

Line 7669: wsmputil.operation_is_standard_repeats(

7665: --VJ: End Changes for NSLBJ--
7666:
7667:
7668: l_stmt_num := 203;
7669: wsmputil.operation_is_standard_repeats(
7670: p_routing_sequence_id => l_rl_rtg_seq_id,
7671: p_routing_revision_date => l_rtg_rev_date, --sysdate
7672: p_standard_operation_id => NULL,
7673: p_operation_code => l_start_op_code,

Line 7672: p_standard_operation_id => NULL,

7668: l_stmt_num := 203;
7669: wsmputil.operation_is_standard_repeats(
7670: p_routing_sequence_id => l_rl_rtg_seq_id,
7671: p_routing_revision_date => l_rtg_rev_date, --sysdate
7672: p_standard_operation_id => NULL,
7673: p_operation_code => l_start_op_code,
7674: p_organization_id => l_organization_id, --BBK
7675: p_op_is_std_op => l_op_is_std_op,
7676: p_op_repeated_times => l_op_repeated_times,

Line 7718: bos.standard_operation_id -- 1685779 :added this col as part of select

7714: -- If not, no-data-found is raised where we handle the error.
7715:
7716: l_stmt_num := 205;
7717: SELECT bos.operation_sequence_id,
7718: bos.standard_operation_id -- 1685779 :added this col as part of select
7719: INTO l_bos_op_seq_id,
7720: l_bos_std_op_id
7721: FROM bom_standard_operations bso,
7722: bom_operation_sequences bos,

Line 7721: FROM bom_standard_operations bso,

7717: SELECT bos.operation_sequence_id,
7718: bos.standard_operation_id -- 1685779 :added this col as part of select
7719: INTO l_bos_op_seq_id,
7720: l_bos_std_op_id
7721: FROM bom_standard_operations bso,
7722: bom_operation_sequences bos,
7723: wsm_resulting_jobs_interface wrji
7724: WHERE wrji.header_id = l_header_id
7725: AND exists (SELECT null

Line 7730: AND nvl(bos.standard_operation_id, -9999) = nvl(bso.standard_operation_id, -9999)

7726: FROM wsm_split_merge_txn_interface txn
7727: WHERE txn.header_id = wrji.header_id
7728: AND txn.transaction_type_id = WSMPCNST.BONUS)
7729: AND bos.routing_sequence_id = wrji.common_routing_sequence_id
7730: AND nvl(bos.standard_operation_id, -9999) = nvl(bso.standard_operation_id, -9999)
7731: AND nvl(bso.operation_code, '*') = nvl(l_start_op_code, '*')
7732: AND bos.operation_seq_num = l_start_op_seq_num --2265237
7733: -- BC: CZH.I_OED-1, check against routing revsion date
7734: -- bugfix 1709639. Check for disabled operation

Line 7752: bos.standard_operation_id -- 1685779 :added this col as part of select

7748:
7749: l_stmt_num := 206;
7750: SELECT bos.operation_seq_num,
7751: bos.operation_sequence_id,
7752: bos.standard_operation_id -- 1685779 :added this col as part of select
7753: INTO l_bos_op_seq_num,
7754: l_bos_op_seq_id,
7755: l_bos_std_op_id
7756: FROM bom_standard_operations bso,

Line 7756: FROM bom_standard_operations bso,

7752: bos.standard_operation_id -- 1685779 :added this col as part of select
7753: INTO l_bos_op_seq_num,
7754: l_bos_op_seq_id,
7755: l_bos_std_op_id
7756: FROM bom_standard_operations bso,
7757: bom_operation_sequences bos,
7758: wsm_resulting_jobs_interface wrji
7759: WHERE wrji.header_id = l_header_id
7760: AND exists (SELECT null

Line 7765: AND nvl(bos.standard_operation_id, -9999) = nvl(bso.standard_operation_id, -9999)

7761: FROM wsm_split_merge_txn_interface txn
7762: WHERE txn.header_id = wrji.header_id
7763: AND txn.transaction_type_id = WSMPCNST.BONUS)
7764: AND bos.routing_sequence_id = wrji.common_routing_sequence_id
7765: AND nvl(bos.standard_operation_id, -9999) = nvl(bso.standard_operation_id, -9999)
7766: AND nvl(bso.operation_code, '*') = nvl(l_start_op_code, '*')
7767: -- BC: CZH.I_OED-1, check against routing revsion date
7768: -- bugfix 1709639. Check for disabled operation
7769: --AND nvl(bos.disable_date, sysdate+1) > sysdate

Line 7886: bos.standard_operation_id

7882: -- BA NSO-WLT BBK Commented out BSO related details.
7883:
7884: l_stmt_num := 210;
7885: SELECT bos.operation_sequence_id,
7886: bos.standard_operation_id
7887: INTO l_bos_op_seq_id,
7888: l_bos_std_op_id
7889: FROM bom_operation_sequences bos,
7890: wsm_resulting_jobs_interface wrji

Line 7910: From BOM_STANDARD_OPERATIONS

7906:
7907: If l_bos_std_op_id is not null Then
7908: l_stmt_num := 211;
7909: Select operation_code into l_bso_op_code
7910: From BOM_STANDARD_OPERATIONS
7911: Where standard_operation_id = l_bos_std_op_id;
7912:
7913: End If;
7914:

Line 7911: Where standard_operation_id = l_bos_std_op_id;

7907: If l_bos_std_op_id is not null Then
7908: l_stmt_num := 211;
7909: Select operation_code into l_bso_op_code
7910: From BOM_STANDARD_OPERATIONS
7911: Where standard_operation_id = l_bos_std_op_id;
7912:
7913: End If;
7914:
7915: -- EA NSO-WLT