DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on INV_CONVERT

Line 1548: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

1544: --bic.high_quantity,
1545: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
1546: AA.primary_unit_of_measure,BIC.low_quantity,
1547: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
1548: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
1549: NULL,
1550: BIC.low_quantity,
1551: NULL,
1552: NULL,

Line 1558: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

1554: MSI.primary_unit_of_measure))) Comp_low_qty,
1555: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
1556: AA.primary_unit_of_measure,BIC.high_quantity,
1557: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
1558: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
1559: NULL,
1560: BIC.high_quantity,
1561: NULL,
1562: NULL,

Line 1600: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

1596: bic.item_num,
1597: --bic.component_quantity,
1598: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
1599: AA.primary_unit_of_measure,BIC.component_quantity,
1600: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
1601: NULL,
1602: BIC.component_quantity,
1603: NULL,
1604: NULL,

Line 1945: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

1941: --bic.high_quantity, -- Commented for bug-6510185
1942: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
1943: AA.primary_unit_of_measure,BIC.low_quantity,
1944: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
1945: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
1946: NULL,
1947: BIC.low_quantity,
1948: NULL,
1949: NULL,

Line 1955: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

1951: MSI.primary_unit_of_measure))) Comp_low_qty,
1952: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
1953: AA.primary_unit_of_measure,BIC.high_quantity,
1954: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
1955: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
1956: NULL,
1957: BIC.high_quantity,
1958: NULL,
1959: NULL,

Line 1997: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

1993: bic.item_num,
1994: --bic.component_quantity,
1995: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
1996: AA.primary_unit_of_measure,BIC.component_quantity,
1997: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
1998: NULL,
1999: BIC.component_quantity,
2000: NULL,
2001: NULL,

Line 2345: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

2341: --bic.high_quantity, -- Commented for bug-6510185
2342: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
2343: AA.primary_unit_of_measure,BIC.low_quantity,
2344: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
2345: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
2346: NULL,
2347: BIC.low_quantity,
2348: NULL,
2349: NULL,

Line 2355: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

2351: MSI.primary_unit_of_measure))) Comp_low_qty,
2352: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
2353: AA.primary_unit_of_measure,BIC.high_quantity,
2354: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
2355: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
2356: NULL,
2357: BIC.high_quantity,
2358: NULL,
2359: NULL,

Line 2398: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

2394: bic.item_num,
2395: --bic.component_quantity,
2396: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
2397: AA.primary_unit_of_measure,BIC.component_quantity,
2398: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
2399: NULL,
2400: BIC.component_quantity,
2401: NULL,
2402: NULL,

Line 2821: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

2817: --bic.high_quantity,
2818: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
2819: AA.primary_unit_of_measure,BIC.low_quantity,
2820: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
2821: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
2822: NULL,
2823: BIC.low_quantity,
2824: NULL,
2825: NULL,

Line 2831: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

2827: MSI.primary_unit_of_measure))) Comp_low_qty,
2828: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
2829: AA.primary_unit_of_measure,BIC.high_quantity,
2830: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
2831: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
2832: NULL,
2833: BIC.high_quantity,
2834: NULL,
2835: NULL,

Line 2873: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

2869: bic.item_num,
2870: -- bic.component_quantity,
2871: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
2872: AA.primary_unit_of_measure,BIC.component_quantity,
2873: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
2874: NULL,
2875: BIC.component_quantity,
2876: NULL,
2877: NULL,

Line 3264: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

3260: -- bic.high_quantity,
3261: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
3262: AA.primary_unit_of_measure,BIC.low_quantity,
3263: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
3264: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
3265: NULL,
3266: BIC.low_quantity,
3267: NULL,
3268: NULL,

Line 3274: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

3270: MSI.primary_unit_of_measure))) Comp_low_qty,
3271: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
3272: AA.primary_unit_of_measure,BIC.high_quantity,
3273: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
3274: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
3275: NULL,
3276: BIC.high_quantity,
3277: NULL,
3278: NULL,

Line 3316: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

3312: bic.item_num,
3313: --bic.component_quantity,
3314: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
3315: AA.primary_unit_of_measure,BIC.component_quantity,
3316: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
3317: NULL,
3318: BIC.component_quantity,
3319: NULL,
3320: NULL,

Line 4753: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

4749: -- high_quantity,
4750: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
4751: AA.primary_unit_of_measure,BIC.low_quantity,
4752: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
4753: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
4754: NULL,
4755: BIC.low_quantity,
4756: NULL,
4757: NULL,

Line 4763: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

4759: MSI.primary_unit_of_measure))) Comp_low_qty,
4760: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
4761: AA.primary_unit_of_measure,BIC.high_quantity,
4762: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
4763: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
4764: NULL,
4765: BIC.high_quantity,
4766: NULL,
4767: NULL,

Line 4805: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

4801: item_num,
4802: -- component_quantity,
4803: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
4804: AA.primary_unit_of_measure,BIC.component_quantity,
4805: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
4806: NULL,
4807: BIC.component_quantity,
4808: NULL,
4809: NULL,

