DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on INV_CONVERT

Line 1496: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 1506: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 1548: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 1892: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 1902: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 1944: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 2292: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 2302: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 2345: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 2768: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 2778: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 2820: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 3210: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 3220: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 3262: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 4691: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 4701: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 4743: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 5677: inv_convert.INV_UM_CONVERT(bsc.substitute_component_id,

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,

Line 5820: inv_convert.INV_UM_CONVERT(bsc.substitute_component_id,

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,

Line 7720: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 7730: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 7772: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 8089: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 8099: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 8141: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 8455: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 8465: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 8507: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 8866: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 8876: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 8919: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 9266: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 9276: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 9318: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

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,

Line 11239: inv_convert.INV_UM_CONVERT(bsc.substitute_component_id,

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,