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 311: SELECT TRIM(LEADING '0' FROM p_po_release_num ) INTO po_release_number FROM Dual;

307: /* Start - Fix for Bug# 6640083 */
308: -- po_release_number := to_char(to_number(p_po_release_num));
309: -- This will convert String to number - Bug#6012703
310: -- Commented the code for Bug#6640083
311: SELECT TRIM(LEADING '0' FROM p_po_release_num ) INTO po_release_number FROM Dual;
312: -- This will trim leading zeroes - Bug#6640083
313: /* End - Fix for Bug# 6640083 */
314: EXCEPTION
315: WHEN OTHERS then

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

393: /* Start - Fix for Bug# 6640083 */
394: -- po_line_number := to_char(to_number(p_po_line_num));
395: -- This will convert String to number - Bug#6012703
396: -- Commented the code for Bug#6640083
397: SELECT TRIM(LEADING '0' FROM p_po_line_num ) INTO po_line_number FROM Dual;
398: -- This will trim leading zeroes - Bug#6640083
399: /* End - Fix for Bug# 6640083 */
400: EXCEPTION
401: WHEN OTHERS then

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

2876: /* Start - Fix for Bug# 6640083 */
2877: -- po_line_number := to_char(to_number(p_po_line_num));
2878: -- This will convert String to number - Bug#6012703
2879: -- Commented the code for Bug#6640083
2880: SELECT TRIM(LEADING '0' FROM p_po_line_num ) INTO po_line_number FROM Dual;
2881: -- This will trim leading zeroes - Bug#6640083
2882: /* End - Fix for Bug# 6640083 */
2883: EXCEPTION
2884: WHEN OTHERS then

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

3114: /* Start - Fix for Bug# 6640083 */
3115: -- po_release_number := to_char(to_number(p_po_release_num));
3116: -- This will convert String to number - Bug#6012703
3117: -- Commented the code for Bug#6640083
3118: SELECT TRIM(LEADING '0' FROM p_po_release_num ) INTO po_release_number FROM Dual;
3119: -- This will trim leading zeroes - Bug#6640083
3120: /* End - Fix for Bug# 6640083 */
3121: EXCEPTION
3122: WHEN OTHERS then

Line 3287: NVL(DUAL_UOM_DEVIATION_HIGH,0),

3283: NVL(LOT_DIVISIBLE_FLAG,'Y'),
3284: NVL(SECONDARY_UOM_CODE,''),
3285: NVL(SECONDARY_DEFAULT_IND,''),
3286: NVL(TRACKING_QUANTITY_IND,'P'),
3287: NVL(DUAL_UOM_DEVIATION_HIGH,0),
3288: NVL(DUAL_UOM_DEVIATION_LOW,0),
3289: stock_enabled_flag
3290: from mtl_system_items_vl /* Bug 5581528 */
3291: WHERE organization_id = p_Organization_Id

Line 3288: NVL(DUAL_UOM_DEVIATION_LOW,0),

3284: NVL(SECONDARY_UOM_CODE,''),
3285: NVL(SECONDARY_DEFAULT_IND,''),
3286: NVL(TRACKING_QUANTITY_IND,'P'),
3287: NVL(DUAL_UOM_DEVIATION_HIGH,0),
3288: NVL(DUAL_UOM_DEVIATION_LOW,0),
3289: stock_enabled_flag
3290: from mtl_system_items_vl /* Bug 5581528 */
3291: WHERE organization_id = p_Organization_Id
3292: and concatenated_segments like p_concatenated_segments

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

3368: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
3369: NVL(MSI.SECONDARY_UOM_CODE,''),
3370: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3371: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3372: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3373: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3374: msi.stock_enabled_flag
3375: from po_lines_all pol
3376: ,mtl_related_items mri

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

3369: NVL(MSI.SECONDARY_UOM_CODE,''),
3370: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3371: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3372: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3373: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3374: msi.stock_enabled_flag
3375: from po_lines_all pol
3376: ,mtl_related_items mri
3377: ,mtl_system_items_vl msi /* Bug 5581528 */

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

3461: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
3462: NVL(MSI.SECONDARY_UOM_CODE,''),
3463: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3464: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3465: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3466: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3467: msi.stock_enabled_flag
3468: from po_lines_all pol
3469: , mtl_system_items_vl msi /* Bug 5581528 */

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

3462: NVL(MSI.SECONDARY_UOM_CODE,''),
3463: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3464: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3465: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3466: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3467: msi.stock_enabled_flag
3468: from po_lines_all pol
3469: , mtl_system_items_vl msi /* Bug 5581528 */
3470: where organization_id = p_organization_id

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

3640: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
3641: NVL(MSI.SECONDARY_UOM_CODE,''),
3642: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3643: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3644: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3645: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3646: msi.stock_enabled_flag
3647: from po_lines_all pol
3648: ,mtl_system_items_vl msi /* Bug 5581528 */

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

3641: NVL(MSI.SECONDARY_UOM_CODE,''),
3642: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3643: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3644: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3645: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3646: msi.stock_enabled_flag
3647: from po_lines_all pol
3648: ,mtl_system_items_vl msi /* Bug 5581528 */
3649: ,mtl_cross_references mcr

Line 3747: NVL(DUAL_UOM_DEVIATION_HIGH,0),

3743: NVL(LOT_DIVISIBLE_FLAG,'Y'),
3744: NVL(SECONDARY_UOM_CODE,''),
3745: NVL(SECONDARY_DEFAULT_IND,''),
3746: NVL(TRACKING_QUANTITY_IND,'P'),
3747: NVL(DUAL_UOM_DEVIATION_HIGH,0),
3748: NVL(DUAL_UOM_DEVIATION_LOW,0),
3749: stock_enabled_flag
3750: from mtl_system_items_vl /* Bug 5581528 */
3751: WHERE organization_id = p_Organization_Id

Line 3748: NVL(DUAL_UOM_DEVIATION_LOW,0),

3744: NVL(SECONDARY_UOM_CODE,''),
3745: NVL(SECONDARY_DEFAULT_IND,''),
3746: NVL(TRACKING_QUANTITY_IND,'P'),
3747: NVL(DUAL_UOM_DEVIATION_HIGH,0),
3748: NVL(DUAL_UOM_DEVIATION_LOW,0),
3749: stock_enabled_flag
3750: from mtl_system_items_vl /* Bug 5581528 */
3751: WHERE organization_id = p_Organization_Id
3752: and concatenated_segments like p_concatenated_segments

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

