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.INV_UI_RCV_LOVS dependencies on DUAL

Line 332: SELECT TRIM(LEADING '0' FROM p_po_release_num ) INTO po_release_number FROM Dual;

328: /* Start - Fix for Bug# 6640083 */
329: -- po_release_number := to_char(to_number(p_po_release_num));
330: -- This will convert String to number - Bug#6012703
331: -- Commented the code for Bug#6640083
332: SELECT TRIM(LEADING '0' FROM p_po_release_num ) INTO po_release_number FROM Dual;
333: -- This will trim leading zeroes - Bug#6640083
334: /* End - Fix for Bug# 6640083 */
335: EXCEPTION
336: WHEN OTHERS then

Line 423: SELECT TRIM(LEADING '0' FROM p_po_line_num ) INTO po_line_number FROM Dual;

419: /* Start - Fix for Bug# 6640083 */
420: -- po_line_number := to_char(to_number(p_po_line_num));
421: -- This will convert String to number - Bug#6012703
422: -- Commented the code for Bug#6640083
423: SELECT TRIM(LEADING '0' FROM p_po_line_num ) INTO po_line_number FROM Dual;
424: -- This will trim leading zeroes - Bug#6640083
425: /* End - Fix for Bug# 6640083 */
426: EXCEPTION
427: WHEN OTHERS then

Line 2943: SELECT TRIM(LEADING '0' FROM p_po_line_num ) INTO po_line_number FROM Dual;

2939: /* Start - Fix for Bug# 6640083 */
2940: -- po_line_number := to_char(to_number(p_po_line_num));
2941: -- This will convert String to number - Bug#6012703
2942: -- Commented the code for Bug#6640083
2943: SELECT TRIM(LEADING '0' FROM p_po_line_num ) INTO po_line_number FROM Dual;
2944: -- This will trim leading zeroes - Bug#6640083
2945: /* End - Fix for Bug# 6640083 */
2946: EXCEPTION
2947: WHEN OTHERS then

Line 3234: SELECT TRIM(LEADING '0' FROM p_po_release_num ) INTO po_release_number FROM Dual;

3230: /* Start - Fix for Bug# 6640083 */
3231: -- po_release_number := to_char(to_number(p_po_release_num));
3232: -- This will convert String to number - Bug#6012703
3233: -- Commented the code for Bug#6640083
3234: SELECT TRIM(LEADING '0' FROM p_po_release_num ) INTO po_release_number FROM Dual;
3235: -- This will trim leading zeroes - Bug#6640083
3236: /* End - Fix for Bug# 6640083 */
3237: EXCEPTION
3238: WHEN OTHERS then

Line 3424: NVL(DUAL_UOM_DEVIATION_HIGH,0),

3420: NVL(LOT_DIVISIBLE_FLAG,'Y'),
3421: NVL(SECONDARY_UOM_CODE,''),
3422: NVL(SECONDARY_DEFAULT_IND,''),
3423: NVL(TRACKING_QUANTITY_IND,'P'),
3424: NVL(DUAL_UOM_DEVIATION_HIGH,0),
3425: NVL(DUAL_UOM_DEVIATION_LOW,0),
3426: stock_enabled_flag,
3427: ' ',
3428: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 3425: NVL(DUAL_UOM_DEVIATION_LOW,0),

3421: NVL(SECONDARY_UOM_CODE,''),
3422: NVL(SECONDARY_DEFAULT_IND,''),
3423: NVL(TRACKING_QUANTITY_IND,'P'),
3424: NVL(DUAL_UOM_DEVIATION_HIGH,0),
3425: NVL(DUAL_UOM_DEVIATION_LOW,0),
3426: stock_enabled_flag,
3427: ' ',
3428: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
3429: from mtl_system_items_vl, /* Bug 5581528 */

Line 3515: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

3511: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
3512: NVL(MSI.SECONDARY_UOM_CODE,''),
3513: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3514: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3515: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3516: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3517: msi.stock_enabled_flag,
3518: ' ',
3519: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 3516: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

3512: NVL(MSI.SECONDARY_UOM_CODE,''),
3513: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3514: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3515: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3516: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3517: msi.stock_enabled_flag,
3518: ' ',
3519: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
3520: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 3612: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

3608: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
3609: NVL(MSI.SECONDARY_UOM_CODE,''),
3610: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3611: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3612: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3613: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3614: msi.stock_enabled_flag,
3615: ' ',
3616: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 3613: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

3609: NVL(MSI.SECONDARY_UOM_CODE,''),
3610: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3611: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3612: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3613: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3614: msi.stock_enabled_flag,
3615: ' ',
3616: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
3617: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 3800: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

3796: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
3797: NVL(MSI.SECONDARY_UOM_CODE,''),
3798: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3799: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3800: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3801: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3802: msi.stock_enabled_flag,
3803: ' ',
3804: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 3801: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

3797: NVL(MSI.SECONDARY_UOM_CODE,''),
3798: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3799: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3800: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3801: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3802: msi.stock_enabled_flag,
3803: ' ',
3804: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
3805: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 4001: NVL(DUAL_UOM_DEVIATION_HIGH,0),

3997: NVL(LOT_DIVISIBLE_FLAG,'Y'),
3998: NVL(SECONDARY_UOM_CODE,''),
3999: NVL(SECONDARY_DEFAULT_IND,''),
4000: NVL(TRACKING_QUANTITY_IND,'P'),
4001: NVL(DUAL_UOM_DEVIATION_HIGH,0),
4002: NVL(DUAL_UOM_DEVIATION_LOW,0),
4003: stock_enabled_flag,
4004: ' ',
4005: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 4002: NVL(DUAL_UOM_DEVIATION_LOW,0),

3998: NVL(SECONDARY_UOM_CODE,''),
3999: NVL(SECONDARY_DEFAULT_IND,''),
4000: NVL(TRACKING_QUANTITY_IND,'P'),
4001: NVL(DUAL_UOM_DEVIATION_HIGH,0),
4002: NVL(DUAL_UOM_DEVIATION_LOW,0),
4003: stock_enabled_flag,
4004: ' ',
4005: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4006: from mtl_system_items_vl, /* Bug 5581528 */

Line 4094: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

