eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RES_ASG_CURRENCY_PUB dependencies on STANDARD

Line 1767: * for rejection codes instead of relying on override/standard rates */

1763: rbc.txn_raw_cost_rate_override, --TXN_RAW_COST_RATE_OVERRIDE
1764: rbc.txn_burden_cost_rate_override, --TXN_BURDEN_COST_RATE_OVERRIDE
1765: rbc.txn_bill_rate_override, --TXN_BILL_RATE_OVERRIDE
1766: /* bug fix 5523038 : modified Avg/ETC rate calculation logic to check
1767: * for rejection codes instead of relying on override/standard rates */
1768: ( sum(decode(cost_rejection_code
1769: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1770: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))
1771: + nvl(bl.txn_init_raw_cost,0)

Line 1770: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))

1766: /* bug fix 5523038 : modified Avg/ETC rate calculation logic to check
1767: * for rejection codes instead of relying on override/standard rates */
1768: ( sum(decode(cost_rejection_code
1769: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1770: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))
1771: + nvl(bl.txn_init_raw_cost,0)
1772: ,null))
1773: / DECODE(sum(decode(cost_rejection_code,null,nvl(bl.quantity,0),null))
1774: ,0,NULL

Line 1788: * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))

1784: ,sum(decode(burden_rejection_code,null,nvl(bl.quantity,0),null)))
1785: ) avg_burden_rate, --TXN_AVERAGE_BURDEN_COST_RATE
1786: ( sum(decode(revenue_rejection_code
1787: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1788: * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))
1789: + nvl(bl.txn_init_revenue,0)
1790: ,null))
1791: / DECODE(sum(decode(revenue_rejection_code,null,nvl(bl.quantity,0),null))
1792: ,0,NULL

Line 1797: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))

1793: ,sum(decode(revenue_rejection_code,null,nvl(bl.quantity,0),null)))
1794: ) avg_bill_rate, --TXN_AVERAGE_BILL_RATE
1795: ( sum(decode(cost_rejection_code
1796: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1797: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))
1798: ,null))
1799: / DECODE(sum(decode(cost_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null))
1800: ,0,NULL
1801: ,sum(decode(cost_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null)))

Line 1813: * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))

1809: ,sum(decode(burden_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null)))
1810: ) etc_burden_rate, --TXN_ETC_BURDEN_COST_RATE
1811: ( sum(decode(revenue_rejection_code
1812: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1813: * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))
1814: ,null))
1815: / DECODE(sum(decode(revenue_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null))
1816: ,0,NULL
1817: ,sum(decode(revenue_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null)))

Line 1935: * for rejection codes instead of relying on override/standard rates */

1931: rbc.txn_raw_cost_rate_override, --TXN_RAW_COST_RATE_OVERRIDE
1932: rbc.txn_burden_cost_rate_override, --TXN_BURDEN_COST_RATE_OVERRIDE
1933: rbc.txn_bill_rate_override, --TXN_BILL_RATE_OVERRIDE
1934: /* bug fix 5523038 : modified Avg/ETC rate calculation logic to check
1935: * for rejection codes instead of relying on override/standard rates */
1936: ( sum(decode(cost_rejection_code
1937: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1938: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))
1939: + nvl(bl.txn_init_raw_cost,0)

Line 1938: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))

1934: /* bug fix 5523038 : modified Avg/ETC rate calculation logic to check
1935: * for rejection codes instead of relying on override/standard rates */
1936: ( sum(decode(cost_rejection_code
1937: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1938: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))
1939: + nvl(bl.txn_init_raw_cost,0)
1940: ,null))
1941: / DECODE(sum(decode(cost_rejection_code,null,nvl(bl.quantity,0),null))
1942: ,0,NULL

Line 1956: * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))

1952: ,sum(decode(burden_rejection_code,null,nvl(bl.quantity,0),null)))
1953: ) avg_burden_rate, --TXN_AVERAGE_BURDEN_COST_RATE
1954: ( sum(decode(revenue_rejection_code
1955: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1956: * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))
1957: + nvl(bl.txn_init_revenue,0)
1958: ,null))
1959: / DECODE(sum(decode(revenue_rejection_code,null,nvl(bl.quantity,0),null))
1960: ,0,NULL

Line 1966: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))

1962: ) avg_bill_rate, --TXN_AVERAGE_BILL_RATE
1963:
1964: ( sum(decode(cost_rejection_code
1965: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1966: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))
1967: ,null))
1968: / DECODE(sum(decode(cost_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null))
1969: ,0,NULL
1970: ,sum(decode(cost_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null)))

Line 1982: * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))

1978: ,sum(decode(burden_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null)))
1979: ) etc_burden_rate, --TXN_ETC_BURDEN_COST_RATE
1980: ( sum(decode(revenue_rejection_code
1981: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1982: * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))
1983: ,null))
1984: / DECODE(sum(decode(revenue_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null))
1985: ,0,NULL
1986: ,sum(decode(revenue_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null)))