3829: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
3830: NVL(MSI.SECONDARY_UOM_CODE,''),
3831: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3832: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3833: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3834: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3835: msi.stock_enabled_flag
3836: from po_lines_all pol
3837: ,mtl_related_items mri

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

3830: NVL(MSI.SECONDARY_UOM_CODE,''),
3831: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3832: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3833: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3834: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3835: msi.stock_enabled_flag
3836: from po_lines_all pol
3837: ,mtl_related_items mri
3838: ,mtl_system_items_vl msi /* Bug 5581528 */

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

3923: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
3924: NVL(MSI.SECONDARY_UOM_CODE,''),
3925: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3926: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3927: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3928: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3929: msi.stock_enabled_flag
3930: from po_lines_all pol
3931: , mtl_system_items_vl msi /* Bug 5581528 */

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

3924: NVL(MSI.SECONDARY_UOM_CODE,''),
3925: NVL(MSI.SECONDARY_DEFAULT_IND,''),
3926: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
3927: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
3928: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3929: msi.stock_enabled_flag
3930: from po_lines_all pol
3931: , mtl_system_items_vl msi /* Bug 5581528 */
3932: where organization_id = p_organization_id

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

4104: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
4105: NVL(MSI.SECONDARY_UOM_CODE,''),
4106: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4107: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4108: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4109: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4110: msi.stock_enabled_flag
4111: from po_lines_all pol
4112: ,mtl_system_items_vl msi /* Bug 5581528 */

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

4105: NVL(MSI.SECONDARY_UOM_CODE,''),
4106: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4107: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4108: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4109: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4110: msi.stock_enabled_flag
4111: from po_lines_all pol
4112: ,mtl_system_items_vl msi /* Bug 5581528 */
4113: ,mtl_cross_references mcr

Line 4219: NVL(DUAL_UOM_DEVIATION_HIGH,0),

4215: NVL(LOT_DIVISIBLE_FLAG,'Y'),
4216: NVL(SECONDARY_UOM_CODE,''),
4217: NVL(SECONDARY_DEFAULT_IND,''),
4218: NVL(TRACKING_QUANTITY_IND,'P'),
4219: NVL(DUAL_UOM_DEVIATION_HIGH,0),
4220: NVL(DUAL_UOM_DEVIATION_LOW,0),
4221: stock_enabled_flag
4222: from mtl_system_items_vl , /* Bug 5581528 */
4223: po_lines_all pol -- bug 4602289

Line 4220: NVL(DUAL_UOM_DEVIATION_LOW,0),

4216: NVL(SECONDARY_UOM_CODE,''),
4217: NVL(SECONDARY_DEFAULT_IND,''),
4218: NVL(TRACKING_QUANTITY_IND,'P'),
4219: NVL(DUAL_UOM_DEVIATION_HIGH,0),
4220: NVL(DUAL_UOM_DEVIATION_LOW,0),
4221: stock_enabled_flag
4222: from mtl_system_items_vl , /* Bug 5581528 */
4223: po_lines_all pol -- bug 4602289
4224: WHERE organization_id = p_Organization_Id

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

4301: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
4302: NVL(MSI.SECONDARY_UOM_CODE,''),
4303: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4304: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4305: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4306: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4307: msi.stock_enabled_flag
4308: from po_lines_all pol
4309: ,mtl_related_items mri

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

4302: NVL(MSI.SECONDARY_UOM_CODE,''),
4303: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4304: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4305: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4306: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4307: msi.stock_enabled_flag
4308: from po_lines_all pol
4309: ,mtl_related_items mri
4310: ,mtl_system_items_vl msi /* Bug 5581528 */

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

4394: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
4395: NVL(MSI.SECONDARY_UOM_CODE,''),
4396: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4397: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4398: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4399: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4400: msi.stock_enabled_flag
4401: from po_lines_all pol
4402: , mtl_system_items_vl msi /* Bug 5581528 */

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

4395: NVL(MSI.SECONDARY_UOM_CODE,''),
4396: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4397: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4398: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4399: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4400: msi.stock_enabled_flag
4401: from po_lines_all pol
4402: , mtl_system_items_vl msi /* Bug 5581528 */
4403: where organization_id = p_organization_id

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

4574: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
4575: NVL(MSI.SECONDARY_UOM_CODE,''),
4576: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4577: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4578: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4579: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4580: msi.stock_enabled_flag
4581: from po_lines_all pol
4582: ,mtl_system_items_vl msi /* Bug 5581528 */

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

4575: NVL(MSI.SECONDARY_UOM_CODE,''),
4576: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4577: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4578: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4579: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4580: msi.stock_enabled_flag
4581: from po_lines_all pol
4582: ,mtl_system_items_vl msi /* Bug 5581528 */
4583: ,mtl_cross_references mcr

Line 4688: NVL(DUAL_UOM_DEVIATION_HIGH,0),

4684: NVL(LOT_DIVISIBLE_FLAG,'Y'),
4685: NVL(SECONDARY_UOM_CODE,''),
4686: NVL(SECONDARY_DEFAULT_IND,''),
4687: NVL(TRACKING_QUANTITY_IND,'P'),
4688: NVL(DUAL_UOM_DEVIATION_HIGH,0),
4689: NVL(DUAL_UOM_DEVIATION_LOW,0),
4690: stock_enabled_flag
4691: from mtl_system_items_vl /* Bug 5581528 */
4692: WHERE organization_id = p_Organization_Id

Line 4689: NVL(DUAL_UOM_DEVIATION_LOW,0),

4685: NVL(SECONDARY_UOM_CODE,''),
4686: NVL(SECONDARY_DEFAULT_IND,''),
4687: NVL(TRACKING_QUANTITY_IND,'P'),
4688: NVL(DUAL_UOM_DEVIATION_HIGH,0),
4689: NVL(DUAL_UOM_DEVIATION_LOW,0),
4690: stock_enabled_flag
4691: from mtl_system_items_vl /* Bug 5581528 */
4692: WHERE organization_id = p_Organization_Id
4693: and concatenated_segments like p_concatenated_segments

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

4762: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
4763: NVL(MSI.SECONDARY_UOM_CODE,''),
4764: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4765: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4766: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4767: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4768: msi.stock_enabled_flag
4769: from po_lines_all pol
4770: ,mtl_related_items mri

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