4090: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
4091: NVL(MSI.SECONDARY_UOM_CODE,''),
4092: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4093: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4094: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4095: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4096: msi.stock_enabled_flag,
4097: ' ',
4098: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 4095: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

4091: NVL(MSI.SECONDARY_UOM_CODE,''),
4092: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4093: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4094: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4095: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4096: msi.stock_enabled_flag,
4097: ' ',
4098: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4099: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 4191: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

4187: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
4188: NVL(MSI.SECONDARY_UOM_CODE,''),
4189: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4190: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4191: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4192: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4193: msi.stock_enabled_flag,
4194: ' ',
4195: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 4192: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

4188: NVL(MSI.SECONDARY_UOM_CODE,''),
4189: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4190: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4191: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4192: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4193: msi.stock_enabled_flag,
4194: ' ',
4195: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4196: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 4378: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

4374: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
4375: NVL(MSI.SECONDARY_UOM_CODE,''),
4376: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4377: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4378: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4379: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4380: msi.stock_enabled_flag,
4381: ' ',
4382: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 4379: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

4375: NVL(MSI.SECONDARY_UOM_CODE,''),
4376: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4377: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4378: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4379: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4380: msi.stock_enabled_flag,
4381: ' ',
4382: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4383: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 4593: NVL(DUAL_UOM_DEVIATION_HIGH,0),

4589: NVL(LOT_DIVISIBLE_FLAG,'Y'),
4590: NVL(SECONDARY_UOM_CODE,''),
4591: NVL(SECONDARY_DEFAULT_IND,''),
4592: NVL(TRACKING_QUANTITY_IND,'P'),
4593: NVL(DUAL_UOM_DEVIATION_HIGH,0),
4594: NVL(DUAL_UOM_DEVIATION_LOW,0),
4595: stock_enabled_flag,
4596: ' ',
4597: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 4594: NVL(DUAL_UOM_DEVIATION_LOW,0),

4590: NVL(SECONDARY_UOM_CODE,''),
4591: NVL(SECONDARY_DEFAULT_IND,''),
4592: NVL(TRACKING_QUANTITY_IND,'P'),
4593: NVL(DUAL_UOM_DEVIATION_HIGH,0),
4594: NVL(DUAL_UOM_DEVIATION_LOW,0),
4595: stock_enabled_flag,
4596: ' ',
4597: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4598: from mtl_system_items_vl , /* Bug 5581528 */

Line 4682: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

4678: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
4679: NVL(MSI.SECONDARY_UOM_CODE,''),
4680: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4681: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4682: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4683: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4684: msi.stock_enabled_flag,
4685: ' ',
4686: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 4683: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

4679: NVL(MSI.SECONDARY_UOM_CODE,''),
4680: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4681: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4682: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4683: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4684: msi.stock_enabled_flag,
4685: ' ',
4686: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4687: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 4778: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

4774: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
4775: NVL(MSI.SECONDARY_UOM_CODE,''),
4776: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4777: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4778: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4779: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4780: msi.stock_enabled_flag,
4781: ' ',
4782: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 4779: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

4775: NVL(MSI.SECONDARY_UOM_CODE,''),
4776: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4777: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4778: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4779: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4780: msi.stock_enabled_flag,
4781: ' ',
4782: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4783: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 4964: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

4960: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
4961: NVL(MSI.SECONDARY_UOM_CODE,''),
4962: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4963: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4964: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4965: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4966: msi.stock_enabled_flag,
4967: ' ',
4968: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 4965: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

4961: NVL(MSI.SECONDARY_UOM_CODE,''),
4962: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4963: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4964: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4965: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4966: msi.stock_enabled_flag,
4967: ' ',
4968: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4969: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 5163: NVL(DUAL_UOM_DEVIATION_HIGH,0),

5159: NVL(LOT_DIVISIBLE_FLAG,'Y'),
5160: NVL(SECONDARY_UOM_CODE,''),
5161: NVL(SECONDARY_DEFAULT_IND,''),
5162: NVL(TRACKING_QUANTITY_IND,'P'),
5163: NVL(DUAL_UOM_DEVIATION_HIGH,0),
5164: NVL(DUAL_UOM_DEVIATION_LOW,0),
5165: stock_enabled_flag,
5166: ' ',
5167: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 5164: NVL(DUAL_UOM_DEVIATION_LOW,0),

5160: NVL(SECONDARY_UOM_CODE,''),
5161: NVL(SECONDARY_DEFAULT_IND,''),
5162: NVL(TRACKING_QUANTITY_IND,'P'),
5163: NVL(DUAL_UOM_DEVIATION_HIGH,0),
5164: NVL(DUAL_UOM_DEVIATION_LOW,0),
5165: stock_enabled_flag,
5166: ' ',
5167: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5168: from mtl_system_items_vl, /* Bug 5581528 */

Line 5245: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

5241: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
5242: NVL(MSI.SECONDARY_UOM_CODE,''),
5243: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5244: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5245: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5246: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5247: msi.stock_enabled_flag,
5248: ' ',
5249: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 5246: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

5242: NVL(MSI.SECONDARY_UOM_CODE,''),
5243: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5244: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5245: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5246: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5247: msi.stock_enabled_flag,
5248: ' ',
5249: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5250: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 5334: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

5330: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
5331: NVL(MSI.SECONDARY_UOM_CODE,''),
5332: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5333: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5334: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5335: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5336: msi.stock_enabled_flag,
5337: ' ',
5338: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 5335: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

5331: NVL(MSI.SECONDARY_UOM_CODE,''),
5332: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5333: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5334: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5335: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5336: msi.stock_enabled_flag,
5337: ' ',
5338: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5339: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 5507: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

5503: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
5504: NVL(MSI.SECONDARY_UOM_CODE,''),
5505: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5506: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5507: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5508: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5509: msi.stock_enabled_flag,
5510: ' ',
5511: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 5508: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

5504: NVL(MSI.SECONDARY_UOM_CODE,''),
5505: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5506: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5507: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5508: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5509: msi.stock_enabled_flag,
5510: ' ',
5511: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5512: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 5692: NVL(DUAL_UOM_DEVIATION_HIGH,0),

