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 3519: l_rec cst_inv_cost_temp%ROWTYPE;

3515: l_resource_cost NUMBER;
3516: l_outside_processing_cost NUMBER;
3517: l_overhead_cost NUMBER;
3518: l_exp_item_flag NUMBER;
3519: l_rec cst_inv_cost_temp%ROWTYPE;
3520:
3521: PROCEDURE ins_cst_inv_cost_temp(p_rec IN cst_inv_cost_temp%ROWTYPE) IS
3522: BEGIN
3523: INSERT INTO cst_inv_cost_temp(

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

3517: l_overhead_cost NUMBER;
3518: l_exp_item_flag NUMBER;
3519: l_rec cst_inv_cost_temp%ROWTYPE;
3520:
3521: PROCEDURE ins_cst_inv_cost_temp(p_rec IN cst_inv_cost_temp%ROWTYPE) IS
3522: BEGIN
3523: INSERT INTO cst_inv_cost_temp(
3524: organization_id,
3525: inventory_item_id,

Line 3523: INSERT INTO cst_inv_cost_temp(

3519: l_rec cst_inv_cost_temp%ROWTYPE;
3520:
3521: PROCEDURE ins_cst_inv_cost_temp(p_rec IN cst_inv_cost_temp%ROWTYPE) IS
3522: BEGIN
3523: INSERT INTO cst_inv_cost_temp(
3524: organization_id,
3525: inventory_item_id,
3526: cost_type_id,
3527: cost_source,

Line 3547: END ins_cst_inv_cost_temp;

3543: p_rec.material_overhead_cost,
3544: p_rec.resource_cost,
3545: p_rec.outside_processing_cost,
3546: p_rec.overhead_cost);
3547: END ins_cst_inv_cost_temp;
3548: --}
3549: BEGIN
3550: -- Standard Start of API savepoint
3551: SAVEPOINT Calculate_InventoryCost_PVT;

Line 3597: INTO cst_inv_cost_temp(

3593: EXIT
3594: WHEN c_standard%NOTFOUND;
3595:
3596: INSERT
3597: INTO cst_inv_cost_temp(
3598: organization_id,
3599: inventory_item_id,
3600: cost_type_id,
3601: cost_source,

Line 3647: INTO cst_inv_cost_temp(

3643: -- Note HYU: For layer the as of date has no effect, always null
3644: --
3645: l_stmt_num := 20;
3646: INSERT
3647: INTO cst_inv_cost_temp(
3648: organization_id,
3649: inventory_item_id,
3650: cost_group_id,
3651: cost_type_id,

Line 3784: INSERT INTO cst_inv_cost_temp

3780: );
3781: END IF;
3782:
3783: -- As the cost type is not the valuation cost type insert the current cost
3784: INSERT INTO cst_inv_cost_temp
3785: ( organization_id,
3786: inventory_item_id,
3787: cost_type_id,
3788: cost_source,

Line 3859: ins_cst_inv_cost_temp(p_rec => l_rec);

3855: l_rec.material_overhead_cost := 0;
3856: l_rec.resource_cost := 0;
3857: l_rec.outside_processing_cost:= 0;
3858: l_rec.overhead_cost := 0;
3859: ins_cst_inv_cost_temp(p_rec => l_rec);
3860:
3861: ELSE
3862: OPEN cur_get_new_mcacd_cost(
3863: l_organization_id ,

Line 3885: INSERT INTO cst_inv_cost_temp(

3881:
3882: IF (cur_get_new_mcacd_cost%NOTFOUND) THEN
3883: /*No Txn in future use present cost */
3884:
3885: INSERT INTO cst_inv_cost_temp(
3886: organization_id,
3887: inventory_item_id,
3888: cost_type_id,
3889: cost_source,

Line 3951: ins_cst_inv_cost_temp(p_rec => l_rec);

3947: l_rec.outside_processing_cost:= 0;
3948: l_rec.overhead_cost := 0;
3949: END IF;
3950: END IF;
3951: ins_cst_inv_cost_temp(p_rec => l_rec);
3952:
3953: END IF;
3954: CLOSE cur_get_new_mcacd_cost;
3955: END IF;

Line 3995: INTO cst_inv_cost_temp(

3991: IF l_max_cost_update_id IS NOT NULL
3992: THEN
3993: -- Use the cost in cst_elemental_costs.
3994: INSERT
3995: INTO cst_inv_cost_temp(
3996: organization_id,
3997: inventory_item_id,
3998: cost_type_id,
3999: cost_source,

Line 4040: INTO cst_inv_cost_temp(

4036:
4037: ELSE
4038: -- Either the cost history is purged or item cost is zero
4039: INSERT
4040: INTO cst_inv_cost_temp(
4041: organization_id,
4042: inventory_item_id,
4043: cost_type_id,
4044: cost_source,

Line 4081: INTO cst_inv_cost_temp(

4077:
4078: ELSE
4079: -- No. Use current cost
4080: INSERT
4081: INTO cst_inv_cost_temp(
4082: organization_id,
4083: inventory_item_id,
4084: cost_type_id,
4085: cost_source,

Line 4155: INTO cst_inv_cost_temp(

4151:
4152: --Actual Cost processing
4153: l_stmt_num := 50;
4154: INSERT
4155: INTO cst_inv_cost_temp(
4156: organization_id,
4157: inventory_item_id,
4158: cost_group_id,
4159: cost_type_id,

Line 4212: INTO cst_inv_cost_temp(

4208: WHERE organization_id = p_organization_id;
4209:
4210: l_stmt_num := 60;
4211: INSERT
4212: INTO cst_inv_cost_temp(
4213: organization_id,
4214: inventory_item_id,
4215: cost_group_id,
4216: cost_type_id,

Line 4263: FROM cst_inv_cost_temp CICT

4259: AND CIQT.qty_source NOT IN (1,2,9,10)
4260: -- PRIOR SUMMARY, CURRENT SUMMARY, RECEIVING, PAST RECEIVING
4261: AND NOT EXISTS (
4262: SELECT 1
4263: FROM cst_inv_cost_temp CICT
4264: WHERE CICT.organization_id = CIQT.organization_id
4265: AND CICT.inventory_item_id = CIQT.inventory_item_id
4266: AND CICT.cost_source = 2
4267: )

Line 4573: INTO cst_inv_cost_temp(

4569: END IF;
4570:
4571: l_stmt_num := 70;
4572: INSERT
4573: INTO cst_inv_cost_temp(
4574: organization_id,
4575: inventory_item_id,
4576: cost_group_id,
4577: cost_type_id,

Line 4620: FROM cst_inv_cost_temp CICT

4616: AND CQL.cost_group_id (+) = CIQT.cost_group_id
4617: /* The outer join above is for asset items that do not have a layer */
4618: AND NOT EXISTS (
4619: SELECT 1
4620: FROM cst_inv_cost_temp CICT
4621: WHERE CICT.organization_id = CIQT.organization_id
4622: AND CICT.inventory_item_id = CIQT.inventory_item_id
4623: AND CICT.cost_group_id = CIQT.cost_group_id
4624: AND CICT.cost_source = 2

Line 4683: INTO cst_inv_cost_temp(

4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: END IF;
4681:
4682: INSERT
4683: INTO cst_inv_cost_temp(
4684: cost_source,
4685: organization_id,
4686: inventory_item_id,
4687: rcv_transaction_id,