4763: NVL(MSI.SECONDARY_UOM_CODE,''),
4764: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4765: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4766: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4767: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4768: msi.stock_enabled_flag
4769: from po_lines_all pol
4770: ,mtl_related_items mri
4771: ,mtl_system_items_vl msi /* Bug 5581528 */

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

4848: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
4849: NVL(MSI.SECONDARY_UOM_CODE,''),
4850: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4851: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4852: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4853: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4854: msi.stock_enabled_flag
4855: from po_lines_all pol
4856: , mtl_system_items_vl msi /* Bug 5581528 */

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

4849: NVL(MSI.SECONDARY_UOM_CODE,''),
4850: NVL(MSI.SECONDARY_DEFAULT_IND,''),
4851: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
4852: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
4853: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4854: msi.stock_enabled_flag
4855: from po_lines_all pol
4856: , mtl_system_items_vl msi /* Bug 5581528 */
4857: where organization_id = p_organization_id

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

5014: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
5015: NVL(MSI.SECONDARY_UOM_CODE,''),
5016: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5017: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5018: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5019: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5020: msi.stock_enabled_flag
5021: from po_lines_all pol
5022: ,mtl_system_items_vl msi /* Bug 5581528 */

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

5015: NVL(MSI.SECONDARY_UOM_CODE,''),
5016: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5017: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5018: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5019: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5020: msi.stock_enabled_flag
5021: from po_lines_all pol
5022: ,mtl_system_items_vl msi /* Bug 5581528 */
5023: ,mtl_cross_references mcr

Line 5113: NVL(DUAL_UOM_DEVIATION_HIGH,0),

5109: NVL(LOT_DIVISIBLE_FLAG,'Y'),
5110: NVL(SECONDARY_UOM_CODE,''),
5111: NVL(SECONDARY_DEFAULT_IND,''),
5112: NVL(TRACKING_QUANTITY_IND,'P'),
5113: NVL(DUAL_UOM_DEVIATION_HIGH,0),
5114: NVL(DUAL_UOM_DEVIATION_LOW,0),
5115: stock_enabled_flag
5116: from mtl_system_items_vl /* Bug 5581528 */
5117: WHERE organization_id = p_Organization_Id

Line 5114: NVL(DUAL_UOM_DEVIATION_LOW,0),

5110: NVL(SECONDARY_UOM_CODE,''),
5111: NVL(SECONDARY_DEFAULT_IND,''),
5112: NVL(TRACKING_QUANTITY_IND,'P'),
5113: NVL(DUAL_UOM_DEVIATION_HIGH,0),
5114: NVL(DUAL_UOM_DEVIATION_LOW,0),
5115: stock_enabled_flag
5116: from mtl_system_items_vl /* Bug 5581528 */
5117: WHERE organization_id = p_Organization_Id
5118: and concatenated_segments like p_concatenated_segments

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

5186: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
5187: NVL(MSI.SECONDARY_UOM_CODE,''),
5188: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5189: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5190: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5191: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5192: msi.stock_enabled_flag
5193: from po_lines_all pol
5194: ,mtl_related_items mri

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

5187: NVL(MSI.SECONDARY_UOM_CODE,''),
5188: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5189: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5190: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5191: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5192: msi.stock_enabled_flag
5193: from po_lines_all pol
5194: ,mtl_related_items mri
5195: ,mtl_system_items_vl msi /* Bug 5581528 */

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

5271: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
5272: NVL(MSI.SECONDARY_UOM_CODE,''),
5273: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5274: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5275: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5276: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5277: msi.stock_enabled_flag
5278: from po_lines_all pol
5279: ,mtl_system_items_vl msi /* Bug 5581528 */

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

5272: NVL(MSI.SECONDARY_UOM_CODE,''),
5273: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5274: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5275: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5276: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5277: msi.stock_enabled_flag
5278: from po_lines_all pol
5279: ,mtl_system_items_vl msi /* Bug 5581528 */
5280: where organization_id = p_organization_id

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

5434: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
5435: NVL(MSI.SECONDARY_UOM_CODE,''),
5436: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5437: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5438: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5439: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5440: msi.stock_enabled_flag
5441: from po_lines_all pol
5442: ,mtl_system_items_vl msi /* Bug 5581528 */

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

5435: NVL(MSI.SECONDARY_UOM_CODE,''),
5436: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5437: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5438: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5439: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5440: msi.stock_enabled_flag
5441: from po_lines_all pol
5442: ,mtl_system_items_vl msi /* Bug 5581528 */
5443: ,mtl_cross_references mcr

Line 5533: NVL(DUAL_UOM_DEVIATION_HIGH,0),

5529: NVL(LOT_DIVISIBLE_FLAG,'Y'),
5530: NVL(SECONDARY_UOM_CODE,''),
5531: NVL(SECONDARY_DEFAULT_IND,''),
5532: NVL(TRACKING_QUANTITY_IND,'P'),
5533: NVL(DUAL_UOM_DEVIATION_HIGH,0),
5534: NVL(DUAL_UOM_DEVIATION_LOW,0),
5535: stock_enabled_flag
5536: from mtl_system_items_vl /* Bug 5581528 */
5537: WHERE organization_id = p_Organization_Id

Line 5534: NVL(DUAL_UOM_DEVIATION_LOW,0),

5530: NVL(SECONDARY_UOM_CODE,''),
5531: NVL(SECONDARY_DEFAULT_IND,''),
5532: NVL(TRACKING_QUANTITY_IND,'P'),
5533: NVL(DUAL_UOM_DEVIATION_HIGH,0),
5534: NVL(DUAL_UOM_DEVIATION_LOW,0),
5535: stock_enabled_flag
5536: from mtl_system_items_vl /* Bug 5581528 */
5537: WHERE organization_id = p_Organization_Id
5538: and concatenated_segments like p_concatenated_segments

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

5605: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
5606: NVL(MSI.SECONDARY_UOM_CODE,''),
5607: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5608: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5609: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5610: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5611: msi.stock_enabled_flag
5612: from po_lines_all pol
5613: ,mtl_related_items mri

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

5606: NVL(MSI.SECONDARY_UOM_CODE,''),
5607: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5608: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5609: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5610: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5611: msi.stock_enabled_flag
5612: from po_lines_all pol
5613: ,mtl_related_items mri
5614: ,mtl_system_items_vl msi /* Bug 5581528 */

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