5688: NVL(LOT_DIVISIBLE_FLAG,'Y'),
5689: NVL(SECONDARY_UOM_CODE,''),
5690: NVL(SECONDARY_DEFAULT_IND,''),
5691: NVL(TRACKING_QUANTITY_IND,'P'),
5692: NVL(DUAL_UOM_DEVIATION_HIGH,0),
5693: NVL(DUAL_UOM_DEVIATION_LOW,0),
5694: stock_enabled_flag,
5695: ' ',
5696: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 5693: NVL(DUAL_UOM_DEVIATION_LOW,0),

5689: NVL(SECONDARY_UOM_CODE,''),
5690: NVL(SECONDARY_DEFAULT_IND,''),
5691: NVL(TRACKING_QUANTITY_IND,'P'),
5692: NVL(DUAL_UOM_DEVIATION_HIGH,0),
5693: NVL(DUAL_UOM_DEVIATION_LOW,0),
5694: stock_enabled_flag,
5695: ' ',
5696: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5697: from mtl_system_items_vl , /* Bug 5581528 */

Line 5775: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

5771: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
5772: NVL(MSI.SECONDARY_UOM_CODE,''),
5773: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5774: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5775: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5776: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5777: msi.stock_enabled_flag,
5778: ' ',
5779: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 5776: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

5772: NVL(MSI.SECONDARY_UOM_CODE,''),
5773: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5774: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5775: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5776: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5777: msi.stock_enabled_flag,
5778: ' ',
5779: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5780: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 5863: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

5859: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
5860: NVL(MSI.SECONDARY_UOM_CODE,''),
5861: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5862: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5863: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5864: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5865: msi.stock_enabled_flag,
5866: ' ',
5867: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 5864: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

5860: NVL(MSI.SECONDARY_UOM_CODE,''),
5861: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5862: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5863: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5864: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5865: msi.stock_enabled_flag,
5866: ' ',
5867: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5868: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 6033: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

6029: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
6030: NVL(MSI.SECONDARY_UOM_CODE,''),
6031: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6032: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6033: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6034: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6035: msi.stock_enabled_flag,
6036: ' ',
6037: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 6034: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

6030: NVL(MSI.SECONDARY_UOM_CODE,''),
6031: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6032: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6033: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6034: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6035: msi.stock_enabled_flag,
6036: ' ',
6037: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6038: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 6218: NVL(DUAL_UOM_DEVIATION_HIGH,0),

6214: NVL(LOT_DIVISIBLE_FLAG,'Y'),
6215: NVL(SECONDARY_UOM_CODE,''),
6216: NVL(SECONDARY_DEFAULT_IND,''),
6217: NVL(TRACKING_QUANTITY_IND,'P'),
6218: NVL(DUAL_UOM_DEVIATION_HIGH,0),
6219: NVL(DUAL_UOM_DEVIATION_LOW,0),
6220: stock_enabled_flag,
6221: ' ',
6222: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 6219: NVL(DUAL_UOM_DEVIATION_LOW,0),

6215: NVL(SECONDARY_UOM_CODE,''),
6216: NVL(SECONDARY_DEFAULT_IND,''),
6217: NVL(TRACKING_QUANTITY_IND,'P'),
6218: NVL(DUAL_UOM_DEVIATION_HIGH,0),
6219: NVL(DUAL_UOM_DEVIATION_LOW,0),
6220: stock_enabled_flag,
6221: ' ',
6222: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6223: from mtl_system_items_vl /* Bug 5581528 */

Line 6298: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

6294: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
6295: NVL(MSI.SECONDARY_UOM_CODE,''),
6296: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6297: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6298: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6299: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6300: msi.stock_enabled_flag,
6301: ' ',
6302: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 6299: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

6295: NVL(MSI.SECONDARY_UOM_CODE,''),
6296: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6297: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6298: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6299: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6300: msi.stock_enabled_flag,
6301: ' ',
6302: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6303: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 6385: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

6381: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
6382: NVL(MSI.SECONDARY_UOM_CODE,''),
6383: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6384: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6385: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6386: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6387: msi.stock_enabled_flag,
6388: ' ',
6389: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 6386: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

6382: NVL(MSI.SECONDARY_UOM_CODE,''),
6383: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6384: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6385: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6386: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6387: msi.stock_enabled_flag,
6388: ' ',
6389: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6390: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 6554: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

6550: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
6551: NVL(MSI.SECONDARY_UOM_CODE,''),
6552: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6553: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6554: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6555: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6556: msi.stock_enabled_flag,
6557: ' ',
6558: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 6555: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

6551: NVL(MSI.SECONDARY_UOM_CODE,''),
6552: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6553: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6554: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6555: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6556: msi.stock_enabled_flag,
6557: ' ',
6558: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6559: from po_lines_trx_v pol -- CLM project, bug 9403291

Line 6752: NVL(DUAL_UOM_DEVIATION_HIGH,0),

