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 2389: from cst_layer_cost_details

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

Line 2438: from cst_layer_cost_details clcd

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

Line 3818: from cst_layer_cost_details

3814: l_stmt_num := 40;
3815:
3816: select count(*)
3817: into l_mat_ovhds
3818: from cst_layer_cost_details
3819: where layer_id = i_layer_id
3820: and cost_element_id = 2
3821: and level_type = 1;
3822:

Line 3907: from cst_layer_cost_details clcd

3903: i_prg_id,
3904: sysdate,
3905: clcd.item_cost,
3906: 'N'
3907: from cst_layer_cost_details clcd
3908: where layer_id = i_layer_id
3909: and cost_element_id = 2
3910: and level_type = 1;
3911: end if;

Line 4335: from cst_layer_cost_details clcd

4331:
4332: update mtl_cst_actual_cost_details mcacd
4333: set prior_cost =
4334: (select clcd.item_cost
4335: from cst_layer_cost_details clcd
4336: where clcd.layer_id = i_layer_id
4337: and clcd.cost_element_id = mcacd.cost_element_id
4338: and clcd.level_type = mcacd.level_type)
4339: where mcacd.transaction_id = i_txn_id

Line 4345: from cst_layer_cost_details clcd

4341: and mcacd.layer_id = i_layer_id
4342: and mcacd.transaction_action_id = i_txn_action_id
4343: and exists
4344: (select 'there is details in clcd'
4345: from cst_layer_cost_details clcd
4346: where clcd.layer_id = i_layer_id
4347: and clcd.cost_element_id = mcacd.cost_element_id
4348: and clcd.level_type = mcacd.level_type);
4349:

Line 4399: FROM cst_layer_cost_details CLCD

4395: NULL,
4396: 'N',
4397: 0,
4398: 'N'
4399: FROM cst_layer_cost_details CLCD
4400: WHERE layer_id = i_layer_id
4401: AND NOT EXISTS(
4402: SELECT 'this detail is not in MCACD already'
4403: FROM mtl_cst_actual_cost_details MCACD

Line 4411: ** Update cst_layer_cost_details if i_no_update_qty is not set. **

4407: AND MCACD.cost_element_id = CLCD.cost_element_id
4408: AND MCACD.level_type = CLCD.level_type);
4409:
4410: /*******************************************************************
4411: ** Update cst_layer_cost_details if i_no_update_qty is not set. **
4412: ** Since CQL quantity before this transaction is still needed by **
4413: ** CSTPAVCP.update_mmt, CQL quantity and cost information will be **
4414: ** updated later. **
4415: ********************************************************************/

Line 4435: delete from cst_layer_cost_details

4431: where cil.layer_id = i_layer_id;
4432:
4433: l_stmt_num := 25;
4434:
4435: delete from cst_layer_cost_details
4436: where layer_id = i_layer_id;
4437:
4438: l_stmt_num := 30;
4439:

Line 4440: insert into cst_layer_cost_details(

4436: where layer_id = i_layer_id;
4437:
4438: l_stmt_num := 30;
4439:
4440: insert into cst_layer_cost_details(
4441: layer_id,
4442: cost_element_id,
4443: level_type,
4444: last_update_date,

Line 4484: from cst_layer_cost_details clcd

4480:
4481: update mtl_cst_actual_cost_details mcacd
4482: set new_cost =
4483: (select clcd.item_cost
4484: from cst_layer_cost_details clcd
4485: where clcd.layer_id = i_layer_id
4486: and clcd.cost_element_id = mcacd.cost_element_id
4487: and clcd.level_type = mcacd.level_type)
4488: where mcacd.organization_id = i_org_id

Line 4600: from cst_layer_cost_details clcd

4596: where v.layer_id = i_layer_id)
4597: where cql.layer_id = i_layer_id
4598: and exists
4599: (select 'there is detail cost'
4600: from cst_layer_cost_details clcd
4601: where clcd.layer_id = i_layer_id);
4602:
4603: /********************************************************************
4604: ** Update Item Cost and Item Cost Details **