5689: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
5690: NVL(MSI.SECONDARY_UOM_CODE,''),
5691: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5692: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5693: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5694: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5695: msi.stock_enabled_flag
5696: from po_lines_all pol
5697: , mtl_system_items_vl msi /* Bug 5581528 */

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

5690: NVL(MSI.SECONDARY_UOM_CODE,''),
5691: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5692: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5693: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5694: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5695: msi.stock_enabled_flag
5696: from po_lines_all pol
5697: , mtl_system_items_vl msi /* Bug 5581528 */
5698: where organization_id = p_organization_id

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

5852: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
5853: NVL(MSI.SECONDARY_UOM_CODE,''),
5854: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5855: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5856: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5857: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5858: msi.stock_enabled_flag
5859: from po_lines_all pol
5860: ,mtl_system_items_vl msi /* Bug 5581528 */

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

5853: NVL(MSI.SECONDARY_UOM_CODE,''),
5854: NVL(MSI.SECONDARY_DEFAULT_IND,''),
5855: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
5856: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
5857: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5858: msi.stock_enabled_flag
5859: from po_lines_all pol
5860: ,mtl_system_items_vl msi /* Bug 5581528 */
5861: ,mtl_cross_references mcr

Line 5962: NVL(DUAL_UOM_DEVIATION_HIGH,0),

5958: NVL(LOT_DIVISIBLE_FLAG,'Y'),
5959: NVL(SECONDARY_UOM_CODE,''),
5960: NVL(SECONDARY_DEFAULT_IND,''),
5961: NVL(TRACKING_QUANTITY_IND,'P'),
5962: NVL(DUAL_UOM_DEVIATION_HIGH,0),
5963: NVL(DUAL_UOM_DEVIATION_LOW,0),
5964: stock_enabled_flag
5965: from mtl_system_items_vl msn, /* Bug 5581528 */
5966: rcv_shipment_lines rsl

Line 5963: NVL(DUAL_UOM_DEVIATION_LOW,0),

5959: NVL(SECONDARY_UOM_CODE,''),
5960: NVL(SECONDARY_DEFAULT_IND,''),
5961: NVL(TRACKING_QUANTITY_IND,'P'),
5962: NVL(DUAL_UOM_DEVIATION_HIGH,0),
5963: NVL(DUAL_UOM_DEVIATION_LOW,0),
5964: stock_enabled_flag
5965: from mtl_system_items_vl msn, /* Bug 5581528 */
5966: rcv_shipment_lines rsl
5967: WHERE msn.organization_id = p_Organization_Id

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

6027: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
6028: NVL(MSI.SECONDARY_UOM_CODE,''),
6029: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6030: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6031: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6032: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6033: msi.stock_enabled_flag
6034: from po_lines_all pol
6035: ,mtl_system_items_vl msi /* Bug 5581528 */

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

6028: NVL(MSI.SECONDARY_UOM_CODE,''),
6029: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6030: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6031: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6032: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6033: msi.stock_enabled_flag
6034: from po_lines_all pol
6035: ,mtl_system_items_vl msi /* Bug 5581528 */
6036: , rcv_shipment_lines rsl

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

6208: NVL(MSN.LOT_DIVISIBLE_FLAG,'Y'),
6209: NVL(MSN.SECONDARY_UOM_CODE,''),
6210: NVL(MSN.SECONDARY_DEFAULT_IND,''),
6211: NVL(MSN.TRACKING_QUANTITY_IND,'P'),
6212: NVL(MSN.DUAL_UOM_DEVIATION_HIGH,0),
6213: NVL(MSN.DUAL_UOM_DEVIATION_LOW,0),
6214: msn.stock_enabled_flag
6215: from mtl_system_items_vl msn, /* Bug 5581528 */
6216: rcv_shipment_lines rsl,

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

6209: NVL(MSN.SECONDARY_UOM_CODE,''),
6210: NVL(MSN.SECONDARY_DEFAULT_IND,''),
6211: NVL(MSN.TRACKING_QUANTITY_IND,'P'),
6212: NVL(MSN.DUAL_UOM_DEVIATION_HIGH,0),
6213: NVL(MSN.DUAL_UOM_DEVIATION_LOW,0),
6214: msn.stock_enabled_flag
6215: from mtl_system_items_vl msn, /* Bug 5581528 */
6216: rcv_shipment_lines rsl,
6217: mtl_cross_references mcr

Line 6295: NVL(DUAL_UOM_DEVIATION_HIGH,0),

6291: NVL(LOT_DIVISIBLE_FLAG,'Y'),
6292: NVL(SECONDARY_UOM_CODE,''),
6293: NVL(SECONDARY_DEFAULT_IND,''),
6294: NVL(TRACKING_QUANTITY_IND,'P'),
6295: NVL(DUAL_UOM_DEVIATION_HIGH,0),
6296: NVL(DUAL_UOM_DEVIATION_LOW,0),
6297: stock_enabled_flag
6298: from mtl_system_items_vl /* Bug 5581528 */
6299: WHERE organization_id = p_Organization_Id

Line 6296: NVL(DUAL_UOM_DEVIATION_LOW,0),

6292: NVL(SECONDARY_UOM_CODE,''),
6293: NVL(SECONDARY_DEFAULT_IND,''),
6294: NVL(TRACKING_QUANTITY_IND,'P'),
6295: NVL(DUAL_UOM_DEVIATION_HIGH,0),
6296: NVL(DUAL_UOM_DEVIATION_LOW,0),
6297: stock_enabled_flag
6298: from mtl_system_items_vl /* Bug 5581528 */
6299: WHERE organization_id = p_Organization_Id
6300: and concatenated_segments like p_concatenated_segments

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

6356: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
6357: NVL(MSI.SECONDARY_UOM_CODE,''),
6358: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6359: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6360: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6361: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6362: msi.stock_enabled_flag
6363: from mtl_system_items_vl msi /* Bug 5581528 */
6364: ,mtl_cross_references mcr

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

6357: NVL(MSI.SECONDARY_UOM_CODE,''),
6358: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6359: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6360: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6361: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6362: msi.stock_enabled_flag
6363: from mtl_system_items_vl msi /* Bug 5581528 */
6364: ,mtl_cross_references mcr
6365: WHERE msi.organization_id = p_Organization_Id

Line 6440: NVL(DUAL_UOM_DEVIATION_HIGH,0),