6748: NVL(LOT_DIVISIBLE_FLAG,'Y'),
6749: NVL(msn.SECONDARY_UOM_CODE,''),
6750: NVL(SECONDARY_DEFAULT_IND,''),
6751: NVL(TRACKING_QUANTITY_IND,'P'),
6752: NVL(DUAL_UOM_DEVIATION_HIGH,0),
6753: NVL(DUAL_UOM_DEVIATION_LOW,0),
6754: stock_enabled_flag,
6755: DECODE (p_reqHeaderID,to_char(null),' ', rsh.shipment_num),
6756: DECODE (p_reqHeaderID,to_char(null),' ',p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 6753: NVL(DUAL_UOM_DEVIATION_LOW,0),

6749: NVL(msn.SECONDARY_UOM_CODE,''),
6750: NVL(SECONDARY_DEFAULT_IND,''),
6751: NVL(TRACKING_QUANTITY_IND,'P'),
6752: NVL(DUAL_UOM_DEVIATION_HIGH,0),
6753: NVL(DUAL_UOM_DEVIATION_LOW,0),
6754: stock_enabled_flag,
6755: DECODE (p_reqHeaderID,to_char(null),' ', rsh.shipment_num),
6756: DECODE (p_reqHeaderID,to_char(null),' ',p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6757: from wms_lpn_contents wlc ,

Line 6824: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

6820: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
6821: NVL(MSI.SECONDARY_UOM_CODE,''),
6822: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6823: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6824: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6825: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6826: msi.stock_enabled_flag,
6827: DECODE (p_reqHeaderID,to_char(null),' ',
6828: rsh.shipment_num),

Line 6825: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

6821: NVL(MSI.SECONDARY_UOM_CODE,''),
6822: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6823: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6824: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6825: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6826: msi.stock_enabled_flag,
6827: DECODE (p_reqHeaderID,to_char(null),' ',
6828: rsh.shipment_num),
6829: DECODE (p_reqHeaderID,to_char(null),' ',

Line 7018: NVL(MSN.DUAL_UOM_DEVIATION_HIGH,0),

7014: NVL(MSN.LOT_DIVISIBLE_FLAG,'Y'),
7015: NVL(MSN.SECONDARY_UOM_CODE,''),
7016: NVL(MSN.SECONDARY_DEFAULT_IND,''),
7017: NVL(MSN.TRACKING_QUANTITY_IND,'P'),
7018: NVL(MSN.DUAL_UOM_DEVIATION_HIGH,0),
7019: NVL(MSN.DUAL_UOM_DEVIATION_LOW,0),
7020: msn.stock_enabled_flag,
7021: DECODE (p_reqHeaderID,to_char(null),' ',
7022: rsh.shipment_num),

Line 7019: NVL(MSN.DUAL_UOM_DEVIATION_LOW,0),

7015: NVL(MSN.SECONDARY_UOM_CODE,''),
7016: NVL(MSN.SECONDARY_DEFAULT_IND,''),
7017: NVL(MSN.TRACKING_QUANTITY_IND,'P'),
7018: NVL(MSN.DUAL_UOM_DEVIATION_HIGH,0),
7019: NVL(MSN.DUAL_UOM_DEVIATION_LOW,0),
7020: msn.stock_enabled_flag,
7021: DECODE (p_reqHeaderID,to_char(null),' ',
7022: rsh.shipment_num),
7023: DECODE (p_reqHeaderID,to_char(null),' ',

Line 7095: NVL(DUAL_UOM_DEVIATION_HIGH,0),

7091: NVL(LOT_DIVISIBLE_FLAG,'Y'),
7092: NVL(msn.SECONDARY_UOM_CODE,''),
7093: NVL(SECONDARY_DEFAULT_IND,''),
7094: NVL(TRACKING_QUANTITY_IND,'P'),
7095: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7096: NVL(DUAL_UOM_DEVIATION_LOW,0),
7097: stock_enabled_flag,
7098: DECODE (p_reqHeaderID,to_char(null),' ',
7099: rsh.shipment_num),

Line 7096: NVL(DUAL_UOM_DEVIATION_LOW,0),

7092: NVL(msn.SECONDARY_UOM_CODE,''),
7093: NVL(SECONDARY_DEFAULT_IND,''),
7094: NVL(TRACKING_QUANTITY_IND,'P'),
7095: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7096: NVL(DUAL_UOM_DEVIATION_LOW,0),
7097: stock_enabled_flag,
7098: DECODE (p_reqHeaderID,to_char(null),' ',
7099: rsh.shipment_num),
7100: DECODE (p_reqHeaderID,to_char(null),' ',

Line 7165: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

7161: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
7162: NVL(MSI.SECONDARY_UOM_CODE,''),
7163: NVL(MSI.SECONDARY_DEFAULT_IND,''),
7164: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
7165: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
7166: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
7167: msi.stock_enabled_flag,
7168: DECODE (p_reqHeaderID,to_char(null),' ',
7169: rsh.shipment_num),

Line 7166: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

7162: NVL(MSI.SECONDARY_UOM_CODE,''),
7163: NVL(MSI.SECONDARY_DEFAULT_IND,''),
7164: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
7165: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
7166: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
7167: msi.stock_enabled_flag,
7168: DECODE (p_reqHeaderID,to_char(null),' ',
7169: rsh.shipment_num),
7170: DECODE (p_reqHeaderID,to_char(null),' ',

Line 7355: NVL(MSN.DUAL_UOM_DEVIATION_HIGH,0),

7351: NVL(MSN.LOT_DIVISIBLE_FLAG,'Y'),
7352: NVL(MSN.SECONDARY_UOM_CODE,''),
7353: NVL(MSN.SECONDARY_DEFAULT_IND,''),
7354: NVL(MSN.TRACKING_QUANTITY_IND,'P'),
7355: NVL(MSN.DUAL_UOM_DEVIATION_HIGH,0),
7356: NVL(MSN.DUAL_UOM_DEVIATION_LOW,0),
7357: msn.stock_enabled_flag,
7358: DECODE (p_reqHeaderID,to_char(null),' ',
7359: rsh.shipment_num),

Line 7356: NVL(MSN.DUAL_UOM_DEVIATION_LOW,0),

7352: NVL(MSN.SECONDARY_UOM_CODE,''),
7353: NVL(MSN.SECONDARY_DEFAULT_IND,''),
7354: NVL(MSN.TRACKING_QUANTITY_IND,'P'),
7355: NVL(MSN.DUAL_UOM_DEVIATION_HIGH,0),
7356: NVL(MSN.DUAL_UOM_DEVIATION_LOW,0),
7357: msn.stock_enabled_flag,
7358: DECODE (p_reqHeaderID,to_char(null),' ',
7359: rsh.shipment_num),
7360: DECODE (p_reqHeaderID,to_char(null),' ',

Line 7441: NVL(DUAL_UOM_DEVIATION_HIGH,0),

7437: NVL(LOT_DIVISIBLE_FLAG,'Y'),
7438: NVL(SECONDARY_UOM_CODE,''),
7439: NVL(SECONDARY_DEFAULT_IND,''),
7440: NVL(TRACKING_QUANTITY_IND,'P'),
7441: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7442: NVL(DUAL_UOM_DEVIATION_LOW,0),
7443: stock_enabled_flag,
7444: ' ',
7445: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 7442: NVL(DUAL_UOM_DEVIATION_LOW,0),

7438: NVL(SECONDARY_UOM_CODE,''),
7439: NVL(SECONDARY_DEFAULT_IND,''),
7440: NVL(TRACKING_QUANTITY_IND,'P'),
7441: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7442: NVL(DUAL_UOM_DEVIATION_LOW,0),
7443: stock_enabled_flag,
7444: ' ',
7445: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7446: from mtl_system_items_vl /* Bug 5581528 */

Line 7509: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

7505: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
7506: NVL(MSI.SECONDARY_UOM_CODE,''),
7507: NVL(MSI.SECONDARY_DEFAULT_IND,''),
7508: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
7509: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
7510: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
7511: msi.stock_enabled_flag,
7512: ' ',
7513: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 7510: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

7506: NVL(MSI.SECONDARY_UOM_CODE,''),
7507: NVL(MSI.SECONDARY_DEFAULT_IND,''),
7508: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
7509: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
7510: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
7511: msi.stock_enabled_flag,
7512: ' ',
7513: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7514: from mtl_system_items_vl msi /* Bug 5581528 */

Line 7597: NVL(DUAL_UOM_DEVIATION_HIGH,0) ,

7593: NVL(LOT_DIVISIBLE_FLAG,'Y') ,
7594: NVL(SECONDARY_UOM_CODE,'') ,
7595: NVL(SECONDARY_DEFAULT_IND,'') ,
7596: NVL(TRACKING_QUANTITY_IND,'P') ,
7597: NVL(DUAL_UOM_DEVIATION_HIGH,0) ,
7598: NVL(DUAL_UOM_DEVIATION_LOW,0) ,
7599: stock_enabled_flag,
7600: rsl1.shipment_num,
7601: to_char(rsl1.shipment_header_id) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 7598: NVL(DUAL_UOM_DEVIATION_LOW,0) ,

7594: NVL(SECONDARY_UOM_CODE,'') ,
7595: NVL(SECONDARY_DEFAULT_IND,'') ,
7596: NVL(TRACKING_QUANTITY_IND,'P') ,
7597: NVL(DUAL_UOM_DEVIATION_HIGH,0) ,
7598: NVL(DUAL_UOM_DEVIATION_LOW,0) ,
7599: stock_enabled_flag,
7600: rsl1.shipment_num,
7601: to_char(rsl1.shipment_header_id) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7602: FROM mtl_system_items_vl,

Line 7684: NVL(DUAL_UOM_DEVIATION_HIGH,0) ,

7680: NVL(LOT_DIVISIBLE_FLAG,'Y') ,
7681: NVL(SECONDARY_UOM_CODE,'') ,
7682: NVL(SECONDARY_DEFAULT_IND,'') ,
7683: NVL(TRACKING_QUANTITY_IND,'P') ,
7684: NVL(DUAL_UOM_DEVIATION_HIGH,0) ,
7685: NVL(DUAL_UOM_DEVIATION_LOW,0) ,
7686: stock_enabled_flag,
7687: rsl1.shipment_num,
7688: to_char(rsl1.shipment_header_id) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 7685: NVL(DUAL_UOM_DEVIATION_LOW,0) ,

7681: NVL(SECONDARY_UOM_CODE,'') ,
7682: NVL(SECONDARY_DEFAULT_IND,'') ,
7683: NVL(TRACKING_QUANTITY_IND,'P') ,
7684: NVL(DUAL_UOM_DEVIATION_HIGH,0) ,
7685: NVL(DUAL_UOM_DEVIATION_LOW,0) ,
7686: stock_enabled_flag,
7687: rsl1.shipment_num,
7688: to_char(rsl1.shipment_header_id) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7689: FROM mtl_system_items_vl,

Line 7765: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0) ,

7761: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y') ,
7762: NVL(MSI.SECONDARY_UOM_CODE,'') ,
7763: NVL(MSI.SECONDARY_DEFAULT_IND,'') ,
7764: NVL(MSI.TRACKING_QUANTITY_IND,'P') ,
7765: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0) ,
7766: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0) ,
7767: msi.stock_enabled_flag,
7768: rsl1.shipment_num,
7769: to_char(rsl1.shipment_header_id) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 7766: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0) ,

7762: NVL(MSI.SECONDARY_UOM_CODE,'') ,
7763: NVL(MSI.SECONDARY_DEFAULT_IND,'') ,
7764: NVL(MSI.TRACKING_QUANTITY_IND,'P') ,
7765: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0) ,
7766: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0) ,
7767: msi.stock_enabled_flag,
7768: rsl1.shipment_num,
7769: to_char(rsl1.shipment_header_id) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7770: FROM mtl_system_items_vl msi

Line 7890: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),

