1492: --bic.high_quantity,
1493: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
1494: AA.primary_unit_of_measure,BIC.low_quantity,
1495: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
1496: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
1497: NULL,
1498: BIC.low_quantity,
1499: NULL,
1500: NULL,
1502: MSI.primary_unit_of_measure))) Comp_low_qty,
1503: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
1504: AA.primary_unit_of_measure,BIC.high_quantity,
1505: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
1506: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
1507: NULL,
1508: BIC.high_quantity,
1509: NULL,
1510: NULL,
1544: bic.item_num,
1545: --bic.component_quantity,
1546: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
1547: AA.primary_unit_of_measure,BIC.component_quantity,
1548: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
1549: NULL,
1550: BIC.component_quantity,
1551: NULL,
1552: NULL,
1888: --bic.high_quantity, -- Commented for bug-6510185
1889: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
1890: AA.primary_unit_of_measure,BIC.low_quantity,
1891: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
1892: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
1893: NULL,
1894: BIC.low_quantity,
1895: NULL,
1896: NULL,
1898: MSI.primary_unit_of_measure))) Comp_low_qty,
1899: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
1900: AA.primary_unit_of_measure,BIC.high_quantity,
1901: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
1902: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
1903: NULL,
1904: BIC.high_quantity,
1905: NULL,
1906: NULL,
1940: bic.item_num,
1941: --bic.component_quantity,
1942: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
1943: AA.primary_unit_of_measure,BIC.component_quantity,
1944: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
1945: NULL,
1946: BIC.component_quantity,
1947: NULL,
1948: NULL,
2288: --bic.high_quantity, -- Commented for bug-6510185
2289: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
2290: AA.primary_unit_of_measure,BIC.low_quantity,
2291: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
2292: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
2293: NULL,
2294: BIC.low_quantity,
2295: NULL,
2296: NULL,
2298: MSI.primary_unit_of_measure))) Comp_low_qty,
2299: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
2300: AA.primary_unit_of_measure,BIC.high_quantity,
2301: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
2302: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
2303: NULL,
2304: BIC.high_quantity,
2305: NULL,
2306: NULL,
2341: bic.item_num,
2342: --bic.component_quantity,
2343: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
2344: AA.primary_unit_of_measure,BIC.component_quantity,
2345: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
2346: NULL,
2347: BIC.component_quantity,
2348: NULL,
2349: NULL,
2764: --bic.high_quantity,
2765: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
2766: AA.primary_unit_of_measure,BIC.low_quantity,
2767: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
2768: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
2769: NULL,
2770: BIC.low_quantity,
2771: NULL,
2772: NULL,
2774: MSI.primary_unit_of_measure))) Comp_low_qty,
2775: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
2776: AA.primary_unit_of_measure,BIC.high_quantity,
2777: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
2778: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
2779: NULL,
2780: BIC.high_quantity,
2781: NULL,
2782: NULL,
2816: bic.item_num,
2817: -- bic.component_quantity,
2818: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
2819: AA.primary_unit_of_measure,BIC.component_quantity,
2820: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
2821: NULL,
2822: BIC.component_quantity,
2823: NULL,
2824: NULL,
3206: -- bic.high_quantity,
3207: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
3208: AA.primary_unit_of_measure,BIC.low_quantity,
3209: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
3210: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
3211: NULL,
3212: BIC.low_quantity,
3213: NULL,
3214: NULL,
3216: MSI.primary_unit_of_measure))) Comp_low_qty,
3217: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
3218: AA.primary_unit_of_measure,BIC.high_quantity,
3219: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
3220: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
3221: NULL,
3222: BIC.high_quantity,
3223: NULL,
3224: NULL,
3258: bic.item_num,
3259: --bic.component_quantity,
3260: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
3261: AA.primary_unit_of_measure,BIC.component_quantity,
3262: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
3263: NULL,
3264: BIC.component_quantity,
3265: NULL,
3266: NULL,
4687: -- high_quantity,
4688: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
4689: AA.primary_unit_of_measure,BIC.low_quantity,
4690: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
4691: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
4692: NULL,
4693: BIC.low_quantity,
4694: NULL,
4695: NULL,
4697: MSI.primary_unit_of_measure))) Comp_low_qty,
4698: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
4699: AA.primary_unit_of_measure,BIC.high_quantity,
4700: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
4701: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
4702: NULL,
4703: BIC.high_quantity,
4704: NULL,
4705: NULL,
4739: item_num,
4740: -- component_quantity,
4741: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
4742: AA.primary_unit_of_measure,BIC.component_quantity,
4743: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
4744: NULL,
4745: BIC.component_quantity,
4746: NULL,
4747: NULL,
5673: NULL,
5674: --substitute_item_quantity,
5675: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
5676: AA.primary_unit_of_measure,Bsc.substitute_item_quantity,
5677: inv_convert.INV_UM_CONVERT(bsc.substitute_component_id,
5678: NULL,
5679: Bsc.substitute_item_quantity,
5680: NULL,
5681: NULL,
5816: NULL,
5817: --substitute_item_quantity,
5818: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
5819: AA.primary_unit_of_measure,Bsc.substitute_item_quantity,
5820: inv_convert.INV_UM_CONVERT(bsc.substitute_component_id,
5821: NULL,
5822: Bsc.substitute_item_quantity,
5823: NULL,
5824: NULL,
7716: -- bic.high_quantity,
7717: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
7718: AA.primary_unit_of_measure,BIC.low_quantity,
7719: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
7720: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
7721: NULL,
7722: BIC.low_quantity,
7723: NULL,
7724: NULL,
7726: MSI.primary_unit_of_measure))) Comp_low_qty,
7727: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
7728: AA.primary_unit_of_measure,BIC.high_quantity,
7729: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
7730: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
7731: NULL,
7732: BIC.high_quantity,
7733: NULL,
7734: NULL,
7768: bic.item_num,
7769: -- bic.component_quantity,
7770: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
7771: AA.primary_unit_of_measure,BIC.component_quantity,
7772: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
7773: NULL,
7774: BIC.component_quantity,
7775: NULL,
7776: NULL,
8085: --bic.high_quantity,
8086: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
8087: AA.primary_unit_of_measure,BIC.low_quantity,
8088: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
8089: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
8090: NULL,
8091: BIC.low_quantity,
8092: NULL,
8093: NULL,
8095: MSI.primary_unit_of_measure))) Comp_low_qty,
8096: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
8097: AA.primary_unit_of_measure,BIC.high_quantity,
8098: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
8099: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
8100: NULL,
8101: BIC.high_quantity,
8102: NULL,
8103: NULL,
8137: bic.item_num,
8138: -- bic.component_quantity,
8139: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
8140: AA.primary_unit_of_measure,BIC.component_quantity,
8141: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
8142: NULL,
8143: BIC.component_quantity,
8144: NULL,
8145: NULL,
8451: --bic.high_quantity,
8452: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
8453: AA.primary_unit_of_measure,BIC.low_quantity,
8454: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
8455: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
8456: NULL,
8457: BIC.low_quantity,
8458: NULL,
8459: NULL,
8461: MSI.primary_unit_of_measure))) Comp_low_qty,
8462: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
8463: AA.primary_unit_of_measure,BIC.high_quantity,
8464: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
8465: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
8466: NULL,
8467: BIC.high_quantity,
8468: NULL,
8469: NULL,
8503: bic.item_num,
8504: --bic.component_quantity,
8505: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
8506: AA.primary_unit_of_measure,BIC.component_quantity,
8507: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
8508: NULL,
8509: BIC.component_quantity,
8510: NULL,
8511: NULL,
8862: --bic.high_quantity,
8863: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
8864: AA.primary_unit_of_measure,BIC.low_quantity,
8865: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
8866: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
8867: NULL,
8868: BIC.low_quantity,
8869: NULL,
8870: NULL,
8872: MSI.primary_unit_of_measure))) Comp_low_qty,
8873: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
8874: AA.primary_unit_of_measure,BIC.high_quantity,
8875: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
8876: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
8877: NULL,
8878: BIC.high_quantity,
8879: NULL,
8880: NULL,
8915: bic.item_num,
8916: --bic.component_quantity,
8917: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
8918: AA.primary_unit_of_measure,BIC.component_quantity,
8919: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
8920: NULL,
8921: BIC.component_quantity,
8922: NULL,
8923: NULL,
9262: -- bic.high_quantity,
9263: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
9264: AA.primary_unit_of_measure,BIC.low_quantity,
9265: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
9266: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
9267: NULL,
9268: BIC.low_quantity,
9269: NULL,
9270: NULL,
9272: MSI.primary_unit_of_measure))) Comp_low_qty,
9273: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
9274: AA.primary_unit_of_measure,BIC.high_quantity,
9275: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
9276: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
9277: NULL,
9278: BIC.high_quantity,
9279: NULL,
9280: NULL,
9314: bic.item_num,
9315: --bic.component_quantity,
9316: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
9317: AA.primary_unit_of_measure,BIC.component_quantity,
9318: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
9319: NULL,
9320: BIC.component_quantity,
9321: NULL,
9322: NULL,
11235: NULL,
11236: --substitute_item_quantity,
11237: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
11238: AA.primary_unit_of_measure,Bsc.substitute_item_quantity,
11239: inv_convert.INV_UM_CONVERT(bsc.substitute_component_id,
11240: NULL,
11241: Bsc.substitute_item_quantity,
11242: NULL,
11243: NULL,