6436: NVL(LOT_DIVISIBLE_FLAG,'Y'),
6437: NVL(SECONDARY_UOM_CODE,''),
6438: NVL(SECONDARY_DEFAULT_IND,''),
6439: NVL(TRACKING_QUANTITY_IND,'P'),
6440: NVL(DUAL_UOM_DEVIATION_HIGH,0),
6441: NVL(DUAL_UOM_DEVIATION_LOW,0),
6442: stock_enabled_flag
6443: from mtl_system_items_vl Bug 5581528
6444: WHERE organization_id = p_Organization_Id

Line 6441: NVL(DUAL_UOM_DEVIATION_LOW,0),

6437: NVL(SECONDARY_UOM_CODE,''),
6438: NVL(SECONDARY_DEFAULT_IND,''),
6439: NVL(TRACKING_QUANTITY_IND,'P'),
6440: NVL(DUAL_UOM_DEVIATION_HIGH,0),
6441: NVL(DUAL_UOM_DEVIATION_LOW,0),
6442: stock_enabled_flag
6443: from mtl_system_items_vl Bug 5581528
6444: WHERE organization_id = p_Organization_Id
6445: and concatenated_segments like p_concatenated_segments

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

6508: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
6509: NVL(MSI.SECONDARY_UOM_CODE,''),
6510: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6511: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6512: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6513: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6514: msi.stock_enabled_flag
6515: from mtl_system_items_vl msi Bug 5581528
6516: ,mtl_cross_references mcr

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

6509: NVL(MSI.SECONDARY_UOM_CODE,''),
6510: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6511: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6512: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6513: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6514: msi.stock_enabled_flag
6515: from mtl_system_items_vl msi Bug 5581528
6516: ,mtl_cross_references mcr
6517: WHERE msi.organization_id = p_Organization_Id

Line 6594: NVL(DUAL_UOM_DEVIATION_HIGH,0) ,

6590: NVL(LOT_DIVISIBLE_FLAG,'Y') ,
6591: NVL(SECONDARY_UOM_CODE,'') ,
6592: NVL(SECONDARY_DEFAULT_IND,'') ,
6593: NVL(TRACKING_QUANTITY_IND,'P') ,
6594: NVL(DUAL_UOM_DEVIATION_HIGH,0) ,
6595: NVL(DUAL_UOM_DEVIATION_LOW,0) ,
6596: stock_enabled_flag
6597: FROM mtl_system_items_vl,
6598: /* Bug 5581528 */

Line 6595: NVL(DUAL_UOM_DEVIATION_LOW,0) ,

6591: NVL(SECONDARY_UOM_CODE,'') ,
6592: NVL(SECONDARY_DEFAULT_IND,'') ,
6593: NVL(TRACKING_QUANTITY_IND,'P') ,
6594: NVL(DUAL_UOM_DEVIATION_HIGH,0) ,
6595: NVL(DUAL_UOM_DEVIATION_LOW,0) ,
6596: stock_enabled_flag
6597: FROM mtl_system_items_vl,
6598: /* Bug 5581528 */
6599: (

Line 6674: NVL(DUAL_UOM_DEVIATION_HIGH,0) ,

6670: NVL(LOT_DIVISIBLE_FLAG,'Y') ,
6671: NVL(SECONDARY_UOM_CODE,'') ,
6672: NVL(SECONDARY_DEFAULT_IND,'') ,
6673: NVL(TRACKING_QUANTITY_IND,'P') ,
6674: NVL(DUAL_UOM_DEVIATION_HIGH,0) ,
6675: NVL(DUAL_UOM_DEVIATION_LOW,0) ,
6676: stock_enabled_flag
6677: FROM mtl_system_items_vl,
6678: /* Bug 5581528 */

Line 6675: NVL(DUAL_UOM_DEVIATION_LOW,0) ,

6671: NVL(SECONDARY_UOM_CODE,'') ,
6672: NVL(SECONDARY_DEFAULT_IND,'') ,
6673: NVL(TRACKING_QUANTITY_IND,'P') ,
6674: NVL(DUAL_UOM_DEVIATION_HIGH,0) ,
6675: NVL(DUAL_UOM_DEVIATION_LOW,0) ,
6676: stock_enabled_flag
6677: FROM mtl_system_items_vl,
6678: /* Bug 5581528 */
6679: (

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

6744: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y') ,
6745: NVL(MSI.SECONDARY_UOM_CODE,'') ,
6746: NVL(MSI.SECONDARY_DEFAULT_IND,'') ,
6747: NVL(MSI.TRACKING_QUANTITY_IND,'P') ,
6748: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0) ,
6749: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0) ,
6750: msi.stock_enabled_flag
6751: FROM mtl_system_items_vl msi
6752: /* Bug 5581528 */

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

6745: NVL(MSI.SECONDARY_UOM_CODE,'') ,
6746: NVL(MSI.SECONDARY_DEFAULT_IND,'') ,
6747: NVL(MSI.TRACKING_QUANTITY_IND,'P') ,
6748: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0) ,
6749: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0) ,
6750: msi.stock_enabled_flag
6751: FROM mtl_system_items_vl msi
6752: /* Bug 5581528 */
6753: ,

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

6846: NVL(msi.LOT_DIVISIBLE_FLAG,'Y'),
6847: NVL(msi.SECONDARY_UOM_CODE,''),
6848: NVL(msi.SECONDARY_DEFAULT_IND,''),
6849: NVL(msi.TRACKING_QUANTITY_IND,'P'),
6850: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
6851: NVL(msi.DUAL_UOM_DEVIATION_LOW,0),
6852: msi.stock_enabled_flag
6853: FROM
6854: mtl_system_items_vl msi /* Bug 5581528 */

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

6847: NVL(msi.SECONDARY_UOM_CODE,''),
6848: NVL(msi.SECONDARY_DEFAULT_IND,''),
6849: NVL(msi.TRACKING_QUANTITY_IND,'P'),
6850: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
6851: NVL(msi.DUAL_UOM_DEVIATION_LOW,0),
6852: msi.stock_enabled_flag
6853: FROM
6854: mtl_system_items_vl msi /* Bug 5581528 */
6855: WHERE msi.organization_id = p_organization_Id

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

6904: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
6905: NVL(MSI.SECONDARY_UOM_CODE,''),
6906: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6907: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6908: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6909: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6910: msi.stock_enabled_flag
6911: FROM
6912: mtl_system_items_vl msi /* Bug 5581528 */

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