7886: NVL(msi.LOT_DIVISIBLE_FLAG,'Y'),
7887: NVL(msi.SECONDARY_UOM_CODE,''),
7888: NVL(msi.SECONDARY_DEFAULT_IND,''),
7889: NVL(msi.TRACKING_QUANTITY_IND,'P'),
7890: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
7891: NVL(msi.DUAL_UOM_DEVIATION_LOW,0),
7892: msi.stock_enabled_flag,
7893: ' ',
7894: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 7891: NVL(msi.DUAL_UOM_DEVIATION_LOW,0),

7887: NVL(msi.SECONDARY_UOM_CODE,''),
7888: NVL(msi.SECONDARY_DEFAULT_IND,''),
7889: NVL(msi.TRACKING_QUANTITY_IND,'P'),
7890: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
7891: NVL(msi.DUAL_UOM_DEVIATION_LOW,0),
7892: msi.stock_enabled_flag,
7893: ' ',
7894: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7895: FROM

Line 7951: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

7947: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
7948: NVL(MSI.SECONDARY_UOM_CODE,''),
7949: NVL(MSI.SECONDARY_DEFAULT_IND,''),
7950: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
7951: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
7952: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
7953: msi.stock_enabled_flag,
7954: ' ',
7955: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 7952: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

7948: NVL(MSI.SECONDARY_UOM_CODE,''),
7949: NVL(MSI.SECONDARY_DEFAULT_IND,''),
7950: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
7951: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
7952: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
7953: msi.stock_enabled_flag,
7954: ' ',
7955: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7956: FROM

Line 8038: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

