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 1753: * for rejection codes instead of relying on override/standard rates */

1749: rbc.txn_raw_cost_rate_override, --TXN_RAW_COST_RATE_OVERRIDE
1750: rbc.txn_burden_cost_rate_override, --TXN_BURDEN_COST_RATE_OVERRIDE
1751: rbc.txn_bill_rate_override, --TXN_BILL_RATE_OVERRIDE
1752: /* bug fix 5726773 : modified Avg/ETC rate calculation logic to check
1753: * for rejection codes instead of relying on override/standard rates */
1754: ( sum(decode(cost_rejection_code
1755: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1756: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))
1757: + nvl(bl.txn_init_raw_cost,0)

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

1752: /* bug fix 5726773 : modified Avg/ETC rate calculation logic to check
1753: * for rejection codes instead of relying on override/standard rates */
1754: ( sum(decode(cost_rejection_code
1755: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1756: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))
1757: + nvl(bl.txn_init_raw_cost,0)
1758: ,null))
1759: / DECODE(sum(decode(cost_rejection_code,null,nvl(bl.quantity,0),null))
1760: ,0,NULL

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

1770: ,sum(decode(burden_rejection_code,null,nvl(bl.quantity,0),null)))
1771: ) avg_burden_rate, --TXN_AVERAGE_BURDEN_COST_RATE
1772: ( sum(decode(revenue_rejection_code
1773: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1774: * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))
1775: + nvl(bl.txn_init_revenue,0)
1776: ,null))
1777: / DECODE(sum(decode(revenue_rejection_code,null,nvl(bl.quantity,0),null))
1778: ,0,NULL

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

1779: ,sum(decode(revenue_rejection_code,null,nvl(bl.quantity,0),null)))
1780: ) avg_bill_rate, --TXN_AVERAGE_BILL_RATE
1781: ( sum(decode(cost_rejection_code
1782: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1783: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))
1784: ,null))
1785: / DECODE(sum(decode(cost_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null))
1786: ,0,NULL
1787: ,sum(decode(cost_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null)))

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

1795: ,sum(decode(burden_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null)))
1796: ) etc_burden_rate, --TXN_ETC_BURDEN_COST_RATE
1797: ( sum(decode(revenue_rejection_code
1798: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1799: * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))
1800: ,null))
1801: / DECODE(sum(decode(revenue_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null))
1802: ,0,NULL
1803: ,sum(decode(revenue_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null)))

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

1913: rbc.txn_raw_cost_rate_override, --TXN_RAW_COST_RATE_OVERRIDE
1914: rbc.txn_burden_cost_rate_override, --TXN_BURDEN_COST_RATE_OVERRIDE
1915: rbc.txn_bill_rate_override, --TXN_BILL_RATE_OVERRIDE
1916: /* bug fix 5726773 : modified Avg/ETC rate calculation logic to check
1917: * for rejection codes instead of relying on override/standard rates */
1918: ( sum(decode(cost_rejection_code
1919: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1920: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))
1921: + nvl(bl.txn_init_raw_cost,0)

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

1916: /* bug fix 5726773 : modified Avg/ETC rate calculation logic to check
1917: * for rejection codes instead of relying on override/standard rates */
1918: ( sum(decode(cost_rejection_code
1919: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1920: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))
1921: + nvl(bl.txn_init_raw_cost,0)
1922: ,null))
1923: / DECODE(sum(decode(cost_rejection_code,null,nvl(bl.quantity,0),null))
1924: ,0,NULL

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

1934: ,sum(decode(burden_rejection_code,null,nvl(bl.quantity,0),null)))
1935: ) avg_burden_rate, --TXN_AVERAGE_BURDEN_COST_RATE
1936: ( sum(decode(revenue_rejection_code
1937: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1938: * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))
1939: + nvl(bl.txn_init_revenue,0)
1940: ,null))
1941: / DECODE(sum(decode(revenue_rejection_code,null,nvl(bl.quantity,0),null))
1942: ,0,NULL

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

1943: ,sum(decode(revenue_rejection_code,null,nvl(bl.quantity,0),null)))
1944: ) avg_bill_rate, --TXN_AVERAGE_BILL_RATE
1945: ( sum(decode(cost_rejection_code
1946: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1947: * nvl(bl.txn_cost_rate_override,nvl(bl.txn_standard_cost_rate,0)))
1948: ,null))
1949: / DECODE(sum(decode(cost_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null))
1950: ,0,NULL
1951: ,sum(decode(cost_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null)))

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

1959: ,sum(decode(burden_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null)))
1960: ) etc_burden_rate, --TXN_ETC_BURDEN_COST_RATE
1961: ( sum(decode(revenue_rejection_code
1962: ,null,((nvl(bl.quantity,0)-nvl(bl.init_quantity,0))
1963: * nvl(bl.txn_bill_rate_override,nvl(bl.txn_standard_bill_rate,0)))
1964: ,null))
1965: / DECODE(sum(decode(revenue_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null))
1966: ,0,NULL
1967: ,sum(decode(revenue_rejection_code,null,nvl(bl.quantity,0)-nvl(bl.init_quantity,0),null)))