6905: NVL(MSI.SECONDARY_UOM_CODE,''),
6906: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6907: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6908: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6909: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6910: msi.stock_enabled_flag
6911: FROM
6912: mtl_system_items_vl msi /* Bug 5581528 */
6913: WHERE msi.organization_id = p_organization_Id

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

6988: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
6989: NVL(MSI.SECONDARY_UOM_CODE,''),
6990: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6991: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6992: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6993: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6994: msi.stock_enabled_flag
6995: FROM
6996: po_lines_all pol,

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

6989: NVL(MSI.SECONDARY_UOM_CODE,''),
6990: NVL(MSI.SECONDARY_DEFAULT_IND,''),
6991: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
6992: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6993: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6994: msi.stock_enabled_flag
6995: FROM
6996: po_lines_all pol,
6997: mtl_system_items_vl msi /* Bug 5581528 */

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

7065: NVL(MSI.LOT_DIVISIBLE_FLAG,'Y'),
7066: NVL(MSI.SECONDARY_UOM_CODE,''),
7067: NVL(MSI.SECONDARY_DEFAULT_IND,''),
7068: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
7069: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
7070: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
7071: msi.stock_enabled_flag
7072: FROM
7073: mtl_system_items_vl msi, /* Bug 5581528 */

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

7066: NVL(MSI.SECONDARY_UOM_CODE,''),
7067: NVL(MSI.SECONDARY_DEFAULT_IND,''),
7068: NVL(MSI.TRACKING_QUANTITY_IND,'P'),
7069: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
7070: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
7071: msi.stock_enabled_flag
7072: FROM
7073: mtl_system_items_vl msi, /* Bug 5581528 */
7074: mtl_cross_references mcr

Line 7225: NVL(DUAL_UOM_DEVIATION_HIGH,0),

7221: NVL(LOT_DIVISIBLE_FLAG,'Y'),
7222: NVL(SECONDARY_UOM_CODE,''),
7223: NVL(SECONDARY_DEFAULT_IND,''),
7224: NVL(TRACKING_QUANTITY_IND,'P'),
7225: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7226: NVL(DUAL_UOM_DEVIATION_LOW,0)
7227: from mtl_system_items_vl
7228: WHERE organization_id = p_Organization_Id
7229: and concatenated_segments like p_concatenated_segments

Line 7226: NVL(DUAL_UOM_DEVIATION_LOW,0)

7222: NVL(SECONDARY_UOM_CODE,''),
7223: NVL(SECONDARY_DEFAULT_IND,''),
7224: NVL(TRACKING_QUANTITY_IND,'P'),
7225: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7226: NVL(DUAL_UOM_DEVIATION_LOW,0)
7227: from mtl_system_items_vl
7228: WHERE organization_id = p_Organization_Id
7229: and concatenated_segments like p_concatenated_segments
7230: and mtl_transactions_enabled_flag = 'Y'

Line 7278: NVL(DUAL_UOM_DEVIATION_HIGH,0),

7274: NVL(LOT_DIVISIBLE_FLAG,'Y'),
7275: NVL(SECONDARY_UOM_CODE,''),
7276: NVL(SECONDARY_DEFAULT_IND,''),
7277: NVL(TRACKING_QUANTITY_IND,'P'),
7278: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7279: NVL(DUAL_UOM_DEVIATION_LOW,0)
7280: from mtl_system_items_vl msik, /* Bug 5581528 */
7281: mtl_cross_references mcr
7282: WHERE msik.organization_id = p_Organization_Id

Line 7279: NVL(DUAL_UOM_DEVIATION_LOW,0)

7275: NVL(SECONDARY_UOM_CODE,''),
7276: NVL(SECONDARY_DEFAULT_IND,''),
7277: NVL(TRACKING_QUANTITY_IND,'P'),
7278: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7279: NVL(DUAL_UOM_DEVIATION_LOW,0)
7280: from mtl_system_items_vl msik, /* Bug 5581528 */
7281: mtl_cross_references mcr
7282: WHERE msik.organization_id = p_Organization_Id
7283: AND msik.inventory_item_id = mcr.inventory_item_id

Line 7542: NVL(DUAL_UOM_DEVIATION_HIGH,0),

7538: NVL(LOT_DIVISIBLE_FLAG,'Y'),
7539: NVL(SECONDARY_UOM_CODE,''),
7540: NVL(SECONDARY_DEFAULT_IND,''),
7541: NVL(TRACKING_QUANTITY_IND,'P'),
7542: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7543: NVL(DUAL_UOM_DEVIATION_LOW,0)
7544: FROM
7545: mtl_system_items_vl msik /* Bug 5581528 */
7546: WHERE

Line 7543: NVL(DUAL_UOM_DEVIATION_LOW,0)

7539: NVL(SECONDARY_UOM_CODE,''),
7540: NVL(SECONDARY_DEFAULT_IND,''),
7541: NVL(TRACKING_QUANTITY_IND,'P'),
7542: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7543: NVL(DUAL_UOM_DEVIATION_LOW,0)
7544: FROM
7545: mtl_system_items_vl msik /* Bug 5581528 */
7546: WHERE
7547: organization_id = p_Organization_Id

Line 7601: NVL(DUAL_UOM_DEVIATION_HIGH,0),

7597: NVL(LOT_DIVISIBLE_FLAG,'Y'),
7598: NVL(SECONDARY_UOM_CODE,''),
7599: NVL(SECONDARY_DEFAULT_IND,''),
7600: NVL(TRACKING_QUANTITY_IND,'P'),
7601: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7602: NVL(DUAL_UOM_DEVIATION_LOW,0)
7603: FROM
7604: mtl_system_items_vl msik, /* Bug 5581528 */
7605: mtl_cross_references mcr

Line 7602: NVL(DUAL_UOM_DEVIATION_LOW,0)

7598: NVL(SECONDARY_UOM_CODE,''),
7599: NVL(SECONDARY_DEFAULT_IND,''),
7600: NVL(TRACKING_QUANTITY_IND,'P'),
7601: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7602: NVL(DUAL_UOM_DEVIATION_LOW,0)
7603: FROM
7604: mtl_system_items_vl msik, /* Bug 5581528 */
7605: mtl_cross_references mcr
7606: WHERE

Line 7668: NVL(DUAL_UOM_DEVIATION_HIGH,0),