8034: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
8035: NVL(MSI.SECONDARY_UOM_CODE,''),
8036: NVL(MSI.SECONDARY_DEFAULT_IND,''),
8037: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
8038: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
8039: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
8040: msi.stock_enabled_flag,
8041: ' ',
8042: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 8039: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

8035: NVL(MSI.SECONDARY_UOM_CODE,''),
8036: NVL(MSI.SECONDARY_DEFAULT_IND,''),
8037: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
8038: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
8039: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
8040: msi.stock_enabled_flag,
8041: ' ',
8042: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
8043: FROM

Line 8118: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),

8114: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
8115: NVL(MSI.SECONDARY_UOM_CODE,''),
8116: NVL(MSI.SECONDARY_DEFAULT_IND,''),
8117: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
8118: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
8119: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
8120: msi.stock_enabled_flag,
8121: ' ',
8122: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id

Line 8119: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),

8115: NVL(MSI.SECONDARY_UOM_CODE,''),
8116: NVL(MSI.SECONDARY_DEFAULT_IND,''),
8117: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
8118: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
8119: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
8120: msi.stock_enabled_flag,
8121: ' ',
8122: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
8123: FROM

Line 8284: NVL(DUAL_UOM_DEVIATION_HIGH,0),

8280: NVL(LOT_DIVISIBLE_FLAG,'Y'),
8281: NVL(SECONDARY_UOM_CODE,''),
8282: NVL(SECONDARY_DEFAULT_IND,''),
8283: NVL(TRACKING_QUANTITY_IND,'P'),
8284: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8285: NVL(DUAL_UOM_DEVIATION_LOW,0)
8286: from mtl_system_items_vl
8287: WHERE organization_id = p_Organization_Id
8288: and concatenated_segments like p_concatenated_segments||l_append

Line 8285: NVL(DUAL_UOM_DEVIATION_LOW,0)

8281: NVL(SECONDARY_UOM_CODE,''),
8282: NVL(SECONDARY_DEFAULT_IND,''),
8283: NVL(TRACKING_QUANTITY_IND,'P'),
8284: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8285: NVL(DUAL_UOM_DEVIATION_LOW,0)
8286: from mtl_system_items_vl
8287: WHERE organization_id = p_Organization_Id
8288: and concatenated_segments like p_concatenated_segments||l_append
8289: and mtl_transactions_enabled_flag = 'Y'

Line 8338: NVL(DUAL_UOM_DEVIATION_HIGH,0),

8334: NVL(LOT_DIVISIBLE_FLAG,'Y'),
8335: NVL(SECONDARY_UOM_CODE,''),
8336: NVL(SECONDARY_DEFAULT_IND,''),
8337: NVL(TRACKING_QUANTITY_IND,'P'),
8338: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8339: NVL(DUAL_UOM_DEVIATION_LOW,0)
8340: from mtl_system_items_vl msik, /* Bug 5581528 */
8341: mtl_cross_references mcr
8342: WHERE msik.organization_id = p_Organization_Id

Line 8339: NVL(DUAL_UOM_DEVIATION_LOW,0)

8335: NVL(SECONDARY_UOM_CODE,''),
8336: NVL(SECONDARY_DEFAULT_IND,''),
8337: NVL(TRACKING_QUANTITY_IND,'P'),
8338: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8339: NVL(DUAL_UOM_DEVIATION_LOW,0)
8340: from mtl_system_items_vl msik, /* Bug 5581528 */
8341: mtl_cross_references mcr
8342: WHERE msik.organization_id = p_Organization_Id
8343: AND msik.inventory_item_id = mcr.inventory_item_id

Line 8605: NVL(DUAL_UOM_DEVIATION_HIGH,0),

8601: NVL(LOT_DIVISIBLE_FLAG,'Y'),
8602: NVL(SECONDARY_UOM_CODE,''),
8603: NVL(SECONDARY_DEFAULT_IND,''),
8604: NVL(TRACKING_QUANTITY_IND,'P'),
8605: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8606: NVL(DUAL_UOM_DEVIATION_LOW,0)
8607: FROM
8608: mtl_system_items_vl msik /* Bug 5581528 */
8609: WHERE

Line 8606: NVL(DUAL_UOM_DEVIATION_LOW,0)

8602: NVL(SECONDARY_UOM_CODE,''),
8603: NVL(SECONDARY_DEFAULT_IND,''),
8604: NVL(TRACKING_QUANTITY_IND,'P'),
8605: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8606: NVL(DUAL_UOM_DEVIATION_LOW,0)
8607: FROM
8608: mtl_system_items_vl msik /* Bug 5581528 */
8609: WHERE
8610: organization_id = p_Organization_Id

Line 8665: NVL(DUAL_UOM_DEVIATION_HIGH,0),

8661: NVL(LOT_DIVISIBLE_FLAG,'Y'),
8662: NVL(SECONDARY_UOM_CODE,''),
8663: NVL(SECONDARY_DEFAULT_IND,''),
8664: NVL(TRACKING_QUANTITY_IND,'P'),
8665: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8666: NVL(DUAL_UOM_DEVIATION_LOW,0)
8667: FROM
8668: mtl_system_items_vl msik, /* Bug 5581528 */
8669: mtl_cross_references mcr

Line 8666: NVL(DUAL_UOM_DEVIATION_LOW,0)

8662: NVL(SECONDARY_UOM_CODE,''),
8663: NVL(SECONDARY_DEFAULT_IND,''),
8664: NVL(TRACKING_QUANTITY_IND,'P'),
8665: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8666: NVL(DUAL_UOM_DEVIATION_LOW,0)
8667: FROM
8668: mtl_system_items_vl msik, /* Bug 5581528 */
8669: mtl_cross_references mcr
8670: WHERE

Line 8733: NVL(DUAL_UOM_DEVIATION_HIGH,0),

8729: NVL(LOT_DIVISIBLE_FLAG,'Y'),
8730: NVL(SECONDARY_UOM_CODE,''),
8731: NVL(SECONDARY_DEFAULT_IND,''),
8732: NVL(TRACKING_QUANTITY_IND,'P'),
8733: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8734: NVL(DUAL_UOM_DEVIATION_LOW,0)
8735: FROM
8736: mtl_system_items_vl msik /* Bug 5581528 */
8737: WHERE

