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.

[Home] [Help]

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 2555: FROM mtl_cst_txn_cost_details

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

Line 2607: FROM mtl_cst_txn_cost_details ctcd

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

Line 2743: from mtl_cst_txn_cost_details

2739: l_actual_cost_table := 'MCACD';
2740: else
2741: select count(*)
2742: into l_txn_cost_exists
2743: from mtl_cst_txn_cost_details
2744: where transaction_id = i_txn_id
2745: and organization_id = i_org_id;
2746:
2747: if (l_txn_cost_exists > 0) then

Line 4752: from mtl_cst_txn_cost_details ctcd

4748: -- check for existence of mctcd
4749: l_stmt_num := 7;
4750: select count(*)
4751: into l_mctcd_exist
4752: from mtl_cst_txn_cost_details ctcd
4753: where ctcd.transaction_id = i_txn_id;
4754:
4755: /* if l_mctcd_exist = 0 then
4756: raise no_mctcd_error;

Line 4866: FROM mtl_cst_txn_cost_details ctcd,

4862: ),
4863: 0
4864: )
4865: )
4866: FROM mtl_cst_txn_cost_details ctcd,
4867: cst_inv_layers cil,
4868: cst_inv_layer_cost_details cilcd
4869: WHERE ctcd.transaction_id = i_txn_id
4870: AND ctcd.organization_id = i_org_id

Line 5318: INSERT INTO MTL_CST_TXN_COST_DETAILS (

5314: end if;
5315:
5316: if (l_layer_id <> 0) then
5317:
5318: INSERT INTO MTL_CST_TXN_COST_DETAILS (
5319: TRANSACTION_ID,
5320: ORGANIZATION_ID,
5321: INVENTORY_ITEM_ID,
5322: COST_ELEMENT_ID,

Line 5361: UPDATE MTL_CST_TXN_COST_DETAILS mctcd

5357: FROM CST_INV_LAYER_COST_DETAILS CILCD
5358: WHERE CILCD.LAYER_ID = l_layer_id
5359: AND CILCD.INV_LAYER_ID = i_inv_layer_id;
5360:
5361: UPDATE MTL_CST_TXN_COST_DETAILS mctcd
5362: set (VALUE_CHANGE,
5363: PERCENTAGE_CHANGE,
5364: NEW_AVERAGE_COST)
5365: =

Line 5388: INSERT INTO MTL_CST_TXN_COST_DETAILS (

5384: else
5385:
5386: /* No layer exists , hence use THIS level MATERIAL row */
5387:
5388: INSERT INTO MTL_CST_TXN_COST_DETAILS (
5389: TRANSACTION_ID,
5390: ORGANIZATION_ID,
5391: INVENTORY_ITEM_ID,
5392: COST_ELEMENT_ID,

Line 5517: * insert each elements into MTL_CST_TXN_COST_DETAILS.

5513: raise cost_det_new_insert_error;
5514: end if;
5515:
5516: /* If layer detail exist, then calculate proportional costs and
5517: * insert each elements into MTL_CST_TXN_COST_DETAILS.
5518: */
5519:
5520: if (l_layer_id <> 0) then
5521:

Line 5566: INSERT INTO MTL_CST_TXN_COST_DETAILS (

5562: WHERE LAYER_ID = l_layer_id
5563: AND INV_LAYER_ID = i_inv_layer_id;
5564: end if;
5565:
5566: INSERT INTO MTL_CST_TXN_COST_DETAILS (
5567: TRANSACTION_ID,
5568: ORGANIZATION_ID,
5569: INVENTORY_ITEM_ID,
5570: COST_ELEMENT_ID,

Line 5631: INSERT INTO MTL_CST_TXN_COST_DETAILS (

5627: raise cost_det_new_insert_error;
5628: end if;
5629:
5630:
5631: INSERT INTO MTL_CST_TXN_COST_DETAILS (
5632: TRANSACTION_ID,
5633: ORGANIZATION_ID,
5634: INVENTORY_ITEM_ID,
5635: COST_ELEMENT_ID,