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 MTL_CST_TXN_COST_DETAILS

Line 398: from mtl_cst_txn_cost_details mctcd

394: NULL,
395: 'N',
396: 0,
397: 'N'
398: from mtl_cst_txn_cost_details mctcd
399: where mctcd.transaction_id = i_txn_id
400: and mctcd.organization_id = i_org_id
401: and mctcd.transaction_cost >= 0;
402: end if;

Line 820: from mtl_cst_txn_cost_details mctcd

816: i_req_id,
817: i_prg_appl_id,
818: i_prg_id,
819: sysdate
820: from mtl_cst_txn_cost_details mctcd
821: where mctcd.organization_id = i_org_id
822: and mctcd.transaction_id = i_txn_id ;
823:
824: -- case 4 CREATE None None

Line 1089: FROM cst_inv_layer_cost_details cilcd,mtl_cst_txn_cost_details mctcd

1085: i_req_id,
1086: i_prg_appl_id,
1087: i_prg_id,
1088: sysdate
1089: FROM cst_inv_layer_cost_details cilcd,mtl_cst_txn_cost_details mctcd
1090: where mctcd.organization_id(+) = i_org_id
1091: and mctcd.transaction_id (+) = i_txn_id
1092: and cilcd.inv_layer_id = i_cur_layer_id
1093: and cilcd.cost_element_id = mctcd.cost_element_id (+)

Line 1118: FROM cst_inv_layer_cost_details cilcd,mtl_cst_txn_cost_details mctcd

1114: i_req_id,
1115: i_prg_appl_id,
1116: i_prg_id,
1117: sysdate
1118: FROM cst_inv_layer_cost_details cilcd,mtl_cst_txn_cost_details mctcd
1119: where mctcd.organization_id = i_org_id
1120: and mctcd.transaction_id = i_txn_id
1121: and cilcd.inv_layer_id (+) = i_cur_layer_id
1122: and cilcd.cost_element_id(+) = mctcd.cost_element_id

Line 1402: FROM mtl_cst_txn_cost_details

1398:
1399: l_stmt_num := 5;
1400: SELECT COUNT(*)
1401: INTO l_count
1402: FROM mtl_cst_txn_cost_details
1403: WHERE transaction_id = i_txn_id
1404: AND organization_id = i_org_id;
1405:
1406: IF (l_count > 0) THEN

Line 1454: FROM mtl_cst_txn_cost_details ctcd

1450: 0,
1451: 'Y',
1452: 0,
1453: 'N'
1454: FROM mtl_cst_txn_cost_details ctcd
1455: WHERE ctcd.transaction_id = i_txn_id
1456: AND ctcd.organization_id = i_org_id
1457: /*AND ctcd.transaction_cost >= 0*/; -- commented for bug#3835412
1458: ELSE

Line 1589: FROM mtl_cst_txn_cost_details

1585: ELSE
1586: l_stmt_num := 35;
1587: SELECT count(*)
1588: INTO l_count
1589: FROM mtl_cst_txn_cost_details
1590: WHERE transaction_id = i_txn_id
1591: AND organization_id = i_org_id
1592: /* AND transaction_cost >= 0 */; -- commented for bug#3835412
1593:

Line 2556: FROM mtl_cst_txn_cost_details

2552:
2553: l_stmt_num := 21;
2554: SELECT COUNT(*)
2555: INTO l_count
2556: FROM mtl_cst_txn_cost_details
2557: WHERE transaction_id = i_txn_id
2558: AND organization_id = i_org_id;
2559:
2560: IF (l_count > 0) THEN

Line 2608: FROM mtl_cst_txn_cost_details ctcd

2604: 0,
2605: 'Y',
2606: 0,
2607: 'N'
2608: FROM mtl_cst_txn_cost_details ctcd
2609: WHERE ctcd.transaction_id = i_txn_id
2610: AND ctcd.organization_id = i_org_id ;
2611:
2612: else

Line 2744: from mtl_cst_txn_cost_details

2740: l_actual_cost_table := 'MCACD';
2741: else
2742: select count(*)
2743: into l_txn_cost_exists
2744: from mtl_cst_txn_cost_details
2745: where transaction_id = i_txn_id
2746: and organization_id = i_org_id;
2747:
2748: /*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 4856: from mtl_cst_txn_cost_details ctcd

4852: -- check for existence of mctcd
4853: l_stmt_num := 7;
4854: select count(*)
4855: into l_mctcd_exist
4856: from mtl_cst_txn_cost_details ctcd
4857: where ctcd.transaction_id = i_txn_id;
4858:
4859: /* if l_mctcd_exist = 0 then
4860: raise no_mctcd_error;

Line 4970: FROM mtl_cst_txn_cost_details ctcd,

4966: ),
4967: 0
4968: )
4969: )
4970: FROM mtl_cst_txn_cost_details ctcd,
4971: cst_inv_layers cil,
4972: cst_inv_layer_cost_details cilcd
4973: WHERE ctcd.transaction_id = i_txn_id
4974: AND ctcd.organization_id = i_org_id

Line 5422: INSERT INTO MTL_CST_TXN_COST_DETAILS (

5418: end if;
5419:
5420: if (l_layer_id <> 0) then
5421:
5422: INSERT INTO MTL_CST_TXN_COST_DETAILS (
5423: TRANSACTION_ID,
5424: ORGANIZATION_ID,
5425: INVENTORY_ITEM_ID,
5426: COST_ELEMENT_ID,

Line 5465: UPDATE MTL_CST_TXN_COST_DETAILS mctcd

5461: FROM CST_INV_LAYER_COST_DETAILS CILCD
5462: WHERE CILCD.LAYER_ID = l_layer_id
5463: AND CILCD.INV_LAYER_ID = i_inv_layer_id;
5464:
5465: UPDATE MTL_CST_TXN_COST_DETAILS mctcd
5466: set (VALUE_CHANGE,
5467: PERCENTAGE_CHANGE,
5468: NEW_AVERAGE_COST)
5469: =

Line 5492: INSERT INTO MTL_CST_TXN_COST_DETAILS (

5488: else
5489:
5490: /* No layer exists , hence use THIS level MATERIAL row */
5491:
5492: INSERT INTO MTL_CST_TXN_COST_DETAILS (
5493: TRANSACTION_ID,
5494: ORGANIZATION_ID,
5495: INVENTORY_ITEM_ID,
5496: COST_ELEMENT_ID,

Line 5621: * insert each elements into MTL_CST_TXN_COST_DETAILS.

5617: raise cost_det_new_insert_error;
5618: end if;
5619:
5620: /* If layer detail exist, then calculate proportional costs and
5621: * insert each elements into MTL_CST_TXN_COST_DETAILS.
5622: */
5623:
5624: if (l_layer_id <> 0) then
5625:

Line 5670: INSERT INTO MTL_CST_TXN_COST_DETAILS (

5666: WHERE LAYER_ID = l_layer_id
5667: AND INV_LAYER_ID = i_inv_layer_id;
5668: end if;
5669:
5670: INSERT INTO MTL_CST_TXN_COST_DETAILS (
5671: TRANSACTION_ID,
5672: ORGANIZATION_ID,
5673: INVENTORY_ITEM_ID,
5674: COST_ELEMENT_ID,

Line 5735: INSERT INTO MTL_CST_TXN_COST_DETAILS (

5731: raise cost_det_new_insert_error;
5732: end if;
5733:
5734:
5735: INSERT INTO MTL_CST_TXN_COST_DETAILS (
5736: TRANSACTION_ID,
5737: ORGANIZATION_ID,
5738: INVENTORY_ITEM_ID,
5739: COST_ELEMENT_ID,