7664: NVL(LOT_DIVISIBLE_FLAG,'Y'),
7665: NVL(SECONDARY_UOM_CODE,''),
7666: NVL(SECONDARY_DEFAULT_IND,''),
7667: NVL(TRACKING_QUANTITY_IND,'P'),
7668: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7669: NVL(DUAL_UOM_DEVIATION_LOW,0)
7670: FROM
7671: mtl_system_items_vl msik /* Bug 5581528 */
7672: WHERE

Line 7669: NVL(DUAL_UOM_DEVIATION_LOW,0)

7665: NVL(SECONDARY_UOM_CODE,''),
7666: NVL(SECONDARY_DEFAULT_IND,''),
7667: NVL(TRACKING_QUANTITY_IND,'P'),
7668: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7669: NVL(DUAL_UOM_DEVIATION_LOW,0)
7670: FROM
7671: mtl_system_items_vl msik /* Bug 5581528 */
7672: WHERE
7673: organization_id = p_Organization_Id

Line 7722: NVL(DUAL_UOM_DEVIATION_HIGH,0),

7718: NVL(LOT_DIVISIBLE_FLAG,'Y'),
7719: NVL(SECONDARY_UOM_CODE,''),
7720: NVL(SECONDARY_DEFAULT_IND,''),
7721: NVL(TRACKING_QUANTITY_IND,'P'),
7722: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7723: NVL(DUAL_UOM_DEVIATION_LOW,0)
7724: FROM
7725: mtl_system_items_vl msik, /* Bug 5581528 */
7726: mtl_cross_references mcr

Line 7723: NVL(DUAL_UOM_DEVIATION_LOW,0)

7719: NVL(SECONDARY_UOM_CODE,''),
7720: NVL(SECONDARY_DEFAULT_IND,''),
7721: NVL(TRACKING_QUANTITY_IND,'P'),
7722: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7723: NVL(DUAL_UOM_DEVIATION_LOW,0)
7724: FROM
7725: mtl_system_items_vl msik, /* Bug 5581528 */
7726: mtl_cross_references mcr
7727: WHERE

Line 7783: NVL(DUAL_UOM_DEVIATION_HIGH,0),

7779: NVL(LOT_DIVISIBLE_FLAG,'Y'),
7780: NVL(SECONDARY_UOM_CODE,''),
7781: NVL(SECONDARY_DEFAULT_IND,''),
7782: NVL(TRACKING_QUANTITY_IND,'P'),
7783: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7784: NVL(DUAL_UOM_DEVIATION_LOW,0)
7785: FROM
7786: mtl_system_items_vl msik /* Bug 5581528 */
7787: WHERE

Line 7784: NVL(DUAL_UOM_DEVIATION_LOW,0)

7780: NVL(SECONDARY_UOM_CODE,''),
7781: NVL(SECONDARY_DEFAULT_IND,''),
7782: NVL(TRACKING_QUANTITY_IND,'P'),
7783: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7784: NVL(DUAL_UOM_DEVIATION_LOW,0)
7785: FROM
7786: mtl_system_items_vl msik /* Bug 5581528 */
7787: WHERE
7788: organization_id = p_Organization_Id

Line 7837: NVL(DUAL_UOM_DEVIATION_HIGH,0),

7833: NVL(LOT_DIVISIBLE_FLAG,'Y'),
7834: NVL(SECONDARY_UOM_CODE,''),
7835: NVL(SECONDARY_DEFAULT_IND,''),
7836: NVL(TRACKING_QUANTITY_IND,'P'),
7837: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7838: NVL(DUAL_UOM_DEVIATION_LOW,0)
7839: FROM
7840: mtl_system_items_vl msik, /* Bug 5581528 */
7841: mtl_cross_references mcr

Line 7838: NVL(DUAL_UOM_DEVIATION_LOW,0)

7834: NVL(SECONDARY_UOM_CODE,''),
7835: NVL(SECONDARY_DEFAULT_IND,''),
7836: NVL(TRACKING_QUANTITY_IND,'P'),
7837: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7838: NVL(DUAL_UOM_DEVIATION_LOW,0)
7839: FROM
7840: mtl_system_items_vl msik, /* Bug 5581528 */
7841: mtl_cross_references mcr
7842: WHERE

Line 7898: NVL(DUAL_UOM_DEVIATION_HIGH,0),

7894: NVL(LOT_DIVISIBLE_FLAG,'Y'),
7895: NVL(SECONDARY_UOM_CODE,''),
7896: NVL(SECONDARY_DEFAULT_IND,''),
7897: NVL(TRACKING_QUANTITY_IND,'P'),
7898: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7899: NVL(DUAL_UOM_DEVIATION_LOW,0)
7900: FROM
7901: mtl_system_items_vl msik /* Bug 5581528 */
7902: WHERE

Line 7899: NVL(DUAL_UOM_DEVIATION_LOW,0)

7895: NVL(SECONDARY_UOM_CODE,''),
7896: NVL(SECONDARY_DEFAULT_IND,''),
7897: NVL(TRACKING_QUANTITY_IND,'P'),
7898: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7899: NVL(DUAL_UOM_DEVIATION_LOW,0)
7900: FROM
7901: mtl_system_items_vl msik /* Bug 5581528 */
7902: WHERE
7903: organization_id = p_Organization_Id

Line 7952: NVL(DUAL_UOM_DEVIATION_HIGH,0),

7948: NVL(LOT_DIVISIBLE_FLAG,'Y'),
7949: NVL(SECONDARY_UOM_CODE,''),
7950: NVL(SECONDARY_DEFAULT_IND,''),
7951: NVL(TRACKING_QUANTITY_IND,'P'),
7952: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7953: NVL(DUAL_UOM_DEVIATION_LOW,0)
7954: FROM
7955: mtl_system_items_vl msik, /* Bug 5581528 */
7956: mtl_cross_references mcr

Line 7953: NVL(DUAL_UOM_DEVIATION_LOW,0)

7949: NVL(SECONDARY_UOM_CODE,''),
7950: NVL(SECONDARY_DEFAULT_IND,''),
7951: NVL(TRACKING_QUANTITY_IND,'P'),
7952: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7953: NVL(DUAL_UOM_DEVIATION_LOW,0)
7954: FROM
7955: mtl_system_items_vl msik, /* Bug 5581528 */
7956: mtl_cross_references mcr
7957: WHERE

Line 8014: NVL(DUAL_UOM_DEVIATION_HIGH,0),