Line 8734: NVL(DUAL_UOM_DEVIATION_LOW,0)

8730: NVL(SECONDARY_UOM_CODE,''),
8731: NVL(SECONDARY_DEFAULT_IND,''),
8732: NVL(TRACKING_QUANTITY_IND,'P'),
8733: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8734: NVL(DUAL_UOM_DEVIATION_LOW,0)
8735: FROM
8736: mtl_system_items_vl msik /* Bug 5581528 */
8737: WHERE
8738: organization_id = p_Organization_Id

Line 8788: NVL(DUAL_UOM_DEVIATION_HIGH,0),

8784: NVL(LOT_DIVISIBLE_FLAG,'Y'),
8785: NVL(SECONDARY_UOM_CODE,''),
8786: NVL(SECONDARY_DEFAULT_IND,''),
8787: NVL(TRACKING_QUANTITY_IND,'P'),
8788: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8789: NVL(DUAL_UOM_DEVIATION_LOW,0)
8790: FROM
8791: mtl_system_items_vl msik, /* Bug 5581528 */
8792: mtl_cross_references mcr

Line 8789: NVL(DUAL_UOM_DEVIATION_LOW,0)

8785: NVL(SECONDARY_UOM_CODE,''),
8786: NVL(SECONDARY_DEFAULT_IND,''),
8787: NVL(TRACKING_QUANTITY_IND,'P'),
8788: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8789: NVL(DUAL_UOM_DEVIATION_LOW,0)
8790: FROM
8791: mtl_system_items_vl msik, /* Bug 5581528 */
8792: mtl_cross_references mcr
8793: WHERE

Line 8850: NVL(DUAL_UOM_DEVIATION_HIGH,0),

8846: NVL(LOT_DIVISIBLE_FLAG,'Y'),
8847: NVL(SECONDARY_UOM_CODE,''),
8848: NVL(SECONDARY_DEFAULT_IND,''),
8849: NVL(TRACKING_QUANTITY_IND,'P'),
8850: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8851: NVL(DUAL_UOM_DEVIATION_LOW,0)
8852: FROM
8853: mtl_system_items_vl msik /* Bug 5581528 */
8854: WHERE

Line 8851: NVL(DUAL_UOM_DEVIATION_LOW,0)

8847: NVL(SECONDARY_UOM_CODE,''),
8848: NVL(SECONDARY_DEFAULT_IND,''),
8849: NVL(TRACKING_QUANTITY_IND,'P'),
8850: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8851: NVL(DUAL_UOM_DEVIATION_LOW,0)
8852: FROM
8853: mtl_system_items_vl msik /* Bug 5581528 */
8854: WHERE
8855: organization_id = p_Organization_Id

Line 8905: NVL(DUAL_UOM_DEVIATION_HIGH,0),

8901: NVL(LOT_DIVISIBLE_FLAG,'Y'),
8902: NVL(SECONDARY_UOM_CODE,''),
8903: NVL(SECONDARY_DEFAULT_IND,''),
8904: NVL(TRACKING_QUANTITY_IND,'P'),
8905: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8906: NVL(DUAL_UOM_DEVIATION_LOW,0)
8907: FROM
8908: mtl_system_items_vl msik, /* Bug 5581528 */
8909: mtl_cross_references mcr

Line 8906: NVL(DUAL_UOM_DEVIATION_LOW,0)

8902: NVL(SECONDARY_UOM_CODE,''),
8903: NVL(SECONDARY_DEFAULT_IND,''),
8904: NVL(TRACKING_QUANTITY_IND,'P'),
8905: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8906: NVL(DUAL_UOM_DEVIATION_LOW,0)
8907: FROM
8908: mtl_system_items_vl msik, /* Bug 5581528 */
8909: mtl_cross_references mcr
8910: WHERE

Line 8967: NVL(DUAL_UOM_DEVIATION_HIGH,0),

8963: NVL(LOT_DIVISIBLE_FLAG,'Y'),
8964: NVL(SECONDARY_UOM_CODE,''),
8965: NVL(SECONDARY_DEFAULT_IND,''),
8966: NVL(TRACKING_QUANTITY_IND,'P'),
8967: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8968: NVL(DUAL_UOM_DEVIATION_LOW,0)
8969: FROM
8970: mtl_system_items_vl msik /* Bug 5581528 */
8971: WHERE

Line 8968: NVL(DUAL_UOM_DEVIATION_LOW,0)

8964: NVL(SECONDARY_UOM_CODE,''),
8965: NVL(SECONDARY_DEFAULT_IND,''),
8966: NVL(TRACKING_QUANTITY_IND,'P'),
8967: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8968: NVL(DUAL_UOM_DEVIATION_LOW,0)
8969: FROM
8970: mtl_system_items_vl msik /* Bug 5581528 */
8971: WHERE
8972: organization_id = p_Organization_Id

Line 9022: NVL(DUAL_UOM_DEVIATION_HIGH,0),

9018: NVL(LOT_DIVISIBLE_FLAG,'Y'),
9019: NVL(SECONDARY_UOM_CODE,''),
9020: NVL(SECONDARY_DEFAULT_IND,''),
9021: NVL(TRACKING_QUANTITY_IND,'P'),
9022: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9023: NVL(DUAL_UOM_DEVIATION_LOW,0)
9024: FROM
9025: mtl_system_items_vl msik, /* Bug 5581528 */
9026: mtl_cross_references mcr

Line 9023: NVL(DUAL_UOM_DEVIATION_LOW,0)

9019: NVL(SECONDARY_UOM_CODE,''),
9020: NVL(SECONDARY_DEFAULT_IND,''),
9021: NVL(TRACKING_QUANTITY_IND,'P'),
9022: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9023: NVL(DUAL_UOM_DEVIATION_LOW,0)
9024: FROM
9025: mtl_system_items_vl msik, /* Bug 5581528 */
9026: mtl_cross_references mcr
9027: WHERE

Line 9085: NVL(DUAL_UOM_DEVIATION_HIGH,0),

