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.CST_INVENTORY_PVT dependencies on CST_INV_COST_TEMP

Line 27: PROCEDURE ins_cst_inv_cost_temp(p_rec IN cst_inv_cost_temp%ROWTYPE) IS

23: END IF;
24: END IF;
25: END log;
26:
27: PROCEDURE ins_cst_inv_cost_temp(p_rec IN cst_inv_cost_temp%ROWTYPE) IS
28: BEGIN
29: INSERT INTO cst_inv_cost_temp(
30: organization_id,
31: inventory_item_id,

Line 29: INSERT INTO cst_inv_cost_temp(

25: END log;
26:
27: PROCEDURE ins_cst_inv_cost_temp(p_rec IN cst_inv_cost_temp%ROWTYPE) IS
28: BEGIN
29: INSERT INTO cst_inv_cost_temp(
30: organization_id,
31: inventory_item_id,
32: cost_type_id,
33: cost_source,

Line 53: END ins_cst_inv_cost_temp;

49: p_rec.material_overhead_cost,
50: p_rec.resource_cost,
51: p_rec.outside_processing_cost,
52: p_rec.overhead_cost);
53: END ins_cst_inv_cost_temp;
54:
55:
56: PROCEDURE Populate_ItemList(
57: p_api_version IN NUMBER,

Line 3515: l_rec cst_inv_cost_temp%ROWTYPE;

3511: l_msg_data VARCHAR2(2000);
3512:
3513: l_rcv_cost_source NUMBER; -- added in 12i for as of date changes
3514: l_exp_item_flag NUMBER;
3515: l_rec cst_inv_cost_temp%ROWTYPE;
3516:
3517: CURSOR c_standard IS
3518: SELECT DISTINCT
3519: CIQT.organization_id,

Line 3619: l_rec cst_inv_cost_temp%ROWTYPE;

3615: l_material_overhead_cost NUMBER;
3616: l_resource_cost NUMBER;
3617: l_outside_processing_cost NUMBER;
3618: l_overhead_cost NUMBER;
3619: l_rec cst_inv_cost_temp%ROWTYPE;
3620:
3621: BEGIN
3622: log('use_transactional_cost+ : p_organization_id:'||p_organization_id||
3623: ' p_valuation_date:'||p_valuation_date||

Line 3648: INSERT INTO cst_inv_cost_temp(

3644: IF (cur_get_new_mcacd_cost%NOTFOUND) THEN
3645: /*No Txn in future use present cost */
3646: log(' cur_get_new_mcacd_cost not found');
3647:
3648: INSERT INTO cst_inv_cost_temp(
3649: organization_id,
3650: inventory_item_id,
3651: cost_type_id,
3652: cost_source,

Line 3720: ins_cst_inv_cost_temp(p_rec => l_rec);

3716: l_rec.outside_processing_cost:= 0;
3717: l_rec.overhead_cost := 0;
3718: END IF;
3719: END IF;
3720: ins_cst_inv_cost_temp(p_rec => l_rec);
3721:
3722: END IF;
3723: CLOSE cur_get_new_mcacd_cost;
3724: log('use_transactional_cost-');

Line 3776: INTO cst_inv_cost_temp(

3772: EXIT
3773: WHEN c_standard%NOTFOUND;
3774:
3775: INSERT
3776: INTO cst_inv_cost_temp(
3777: organization_id,
3778: inventory_item_id,
3779: cost_type_id,
3780: cost_source,

Line 3826: INTO cst_inv_cost_temp(

3822: -- Note HYU: For layer the as of date has no effect, always null
3823: --
3824: l_stmt_num := 20;
3825: INSERT
3826: INTO cst_inv_cost_temp(
3827: organization_id,
3828: inventory_item_id,
3829: cost_group_id,
3830: cost_type_id,

Line 3963: INSERT INTO cst_inv_cost_temp

3959: );
3960: END IF;
3961:
3962: -- As the cost type is not the valuation cost type insert the current cost
3963: INSERT INTO cst_inv_cost_temp
3964: ( organization_id,
3965: inventory_item_id,
3966: cost_type_id,
3967: cost_source,

Line 4032: ins_cst_inv_cost_temp(p_rec => l_rec);

4028: l_rec.material_overhead_cost := 0;
4029: l_rec.resource_cost := 0;
4030: l_rec.outside_processing_cost:= 0;
4031: l_rec.overhead_cost := 0;
4032: ins_cst_inv_cost_temp(p_rec => l_rec);
4033:
4034: ELSE
4035:
4036: --get the cost update history ID after the end period call

Line 4093: INTO cst_inv_cost_temp(

4089: -- the l_inventory_item_id in that l_organization_id
4090: IF l_max_cost_update_id IS NOT NULL THEN
4091: -- Use the cost in cst_elemental_costs of that cost history
4092: INSERT
4093: INTO cst_inv_cost_temp(
4094: organization_id,
4095: inventory_item_id,
4096: cost_type_id,
4097: cost_source,

Line 4148: -- INTO cst_inv_cost_temp(

4144: p_valuation_date => p_valuation_date,
4145: p_inventory_item_id => l_inventory_item_id);
4146:
4147: -- INSERT
4148: -- INTO cst_inv_cost_temp(
4149: -- organization_id,
4150: -- inventory_item_id,
4151: -- cost_type_id,
4152: -- cost_source,

Line 4187: INTO cst_inv_cost_temp(

4183:
4184: ELSE
4185: -- No. Use current cost
4186: INSERT
4187: INTO cst_inv_cost_temp(
4188: organization_id,
4189: inventory_item_id,
4190: cost_type_id,
4191: cost_source,

Line 4262: INTO cst_inv_cost_temp(

4258: -- use cic cost for the cost_type_id
4259: l_stmt_num := 50;
4260:
4261: INSERT
4262: INTO cst_inv_cost_temp(
4263: organization_id,
4264: inventory_item_id,
4265: cost_group_id,
4266: cost_type_id,

Line 4311: INTO cst_inv_cost_temp(

4307: else
4308: -- calculate the cost in the past as of the as_of_date or p_val_date
4309: l_stmt_num := 53;
4310: INSERT
4311: INTO cst_inv_cost_temp(
4312: organization_id,
4313: inventory_item_id,
4314: cost_group_id,
4315: cost_type_id,

Line 4369: INSERT INTO cst_inv_cost_temp(

4365:
4366: l_stmt_num := 60;
4367: /* Bug 9764385: Modified the query to include Logical Intransit transactions */
4368: IF (l_cost_method <> 1) THEN
4369: INSERT INTO cst_inv_cost_temp(
4370: organization_id,
4371: inventory_item_id,
4372: cost_group_id,
4373: cost_type_id,

Line 4445: FROM cst_inv_cost_temp CICT

4441: FROM cst_inv_qty_temp CIQT1
4442: WHERE CIQT1.qty_source NOT IN (1,2,9,10)
4443: -- PRIOR SUMMARY, CURRENT SUMMARY, RECEIVING, PAST RECEIVING
4444: AND NOT EXISTS ( SELECT 1
4445: FROM cst_inv_cost_temp CICT
4446: WHERE CICT.organization_id = CIQT1.organization_id
4447: AND CICT.inventory_item_id = CIQT1.inventory_item_id
4448: AND CICT.cost_source = 2
4449: )

Line 4597: INTO cst_inv_cost_temp(

4593: END IF;
4594:
4595: l_stmt_num := 70;
4596: INSERT
4597: INTO cst_inv_cost_temp(
4598: organization_id,
4599: inventory_item_id,
4600: cost_group_id,
4601: cost_type_id,

Line 4646: FROM cst_inv_cost_temp CICT

4642: /* Added below condition as the outer join inserts zero cost duplicate row in CICT */
4643: AND CIQT.cost_group_id IS NOT NULL /*--Bug 9161102- FP for bug 7672378 */
4644: AND NOT EXISTS (
4645: SELECT 1
4646: FROM cst_inv_cost_temp CICT
4647: WHERE CICT.organization_id = CIQT.organization_id
4648: AND CICT.inventory_item_id = CIQT.inventory_item_id
4649: AND CICT.cost_group_id = CIQT.cost_group_id
4650: AND CICT.cost_source = 2

Line 4711: INTO cst_inv_cost_temp(

4707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4708: END IF;
4709:
4710: INSERT
4711: INTO cst_inv_cost_temp(
4712: cost_source,
4713: organization_id,
4714: inventory_item_id,
4715: rcv_transaction_id,