Line 5768: inv_convert.INV_UM_CONVERT(bsc.substitute_component_id,

5764: /*NULL comment for bug8431772,change NULL to user_id*/user_id,
5765: --substitute_item_quantity,
5766: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
5767: AA.primary_unit_of_measure,Bsc.substitute_item_quantity,
5768: inv_convert.INV_UM_CONVERT(bsc.substitute_component_id,
5769: NULL,
5770: Bsc.substitute_item_quantity,
5771: NULL,
5772: NULL,

Line 5912: inv_convert.INV_UM_CONVERT(bsc.substitute_component_id,

5908: /*NULL comment for bug8431772,change NULL to user_id*/user_id,
5909: --substitute_item_quantity,
5910: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
5911: AA.primary_unit_of_measure,Bsc.substitute_item_quantity,
5912: inv_convert.INV_UM_CONVERT(bsc.substitute_component_id,
5913: NULL,
5914: Bsc.substitute_item_quantity,
5915: NULL,
5916: NULL,

Line 7861: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

7857: -- bic.high_quantity,
7858: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
7859: AA.primary_unit_of_measure,BIC.low_quantity,
7860: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
7861: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
7862: NULL,
7863: BIC.low_quantity,
7864: NULL,
7865: NULL,

Line 7871: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

7867: MSI.primary_unit_of_measure))) Comp_low_qty,
7868: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
7869: AA.primary_unit_of_measure,BIC.high_quantity,
7870: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
7871: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
7872: NULL,
7873: BIC.high_quantity,
7874: NULL,
7875: NULL,

Line 7913: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

7909: bic.item_num,
7910: -- bic.component_quantity,
7911: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
7912: AA.primary_unit_of_measure,BIC.component_quantity,
7913: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
7914: NULL,
7915: BIC.component_quantity,
7916: NULL,
7917: NULL,

Line 8230: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

8226: --bic.high_quantity,
8227: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
8228: AA.primary_unit_of_measure,BIC.low_quantity,
8229: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
8230: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
8231: NULL,
8232: BIC.low_quantity,
8233: NULL,
8234: NULL,

Line 8240: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

8236: MSI.primary_unit_of_measure))) Comp_low_qty,
8237: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
8238: AA.primary_unit_of_measure,BIC.high_quantity,
8239: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
8240: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
8241: NULL,
8242: BIC.high_quantity,
8243: NULL,
8244: NULL,

Line 8282: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

8278: bic.item_num,
8279: -- bic.component_quantity,
8280: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
8281: AA.primary_unit_of_measure,BIC.component_quantity,
8282: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
8283: NULL,
8284: BIC.component_quantity,
8285: NULL,
8286: NULL,

Line 8597: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

8593: --bic.high_quantity,
8594: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
8595: AA.primary_unit_of_measure,BIC.low_quantity,
8596: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
8597: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
8598: NULL,
8599: BIC.low_quantity,
8600: NULL,
8601: NULL,

Line 8607: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

8603: MSI.primary_unit_of_measure))) Comp_low_qty,
8604: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
8605: AA.primary_unit_of_measure,BIC.high_quantity,
8606: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
8607: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
8608: NULL,
8609: BIC.high_quantity,
8610: NULL,
8611: NULL,

Line 8649: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

8645: bic.item_num,
8646: --bic.component_quantity,
8647: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
8648: AA.primary_unit_of_measure,BIC.component_quantity,
8649: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
8650: NULL,
8651: BIC.component_quantity,
8652: NULL,
8653: NULL,

Line 9009: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

9005: --bic.high_quantity,
9006: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
9007: AA.primary_unit_of_measure,BIC.low_quantity,
9008: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
9009: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
9010: NULL,
9011: BIC.low_quantity,
9012: NULL,
9013: NULL,

Line 9019: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

9015: MSI.primary_unit_of_measure))) Comp_low_qty,
9016: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
9017: AA.primary_unit_of_measure,BIC.high_quantity,
9018: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
9019: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
9020: NULL,
9021: BIC.high_quantity,
9022: NULL,
9023: NULL,

Line 9062: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

9058: bic.item_num,
9059: --bic.component_quantity,
9060: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
9061: AA.primary_unit_of_measure,BIC.component_quantity,
9062: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
9063: NULL,
9064: BIC.component_quantity,
9065: NULL,
9066: NULL,

Line 9410: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

9406: -- bic.high_quantity,
9407: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
9408: AA.primary_unit_of_measure,BIC.low_quantity,
9409: DECODE(BIC.low_quantity,null,null, --Added this inner Deocde for Bug 6847530
9410: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
9411: NULL,
9412: BIC.low_quantity,
9413: NULL,
9414: NULL,

Line 9420: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

9416: MSI.primary_unit_of_measure))) Comp_low_qty,
9417: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
9418: AA.primary_unit_of_measure,BIC.high_quantity,
9419: DECODE(BIC.high_quantity,null,null, --Added this inner Deocde for Bug 6847530
9420: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
9421: NULL,
9422: BIC.high_quantity,
9423: NULL,
9424: NULL,

Line 9462: inv_convert.INV_UM_CONVERT(BIC.component_item_id,

9458: bic.item_num,
9459: --bic.component_quantity,
9460: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
9461: AA.primary_unit_of_measure,BIC.component_quantity,
9462: inv_convert.INV_UM_CONVERT(BIC.component_item_id,
9463: NULL,
9464: BIC.component_quantity,
9465: NULL,
9466: NULL,

Line 11392: inv_convert.INV_UM_CONVERT(bsc.substitute_component_id,

11388: NULL,
11389: --substitute_item_quantity,
11390: DECODE(MSI.primary_unit_of_measure, -- Added corresponding to Bug 6510185
11391: AA.primary_unit_of_measure,Bsc.substitute_item_quantity,
11392: inv_convert.INV_UM_CONVERT(bsc.substitute_component_id,
11393: NULL,
11394: Bsc.substitute_item_quantity,
11395: NULL,
11396: NULL,