DBA Data[Home] [Help]

APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on PO_TAX_SV

Line 1856: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

1852: NULL,
1853: fsp.req_encumbrance_type_id,
1854: -1 * (DECODE(base_cur.minimum_accountable_unit,
1855: NULL,
1856: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
1857: / prd.req_line_quantity)
1858: * (GREATEST
1859: (
1860: DECODE

Line 1884: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

1880: ,0) -- GREATEST
1881: ),
1882: base_cur.precision), -- ROUND
1883:
1884: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
1885: / prd.req_line_quantity)
1886: * ((GREATEST
1887: (
1888: DECODE

Line 1916: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

1912: base_cur.precision))) Entered_Dr,
1913: 0 Entered_Cr,
1914: -1 * (DECODE(base_cur.minimum_accountable_unit,
1915: NULL,
1916: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
1917: / prd.req_line_quantity)
1918: * (GREATEST
1919: (
1920: DECODE

Line 1944: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

1940: ,0) -- GREATEST
1941: ),
1942: base_cur.precision), -- ROUND
1943:
1944: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
1945: / prd.req_line_quantity)
1946: * ((GREATEST
1947: (
1948: DECODE

Line 2093: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

2089: fsp.req_encumbrance_type_id,
2090: 0 Entered_Dr,
2091: -1 * (DECODE(base_cur.minimum_accountable_unit,
2092: NULL,
2093: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2094: / prd.req_line_quantity)
2095: * (GREATEST
2096: (
2097: DECODE

Line 2121: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

2117: ,0) -- GREATEST
2118: ),
2119: base_cur.precision), -- ROUND
2120:
2121: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2122: / prd.req_line_quantity)
2123: * ((GREATEST
2124: (
2125: DECODE

Line 2152: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

2148: base_cur.precision))) Entered_Cr,
2149: 0 Accounted_Dr,
2150: -1 * (DECODE(base_cur.minimum_accountable_unit,
2151: NULL,
2152: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2153: / prd.req_line_quantity)
2154: * (GREATEST
2155: (
2156: DECODE

Line 2180: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

2176: ,0) -- GREATEST
2177: ),
2178: base_cur.precision), -- ROUND
2179:
2180: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2181: / prd.req_line_quantity)
2182: * ((GREATEST
2183: (
2184: DECODE

Line 2330: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

2326: NULL,
2327: fsp.req_encumbrance_type_id,
2328: -1 * (DECODE(base_cur.minimum_accountable_unit,
2329: NULL,
2330: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2331: / prd.req_line_quantity)
2332: * (GREATEST
2333: (
2334: DECODE

Line 2357: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

2353: ,0) -- GREATEST
2354: ),
2355: base_cur.precision), -- ROUND
2356:
2357: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2358: / prd.req_line_quantity)
2359: * ((GREATEST
2360: (
2361: DECODE

Line 2387: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

2383: base_cur.precision))) Entered_Dr,
2384: 0 Entered_Cr,
2385: -1 * (DECODE(base_cur.minimum_accountable_unit,
2386: NULL,
2387: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2388: / prd.req_line_quantity)
2389: * (GREATEST
2390: (
2391: DECODE

Line 2414: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

2410: ,0) -- GREATEST
2411: ),
2412: base_cur.precision), -- ROUND
2413:
2414: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2415: / prd.req_line_quantity)
2416: * ((GREATEST
2417: (
2418: DECODE

Line 2552: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

2548: fsp.req_encumbrance_type_id,
2549: 0 Entered_Dr,
2550: -1 * (DECODE(base_cur.minimum_accountable_unit,
2551: NULL,
2552: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2553: / prd.req_line_quantity)
2554: * (GREATEST
2555: (
2556: DECODE

Line 2579: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

2575: ,0) -- GREATEST
2576: ),
2577: base_cur.precision), -- ROUND
2578:
2579: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2580: / prd.req_line_quantity)
2581: * ((GREATEST
2582: (
2583: DECODE

Line 2609: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

2605: base_cur.precision))) Entered_Cr,
2606: 0 Accounted_Dr,
2607: -1 * (DECODE(base_cur.minimum_accountable_unit,
2608: NULL,
2609: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2610: / prd.req_line_quantity)
2611: * (GREATEST
2612: (
2613: DECODE

Line 2636: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)

2632: ,0) -- GREATEST
2633: ),
2634: base_cur.precision), -- ROUND
2635:
2636: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2637: / prd.req_line_quantity)
2638: * ((GREATEST
2639: (
2640: DECODE

Line 2777: ROUND((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)

2773: NULL,
2774: fsp.purch_encumbrance_type_id,
2775: -1 * (DECODE(base_cur.minimum_accountable_unit,
2776: NULL,
2777: ROUND((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
2778: / pod.quantity_ordered)
2779: * NVL(pod.rate,1)
2780: * (
2781: DECODE

Line 2797: ROUND(((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)

2793: ) -- DECODE
2794: ),
2795: base_cur.precision), -- ROUND
2796:
2797: ROUND(((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
2798: / pod.quantity_ordered)
2799: * NVL(pod.rate,1)
2800: * ((
2801: DECODE

Line 2820: ROUND((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)

2816: base_cur.precision))) Entered_Dr,
2817: 0 Entered_Cr,
2818: -1 * (DECODE(base_cur.minimum_accountable_unit,
2819: NULL,
2820: ROUND((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
2821: / pod.quantity_ordered)
2822: * NVL(pod.rate,1)
2823: * (
2824: DECODE

Line 2840: ROUND(((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)

2836: ) -- DECODE
2837: ),
2838: base_cur.precision), -- ROUND
2839:
2840: ROUND(((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
2841: / pod.quantity_ordered)
2842: * NVL(pod.rate,1)
2843: * ((
2844: DECODE

Line 2972: ROUND((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)

2968: fsp.purch_encumbrance_type_id,
2969: 0 Entered_Dr,
2970: -1 * (DECODE(base_cur.minimum_accountable_unit,
2971: NULL,
2972: ROUND((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
2973: / pod.quantity_ordered)
2974: * NVL(pod.rate,1)
2975: * (
2976: DECODE

Line 2992: ROUND(((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)

2988: ) -- DECODE
2989: ),
2990: base_cur.precision), -- ROUND
2991:
2992: ROUND(((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
2993: / pod.quantity_ordered)
2994: * NVL(pod.rate,1)
2995: * ((
2996: DECODE

Line 3015: ROUND((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)

3011: base_cur.precision))) Entered_Cr,
3012: 0 Accounted_Dr,
3013: -1 * (DECODE(base_cur.minimum_accountable_unit,
3014: NULL,
3015: ROUND((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
3016: / pod.quantity_ordered)
3017: * NVL(pod.rate,1)
3018: * (
3019: DECODE

Line 3035: ROUND(((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)

3031: ) -- DECODE
3032: ),
3033: base_cur.precision), -- ROUND
3034:
3035: ROUND(((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
3036: / pod.quantity_ordered)
3037: * NVL(pod.rate,1)
3038: * ((
3039: DECODE