DBA Data[Home] [Help]

APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on PO_TAX_SV

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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