DBA Data[Home] [Help]

APPS.CSTPOYLD dependencies on STANDARD

Line 16: -- i_run_option : 1 if it is called from standard cost --

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 --

Line 19: -- 2 if is called from standard cost update --

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 --

Line 1691: 3, DECODE(BR.STANDARD_RATE_FLAG,

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)),

Line 1698: 4, DECODE(BR.STANDARD_RATE_FLAG,

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)),