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.CTO_CONFIG_COST_PK dependencies on STANDARD

Line 842: INSERT INTO cst_standard_costs

838: IF PG_DEBUG <> 0 THEN
839: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'Inserting records in csc and cec',2);
840: END IF;
841:
842: INSERT INTO cst_standard_costs
843: (cost_update_id,
844: organization_id,
845: inventory_item_id,
846: last_update_date,

Line 851: standard_cost_revision_date,

847: last_updated_by,
848: creation_date,
849: created_by,
850: last_update_login,
851: standard_cost_revision_date,
852: standard_cost
853: )
854: SELECT
855: l_cost_update,

Line 852: standard_cost

848: creation_date,
849: created_by,
850: last_update_login,
851: standard_cost_revision_date,
852: standard_cost
853: )
854: SELECT
855: l_cost_update,
856: p_organization_id,

Line 872: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'after insert:cst_standard_costs ' || sql%rowcount ,2);

868: AND inventory_item_id = p_config_item_id
869: AND cost_type_id = 1;
870:
871: IF PG_DEBUG <> 0 THEN
872: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'after insert:cst_standard_costs ' || sql%rowcount ,2);
873: END IF;
874:
875: lStmtNumber := 260;
876:

Line 887: standard_cost

883: last_updated_by,
884: creation_date,
885: created_by,
886: last_update_login,
887: standard_cost
888: )
889: SELECT
890: l_cost_update,
891: p_organization_id,

Line 1870: ** standard costing organization

1866: End if;
1867: /*
1868: **
1869: ** Costs need to be copied from simulation cost to frozen cost in case of
1870: ** standard costing organization
1871: **
1872: */
1873:
1874:

Line 1878: /* update Frozen cost with CTO Cost in case of standard costing organizations */

1874:
1875:
1876:
1877: lStmtNumber := 80;
1878: /* update Frozen cost with CTO Cost in case of standard costing organizations */
1879:
1880:
1881: for i in p_cfg_itm_tbl.FIRST..p_cfg_itm_tbl.LAST
1882:

Line 1912: -- If the org is Standard cost then check if the Item is transacted

1908:
1909: IF PG_DEBUG <> 0 THEN
1910: oe_debug_pub.add('populate_buy_cost: ' || 'v_primary_cost_method = '||v_primary_cost_method);
1911: END IF;
1912: -- If the org is Standard cost then check if the Item is transacted
1913: --
1914: IF (v_primary_cost_method = 1) THEN
1915: v_is_cst_updatable := check_ct_updateable(c_config_item_id, c_organization_id, 1);
1916: ELSE

Line 2145: to determine organizations where standard cost update needs to be performed.

2141: /* 3116778 */
2142: /*
2143: BUG 3931290
2144: The original cursor c_frozen_cost_update was using a union (organization_id , rcv_org_id )
2145: to determine organizations where standard cost update needs to be performed.
2146: The organizations where standard cost update will be performed will now be determined using organization_id.
2147: This will eliminate the 2nd sql statement (rcv_org_id) in the union and there will be no need for a union.
2148: A distinct clause has been added to the statement.
2149: */

Line 2146: The organizations where standard cost update will be performed will now be determined using organization_id.

2142: /*
2143: BUG 3931290
2144: The original cursor c_frozen_cost_update was using a union (organization_id , rcv_org_id )
2145: to determine organizations where standard cost update needs to be performed.
2146: The organizations where standard cost update will be performed will now be determined using organization_id.
2147: This will eliminate the 2nd sql statement (rcv_org_id) in the union and there will be no need for a union.
2148: A distinct clause has been added to the statement.
2149: */
2150: cursor c_frozen_cost_update(c_cto_cost_type_id number )

Line 2505: -- 3. primary_cost_method = 1 (standard)

2501: -- insert into CST_SC_LISTS rows for all config items in all possible
2502: -- src orgs, where ->
2503: -- 1. cost has not been calculated yet (cost_rollup = Y)
2504: -- 2. costing_enabled_flag = Y
2505: -- 3. primary_cost_method = 1 (standard)
2506: --
2507: IF PG_DEBUG <> 0 THEN
2508: oe_debug_pub.add('Cost_Rollup_ML: ' || 'inserting into cst_sc_lists', 2);
2509: END IF;

Line 2866: ** standard costing organization

2862:
2863: /*
2864: **
2865: ** Costs need to be copied from simulation cost to frozen cost in case of
2866: ** standard costing organization
2867: **
2868: */
2869:
2870:

Line 2882: /update Frozen cost with CTO Cost in case of standard costing organizations /

2878: oe_debug_pub.add('***No need to do frozen cost update as no rollup has been done' , 1);
2879: END IF;
2880:
2881: else
2882: /*update Frozen cost with CTO Cost in case of standard costing organizations */
2883: lStmtNumber := 90;
2884:
2885: open c_frozen_cost_update ( v_cto_cost_type_id ) ;
2886:

Line 2905: -- If the org is Standard cost then check if the Item is transacted

2901: IF PG_DEBUG <> 0 THEN
2902: oe_debug_pub.add('Cost_Rollup_ML: ' || 'v_primary_cost_method = '||v_primary_cost_method);
2903: END IF;
2904:
2905: -- If the org is Standard cost then check if the Item is transacted
2906: --
2907: IF (v_primary_cost_method = 1) THEN
2908: v_is_cst_updatable := check_ct_updateable(c_config_item_id, c_organization_id, 1);
2909: ELSE