9081: NVL(LOT_DIVISIBLE_FLAG,'Y'),
9082: NVL(SECONDARY_UOM_CODE,''),
9083: NVL(SECONDARY_DEFAULT_IND,''),
9084: NVL(TRACKING_QUANTITY_IND,'P'),
9085: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9086: NVL(DUAL_UOM_DEVIATION_LOW,0)
9087: FROM
9088: mtl_system_items_vl msik /* Bug 5581528 */
9089: WHERE

Line 9086: NVL(DUAL_UOM_DEVIATION_LOW,0)

9082: NVL(SECONDARY_UOM_CODE,''),
9083: NVL(SECONDARY_DEFAULT_IND,''),
9084: NVL(TRACKING_QUANTITY_IND,'P'),
9085: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9086: NVL(DUAL_UOM_DEVIATION_LOW,0)
9087: FROM
9088: mtl_system_items_vl msik /* Bug 5581528 */
9089: WHERE
9090: organization_id = p_Organization_Id

Line 9140: NVL(DUAL_UOM_DEVIATION_HIGH,0),

9136: NVL(LOT_DIVISIBLE_FLAG,'Y'),
9137: NVL(SECONDARY_UOM_CODE,''),
9138: NVL(SECONDARY_DEFAULT_IND,''),
9139: NVL(TRACKING_QUANTITY_IND,'P'),
9140: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9141: NVL(DUAL_UOM_DEVIATION_LOW,0)
9142: FROM
9143: mtl_system_items_vl msik, /* Bug 5581528 */
9144: mtl_cross_references mcr

Line 9141: NVL(DUAL_UOM_DEVIATION_LOW,0)

9137: NVL(SECONDARY_UOM_CODE,''),
9138: NVL(SECONDARY_DEFAULT_IND,''),
9139: NVL(TRACKING_QUANTITY_IND,'P'),
9140: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9141: NVL(DUAL_UOM_DEVIATION_LOW,0)
9142: FROM
9143: mtl_system_items_vl msik, /* Bug 5581528 */
9144: mtl_cross_references mcr
9145: WHERE

Line 9202: NVL(DUAL_UOM_DEVIATION_HIGH,0),

9198: NVL(LOT_DIVISIBLE_FLAG,'Y'),
9199: NVL(SECONDARY_UOM_CODE,''),
9200: NVL(SECONDARY_DEFAULT_IND,''),
9201: NVL(TRACKING_QUANTITY_IND,'P'),
9202: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9203: NVL(DUAL_UOM_DEVIATION_LOW,0)
9204: FROM
9205: mtl_system_items_vl msik /* Bug 5581528 */
9206: WHERE

Line 9203: NVL(DUAL_UOM_DEVIATION_LOW,0)

9199: NVL(SECONDARY_UOM_CODE,''),
9200: NVL(SECONDARY_DEFAULT_IND,''),
9201: NVL(TRACKING_QUANTITY_IND,'P'),
9202: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9203: NVL(DUAL_UOM_DEVIATION_LOW,0)
9204: FROM
9205: mtl_system_items_vl msik /* Bug 5581528 */
9206: WHERE
9207: organization_id = p_Organization_Id

Line 9261: NVL(DUAL_UOM_DEVIATION_HIGH,0),

9257: NVL(LOT_DIVISIBLE_FLAG,'Y'),
9258: NVL(SECONDARY_UOM_CODE,''),
9259: NVL(SECONDARY_DEFAULT_IND,''),
9260: NVL(TRACKING_QUANTITY_IND,'P'),
9261: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9262: NVL(DUAL_UOM_DEVIATION_LOW,0)
9263: FROM
9264: mtl_system_items_vl msik, /* Bug 5581528 */
9265: mtl_cross_references mcr

Line 9262: NVL(DUAL_UOM_DEVIATION_LOW,0)

9258: NVL(SECONDARY_UOM_CODE,''),
9259: NVL(SECONDARY_DEFAULT_IND,''),
9260: NVL(TRACKING_QUANTITY_IND,'P'),
9261: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9262: NVL(DUAL_UOM_DEVIATION_LOW,0)
9263: FROM
9264: mtl_system_items_vl msik, /* Bug 5581528 */
9265: mtl_cross_references mcr
9266: WHERE

Line 9327: NVL(DUAL_UOM_DEVIATION_HIGH,0),

9323: NVL(LOT_DIVISIBLE_FLAG,'Y'),
9324: NVL(SECONDARY_UOM_CODE,''),
9325: NVL(SECONDARY_DEFAULT_IND,''),
9326: NVL(TRACKING_QUANTITY_IND,'P'),
9327: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9328: NVL(DUAL_UOM_DEVIATION_LOW,0)
9329: FROM
9330: mtl_system_items_vl msik /* Bug 5581528 */
9331: WHERE

Line 9328: NVL(DUAL_UOM_DEVIATION_LOW,0)

9324: NVL(SECONDARY_UOM_CODE,''),
9325: NVL(SECONDARY_DEFAULT_IND,''),
9326: NVL(TRACKING_QUANTITY_IND,'P'),
9327: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9328: NVL(DUAL_UOM_DEVIATION_LOW,0)
9329: FROM
9330: mtl_system_items_vl msik /* Bug 5581528 */
9331: WHERE
9332: organization_id = p_Organization_Id

Line 9382: NVL(DUAL_UOM_DEVIATION_HIGH,0),

9378: NVL(LOT_DIVISIBLE_FLAG,'Y'),
9379: NVL(SECONDARY_UOM_CODE,''),
9380: NVL(SECONDARY_DEFAULT_IND,''),
9381: NVL(TRACKING_QUANTITY_IND,'P'),
9382: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9383: NVL(DUAL_UOM_DEVIATION_LOW,0)
9384: FROM
9385: mtl_system_items_vl msik, /* Bug 5581528 */
9386: mtl_cross_references mcr

Line 9383: NVL(DUAL_UOM_DEVIATION_LOW,0)

9379: NVL(SECONDARY_UOM_CODE,''),
9380: NVL(SECONDARY_DEFAULT_IND,''),
9381: NVL(TRACKING_QUANTITY_IND,'P'),
9382: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9383: NVL(DUAL_UOM_DEVIATION_LOW,0)
9384: FROM
9385: mtl_system_items_vl msik, /* Bug 5581528 */
9386: mtl_cross_references mcr
9387: WHERE