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.CSTPLENG dependencies on CST_LAYER_COST_DETAILS

Line 1462: FROM cst_layer_cost_details

1458: ELSE
1459: l_stmt_num := 15;
1460: SELECT count(*)
1461: INTO l_count
1462: FROM cst_layer_cost_details
1463: WHERE layer_id = i_layer_id;
1464:
1465: IF (l_count > 0) THEN
1466: l_stmt_num := 20;

Line 1513: FROM cst_layer_cost_details clcd

1509: clcd.item_cost,
1510: 'N',
1511: 0,
1512: 'N'
1513: FROM cst_layer_cost_details clcd
1514: WHERE layer_id = i_layer_id;
1515: ELSE
1516: l_stmt_num := 25;
1517: INSERT

Line 2390: from cst_layer_cost_details

2386: if (l_debug = 'Y') then
2387: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into MCACD for expense item...');
2388: end if;
2389: select count(*) into l_count
2390: from cst_layer_cost_details
2391: where layer_id = i_layer_id;
2392:
2393: if (l_count > 0) then
2394: insert into mtl_cst_actual_cost_details (

Line 2439: from cst_layer_cost_details clcd

2435: clcd.item_cost,
2436: 'N',
2437: 0,
2438: 'N'
2439: from cst_layer_cost_details clcd
2440: where layer_id = i_layer_id;
2441: else
2442: insert into mtl_cst_actual_cost_details (
2443: transaction_id,

Line 3837: from cst_layer_cost_details

3833: l_stmt_num := 40;
3834:
3835: select count(*)
3836: into l_mat_ovhds
3837: from cst_layer_cost_details
3838: where layer_id = i_layer_id
3839: and cost_element_id = 2
3840: and level_type = 1;
3841:

Line 3928: from cst_layer_cost_details clcd

3924: i_prg_id,
3925: sysdate,
3926: clcd.item_cost,
3927: 'N'
3928: from cst_layer_cost_details clcd
3929: where layer_id = i_layer_id
3930: and cost_element_id = 2
3931: and level_type = 1;
3932: end if;

Line 4357: from cst_layer_cost_details clcd

4353:
4354: update mtl_cst_actual_cost_details mcacd
4355: set prior_cost =
4356: (select clcd.item_cost
4357: from cst_layer_cost_details clcd
4358: where clcd.layer_id = i_layer_id
4359: and clcd.cost_element_id = mcacd.cost_element_id
4360: and clcd.level_type = mcacd.level_type)
4361: where mcacd.transaction_id = i_txn_id

Line 4367: from cst_layer_cost_details clcd

4363: and mcacd.layer_id = i_layer_id
4364: and mcacd.transaction_action_id = i_txn_action_id
4365: and exists
4366: (select 'there is details in clcd'
4367: from cst_layer_cost_details clcd
4368: where clcd.layer_id = i_layer_id
4369: and clcd.cost_element_id = mcacd.cost_element_id
4370: and clcd.level_type = mcacd.level_type);
4371:

Line 4421: FROM cst_layer_cost_details CLCD

4417: NULL,
4418: 'N',
4419: 0,
4420: 'N'
4421: FROM cst_layer_cost_details CLCD
4422: WHERE layer_id = i_layer_id
4423: AND NOT EXISTS(
4424: SELECT 'this detail is not in MCACD already'
4425: FROM mtl_cst_actual_cost_details MCACD

Line 4433: Update cst_layer_cost_details if i_no_update_qty is not set.

4429: AND MCACD.cost_element_id = CLCD.cost_element_id
4430: AND MCACD.level_type = CLCD.level_type);
4431:
4432: /*******************************************************************
4433: ** Update cst_layer_cost_details if i_no_update_qty is not set. **
4434: ** Since CQL quantity before this transaction is still needed by **
4435: ** CSTPAVCP.update_mmt, CQL quantity and cost information will be **
4436: ** updated later. **
4437: ********************************************************************/

Line 4468: update cst_layer_cost_details clcd

4464:
4465: /* Replaced stmt 25, 30 for Bug 15979260: Performance issue.
4466: Instead of resummarizing all the layers, simply use the value change
4467: of the current transaction to recalculate the cost*/
4468: update cst_layer_cost_details clcd
4469: set item_cost =
4470: (select (clcd.item_cost * l_layer_qty
4471: +
4472: nvl(sum((decode(i_txn_action_id, 24,

Line 4494: insert into cst_layer_cost_details(

4490: and mclacd2.cost_element_id = clcd.cost_element_id);
4491:
4492: l_stmt_num := 30;
4493:
4494: insert into cst_layer_cost_details(
4495: layer_id,
4496: cost_element_id,
4497: level_type,
4498: last_update_date,

Line 4527: from cst_layer_cost_details clcd

4523: from mtl_cst_layer_act_cost_details mclacd
4524: where mclacd.transaction_id = i_txn_id
4525: and mclacd.layer_id = i_layer_id
4526: and not exists (select 1
4527: from cst_layer_cost_details clcd
4528: where clcd.layer_id = mclacd.layer_id
4529: and clcd.level_type = mclacd.level_type
4530: and clcd.cost_element_id = mclacd.cost_element_id)
4531: GROUP BY

Line 4538: delete from cst_layer_cost_details

4534: mclacd.level_type;
4535:
4536:
4537: /* Commented for Bug 15979260
4538: delete from cst_layer_cost_details
4539: where layer_id = i_layer_id;
4540:
4541: l_stmt_num := 30;
4542:

Line 4543: insert into cst_layer_cost_details(

4539: where layer_id = i_layer_id;
4540:
4541: l_stmt_num := 30;
4542:
4543: insert into cst_layer_cost_details(
4544: layer_id,
4545: cost_element_id,
4546: level_type,
4547: last_update_date,

Line 4588: from cst_layer_cost_details clcd

4584:
4585: update mtl_cst_actual_cost_details mcacd
4586: set new_cost =
4587: (select clcd.item_cost
4588: from cst_layer_cost_details clcd
4589: where clcd.layer_id = i_layer_id
4590: and clcd.cost_element_id = mcacd.cost_element_id
4591: and clcd.level_type = mcacd.level_type)
4592: where mcacd.organization_id = i_org_id

Line 4704: from cst_layer_cost_details clcd

4700: where v.layer_id = i_layer_id)
4701: where cql.layer_id = i_layer_id
4702: and exists
4703: (select 'there is detail cost'
4704: from cst_layer_cost_details clcd
4705: where clcd.layer_id = i_layer_id);
4706:
4707: /********************************************************************
4708: ** Update Item Cost and Item Cost Details **