12: -- Oracle Applications Rel 11i.1 --
13: -- --
14: -- PARAMETERS: --
15: -- i_entity_id : Wip entity id of lot based job --
16: -- i_run_option : 1 if it is called from standard cost --
17: -- processor and split merge cost processor --
18: -- for txn type Split or Merge --
19: -- 2 if is called from standard cost update --
20: -- 3 if it is called from split merge cost --
15: -- i_entity_id : Wip entity id of lot based job --
16: -- i_run_option : 1 if it is called from standard cost --
17: -- processor and split merge cost processor --
18: -- for txn type Split or Merge --
19: -- 2 if is called from standard cost update --
20: -- 3 if it is called from split merge cost --
21: -- processor with txn type bonus and update --
22: -- quanitty. --
23: -- i_txn_op_seq_num :Operation sequence number for bonus and --
1687: ---------------------------------------------------------
1688: l_stmt_num := 30;
1689: SELECT
1690: NVL(SUM(DECODE(BR.COST_ELEMENT_ID,
1691: 3, DECODE(BR.STANDARD_RATE_FLAG,
1692: 1, decode(BR.functional_currency_flag,
1693: 1,nvl(WOR.APPLIED_RESOURCE_UNITS,0),
1694: nvl(CRC.RESOURCE_RATE*WOR.APPLIED_RESOURCE_UNITS,0)),
1695: 2, nvl(WOR.APPLIED_RESOURCE_VALUE,0)),
1694: nvl(CRC.RESOURCE_RATE*WOR.APPLIED_RESOURCE_UNITS,0)),
1695: 2, nvl(WOR.APPLIED_RESOURCE_VALUE,0)),
1696: 0)),0),
1697: NVL(SUM(DECODE(BR.COST_ELEMENT_ID,
1698: 4, DECODE(BR.STANDARD_RATE_FLAG,
1699: 1, decode(BR.functional_currency_flag,
1700: 1,nvl(WOR.APPLIED_RESOURCE_UNITS,0),
1701: nvl(CRC.RESOURCE_RATE*WOR.APPLIED_RESOURCE_UNITS,0)),
1702: 2, nvl(WOR.APPLIED_RESOURCE_VALUE,0)),