1851: NULL,
1852: fsp.req_encumbrance_type_id,
1853: -1 * (DECODE(base_cur.minimum_accountable_unit,
1854: NULL,
1855: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
1856: / prd.req_line_quantity)
1857: * (GREATEST
1858: (
1859: DECODE
1879: ,0) -- GREATEST
1880: ),
1881: base_cur.precision), -- ROUND
1882:
1883: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
1884: / prd.req_line_quantity)
1885: * ((GREATEST
1886: (
1887: DECODE
1911: base_cur.precision))) Entered_Dr,
1912: 0 Entered_Cr,
1913: -1 * (DECODE(base_cur.minimum_accountable_unit,
1914: NULL,
1915: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
1916: / prd.req_line_quantity)
1917: * (GREATEST
1918: (
1919: DECODE
1939: ,0) -- GREATEST
1940: ),
1941: base_cur.precision), -- ROUND
1942:
1943: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
1944: / prd.req_line_quantity)
1945: * ((GREATEST
1946: (
1947: DECODE
2088: fsp.req_encumbrance_type_id,
2089: 0 Entered_Dr,
2090: -1 * (DECODE(base_cur.minimum_accountable_unit,
2091: NULL,
2092: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2093: / prd.req_line_quantity)
2094: * (GREATEST
2095: (
2096: DECODE
2116: ,0) -- GREATEST
2117: ),
2118: base_cur.precision), -- ROUND
2119:
2120: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2121: / prd.req_line_quantity)
2122: * ((GREATEST
2123: (
2124: DECODE
2147: base_cur.precision))) Entered_Cr,
2148: 0 Accounted_Dr,
2149: -1 * (DECODE(base_cur.minimum_accountable_unit,
2150: NULL,
2151: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2152: / prd.req_line_quantity)
2153: * (GREATEST
2154: (
2155: DECODE
2175: ,0) -- GREATEST
2176: ),
2177: base_cur.precision), -- ROUND
2178:
2179: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2180: / prd.req_line_quantity)
2181: * ((GREATEST
2182: (
2183: DECODE
2325: NULL,
2326: fsp.req_encumbrance_type_id,
2327: -1 * (DECODE(base_cur.minimum_accountable_unit,
2328: NULL,
2329: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2330: / prd.req_line_quantity)
2331: * (GREATEST
2332: (
2333: DECODE
2352: ,0) -- GREATEST
2353: ),
2354: base_cur.precision), -- ROUND
2355:
2356: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2357: / prd.req_line_quantity)
2358: * ((GREATEST
2359: (
2360: DECODE
2382: base_cur.precision))) Entered_Dr,
2383: 0 Entered_Cr,
2384: -1 * (DECODE(base_cur.minimum_accountable_unit,
2385: NULL,
2386: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2387: / prd.req_line_quantity)
2388: * (GREATEST
2389: (
2390: DECODE
2409: ,0) -- GREATEST
2410: ),
2411: base_cur.precision), -- ROUND
2412:
2413: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2414: / prd.req_line_quantity)
2415: * ((GREATEST
2416: (
2417: DECODE
2547: fsp.req_encumbrance_type_id,
2548: 0 Entered_Dr,
2549: -1 * (DECODE(base_cur.minimum_accountable_unit,
2550: NULL,
2551: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2552: / prd.req_line_quantity)
2553: * (GREATEST
2554: (
2555: DECODE
2574: ,0) -- GREATEST
2575: ),
2576: base_cur.precision), -- ROUND
2577:
2578: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2579: / prd.req_line_quantity)
2580: * ((GREATEST
2581: (
2582: DECODE
2604: base_cur.precision))) Entered_Cr,
2605: 0 Accounted_Dr,
2606: -1 * (DECODE(base_cur.minimum_accountable_unit,
2607: NULL,
2608: ROUND((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2609: / prd.req_line_quantity)
2610: * (GREATEST
2611: (
2612: DECODE
2631: ,0) -- GREATEST
2632: ),
2633: base_cur.precision), -- ROUND
2634:
2635: ROUND(((prl.unit_price + po_tax_sv.get_tax('REQ',prd.distribution_id)
2636: / prd.req_line_quantity)
2637: * ((GREATEST
2638: (
2639: DECODE
2772: NULL,
2773: fsp.purch_encumbrance_type_id,
2774: -1 * (DECODE(base_cur.minimum_accountable_unit,
2775: NULL,
2776: ROUND((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
2777: / pod.quantity_ordered)
2778: * NVL(pod.rate,1)
2779: * (
2780: DECODE
2792: ) -- DECODE
2793: ),
2794: base_cur.precision), -- ROUND
2795:
2796: ROUND(((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
2797: / pod.quantity_ordered)
2798: * NVL(pod.rate,1)
2799: * ((
2800: DECODE
2815: base_cur.precision))) Entered_Dr,
2816: 0 Entered_Cr,
2817: -1 * (DECODE(base_cur.minimum_accountable_unit,
2818: NULL,
2819: ROUND((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
2820: / pod.quantity_ordered)
2821: * NVL(pod.rate,1)
2822: * (
2823: DECODE
2835: ) -- DECODE
2836: ),
2837: base_cur.precision), -- ROUND
2838:
2839: ROUND(((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
2840: / pod.quantity_ordered)
2841: * NVL(pod.rate,1)
2842: * ((
2843: DECODE
2967: fsp.purch_encumbrance_type_id,
2968: 0 Entered_Dr,
2969: -1 * (DECODE(base_cur.minimum_accountable_unit,
2970: NULL,
2971: ROUND((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
2972: / pod.quantity_ordered)
2973: * NVL(pod.rate,1)
2974: * (
2975: DECODE
2987: ) -- DECODE
2988: ),
2989: base_cur.precision), -- ROUND
2990:
2991: ROUND(((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
2992: / pod.quantity_ordered)
2993: * NVL(pod.rate,1)
2994: * ((
2995: DECODE
3010: base_cur.precision))) Entered_Cr,
3011: 0 Accounted_Dr,
3012: -1 * (DECODE(base_cur.minimum_accountable_unit,
3013: NULL,
3014: ROUND((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
3015: / pod.quantity_ordered)
3016: * NVL(pod.rate,1)
3017: * (
3018: DECODE
3030: ) -- DECODE
3031: ),
3032: base_cur.precision), -- ROUND
3033:
3034: ROUND(((poll.price_override + po_tax_sv.get_tax('PO',pod.po_distribution_id)
3035: / pod.quantity_ordered)
3036: * NVL(pod.rate,1)
3037: * ((
3038: DECODE