8010: NVL(LOT_DIVISIBLE_FLAG,'Y'),
8011: NVL(SECONDARY_UOM_CODE,''),
8012: NVL(SECONDARY_DEFAULT_IND,''),
8013: NVL(TRACKING_QUANTITY_IND,'P'),
8014: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8015: NVL(DUAL_UOM_DEVIATION_LOW,0)
8016: FROM
8017: mtl_system_items_vl msik /* Bug 5581528 */
8018: WHERE

Line 8015: NVL(DUAL_UOM_DEVIATION_LOW,0)

8011: NVL(SECONDARY_UOM_CODE,''),
8012: NVL(SECONDARY_DEFAULT_IND,''),
8013: NVL(TRACKING_QUANTITY_IND,'P'),
8014: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8015: NVL(DUAL_UOM_DEVIATION_LOW,0)
8016: FROM
8017: mtl_system_items_vl msik /* Bug 5581528 */
8018: WHERE
8019: organization_id = p_Organization_Id

Line 8068: NVL(DUAL_UOM_DEVIATION_HIGH,0),

8064: NVL(LOT_DIVISIBLE_FLAG,'Y'),
8065: NVL(SECONDARY_UOM_CODE,''),
8066: NVL(SECONDARY_DEFAULT_IND,''),
8067: NVL(TRACKING_QUANTITY_IND,'P'),
8068: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8069: NVL(DUAL_UOM_DEVIATION_LOW,0)
8070: FROM
8071: mtl_system_items_vl msik, /* Bug 5581528 */
8072: mtl_cross_references mcr

Line 8069: NVL(DUAL_UOM_DEVIATION_LOW,0)

8065: NVL(SECONDARY_UOM_CODE,''),
8066: NVL(SECONDARY_DEFAULT_IND,''),
8067: NVL(TRACKING_QUANTITY_IND,'P'),
8068: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8069: NVL(DUAL_UOM_DEVIATION_LOW,0)
8070: FROM
8071: mtl_system_items_vl msik, /* Bug 5581528 */
8072: mtl_cross_references mcr
8073: WHERE

Line 8129: NVL(DUAL_UOM_DEVIATION_HIGH,0),

8125: NVL(LOT_DIVISIBLE_FLAG,'Y'),
8126: NVL(SECONDARY_UOM_CODE,''),
8127: NVL(SECONDARY_DEFAULT_IND,''),
8128: NVL(TRACKING_QUANTITY_IND,'P'),
8129: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8130: NVL(DUAL_UOM_DEVIATION_LOW,0)
8131: FROM
8132: mtl_system_items_vl msik /* Bug 5581528 */
8133: WHERE

Line 8130: NVL(DUAL_UOM_DEVIATION_LOW,0)

8126: NVL(SECONDARY_UOM_CODE,''),
8127: NVL(SECONDARY_DEFAULT_IND,''),
8128: NVL(TRACKING_QUANTITY_IND,'P'),
8129: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8130: NVL(DUAL_UOM_DEVIATION_LOW,0)
8131: FROM
8132: mtl_system_items_vl msik /* Bug 5581528 */
8133: WHERE
8134: organization_id = p_Organization_Id

Line 8183: NVL(DUAL_UOM_DEVIATION_HIGH,0),

8179: NVL(LOT_DIVISIBLE_FLAG,'Y'),
8180: NVL(SECONDARY_UOM_CODE,''),
8181: NVL(SECONDARY_DEFAULT_IND,''),
8182: NVL(TRACKING_QUANTITY_IND,'P'),
8183: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8184: NVL(DUAL_UOM_DEVIATION_LOW,0)
8185: FROM
8186: mtl_system_items_vl msik, /* Bug 5581528 */
8187: mtl_cross_references mcr

Line 8184: NVL(DUAL_UOM_DEVIATION_LOW,0)

8180: NVL(SECONDARY_UOM_CODE,''),
8181: NVL(SECONDARY_DEFAULT_IND,''),
8182: NVL(TRACKING_QUANTITY_IND,'P'),
8183: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8184: NVL(DUAL_UOM_DEVIATION_LOW,0)
8185: FROM
8186: mtl_system_items_vl msik, /* Bug 5581528 */
8187: mtl_cross_references mcr
8188: WHERE

Line 8244: NVL(DUAL_UOM_DEVIATION_HIGH,0),

8240: NVL(LOT_DIVISIBLE_FLAG,'Y'),
8241: NVL(SECONDARY_UOM_CODE,''),
8242: NVL(SECONDARY_DEFAULT_IND,''),
8243: NVL(TRACKING_QUANTITY_IND,'P'),
8244: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8245: NVL(DUAL_UOM_DEVIATION_LOW,0)
8246: FROM
8247: mtl_system_items_vl msik /* Bug 5581528 */
8248: WHERE

Line 8245: NVL(DUAL_UOM_DEVIATION_LOW,0)

8241: NVL(SECONDARY_UOM_CODE,''),
8242: NVL(SECONDARY_DEFAULT_IND,''),
8243: NVL(TRACKING_QUANTITY_IND,'P'),
8244: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8245: NVL(DUAL_UOM_DEVIATION_LOW,0)
8246: FROM
8247: mtl_system_items_vl msik /* Bug 5581528 */
8248: WHERE
8249: organization_id = p_Organization_Id

Line 8298: NVL(DUAL_UOM_DEVIATION_HIGH,0),

8294: NVL(LOT_DIVISIBLE_FLAG,'Y'),
8295: NVL(SECONDARY_UOM_CODE,''),
8296: NVL(SECONDARY_DEFAULT_IND,''),
8297: NVL(TRACKING_QUANTITY_IND,'P'),
8298: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8299: NVL(DUAL_UOM_DEVIATION_LOW,0)
8300: FROM
8301: mtl_system_items_vl msik, /* Bug 5581528 */
8302: mtl_cross_references mcr

Line 8299: NVL(DUAL_UOM_DEVIATION_LOW,0)

8295: NVL(SECONDARY_UOM_CODE,''),
8296: NVL(SECONDARY_DEFAULT_IND,''),
8297: NVL(TRACKING_QUANTITY_IND,'P'),
8298: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8299: NVL(DUAL_UOM_DEVIATION_LOW,0)
8300: FROM
8301: mtl_system_items_vl msik, /* Bug 5581528 */
8302: mtl_cross_references mcr
8303: WHERE