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_INV_LAYER_COST_DETAILS

Line 919: FROM cst_inv_layer_cost_details cilcd1,

915: i_req_id,
916: i_prg_appl_id,
917: i_prg_id,
918: sysdate
919: FROM cst_inv_layer_cost_details cilcd1,
920: cst_inv_layer_cost_details cilcd2
921: where cilcd1.inv_layer_id (+) = i_actual_layer_id
922: and cilcd2.inv_layer_id = i_cur_layer_id
923: and cilcd1.cost_element_id(+) = cilcd2.cost_element_id

Line 920: cst_inv_layer_cost_details cilcd2

916: i_prg_appl_id,
917: i_prg_id,
918: sysdate
919: FROM cst_inv_layer_cost_details cilcd1,
920: cst_inv_layer_cost_details cilcd2
921: where cilcd1.inv_layer_id (+) = i_actual_layer_id
922: and cilcd2.inv_layer_id = i_cur_layer_id
923: and cilcd1.cost_element_id(+) = cilcd2.cost_element_id
924: and cilcd1.level_type (+) = cilcd2.level_type

Line 948: FROM cst_inv_layer_cost_details cilcd1,

944: i_req_id,
945: i_prg_appl_id,
946: i_prg_id,
947: sysdate
948: FROM cst_inv_layer_cost_details cilcd1,
949: cst_inv_layer_cost_details cilcd2
950: where cilcd1.inv_layer_id = i_actual_layer_id
951: and cilcd2.inv_layer_id(+) = i_cur_layer_id
952: and cilcd1.cost_element_id = cilcd2.cost_element_id (+)

Line 949: cst_inv_layer_cost_details cilcd2

945: i_prg_appl_id,
946: i_prg_id,
947: sysdate
948: FROM cst_inv_layer_cost_details cilcd1,
949: cst_inv_layer_cost_details cilcd2
950: where cilcd1.inv_layer_id = i_actual_layer_id
951: and cilcd2.inv_layer_id(+) = i_cur_layer_id
952: and cilcd1.cost_element_id = cilcd2.cost_element_id (+)
953: and cilcd1.level_type = cilcd2.level_type(+);

Line 1003: FROM cst_inv_layer_cost_details cilcd,mtl_cst_actual_cost_details mcacd

999: i_req_id,
1000: i_prg_appl_id,
1001: i_prg_id,
1002: sysdate
1003: FROM cst_inv_layer_cost_details cilcd,mtl_cst_actual_cost_details mcacd
1004: where mcacd.organization_id (+) = i_org_id
1005: and mcacd.transaction_id(+) = i_txn_id
1006: and cilcd.inv_layer_id = i_cur_layer_id
1007: and cilcd.cost_element_id = mcacd.cost_element_id (+)

Line 1033: FROM cst_inv_layer_cost_details cilcd,mtl_cst_actual_cost_details mcacd

1029: i_req_id,
1030: i_prg_appl_id,
1031: i_prg_id,
1032: sysdate
1033: FROM cst_inv_layer_cost_details cilcd,mtl_cst_actual_cost_details mcacd
1034: where mcacd.organization_id = i_org_id
1035: and mcacd.transaction_id = i_txn_id
1036: and cilcd.inv_layer_id(+) = i_cur_layer_id
1037: and cilcd.cost_element_id(+) = mcacd.cost_element_id

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 1198: from cst_inv_layers cil, cst_inv_layer_cost_details cilcd

1194: i_req_id,
1195: i_prg_appl_id,
1196: i_prg_id,
1197: sysdate
1198: from cst_inv_layers cil, cst_inv_layer_cost_details cilcd
1199: where cil.inv_layer_id = cilcd.inv_layer_id
1200: and cil.layer_id = cilcd.layer_id
1201: and cil.inv_layer_id = i_actual_layer_id;
1202:

Line 1273: from cst_inv_layers cil, cst_inv_layer_cost_details cilcd

1269: i_req_id,
1270: i_prg_appl_id,
1271: i_prg_id,
1272: sysdate
1273: from cst_inv_layers cil, cst_inv_layer_cost_details cilcd
1274: where cil.inv_layer_id = cilcd.inv_layer_id
1275: and cil.layer_id = cilcd.layer_id
1276: and cil.inv_layer_id = i_actual_layer_id;
1277:

Line 2021: FROM cst_inv_layer_cost_details

2017: /* Delete cost details for the inventory layer from CILCD. No rows should
2018: be present. Just a safety check */
2019: l_stmt_num := 120;
2020: DELETE
2021: FROM cst_inv_layer_cost_details
2022: WHERE inv_layer_id = l_inv_layer_id;
2023:
2024: /* Copy cost details by cost element and level into CILCD */
2025: l_stmt_num := 125;

Line 2027: INTO cst_inv_layer_cost_details (

2023:
2024: /* Copy cost details by cost element and level into CILCD */
2025: l_stmt_num := 125;
2026: INSERT
2027: INTO cst_inv_layer_cost_details (
2028: layer_id,
2029: inv_layer_id,
2030: level_type,
2031: cost_element_id,

Line 2073: FROM cst_inv_layer_cost_details

2069: IF (nvl(i_interorg_rec,-1) <> 3) THEN
2070: UPDATE cst_inv_layers
2071: SET layer_cost = (
2072: SELECT SUM(layer_cost)
2073: FROM cst_inv_layer_cost_details
2074: WHERE inv_layer_id = l_inv_layer_id
2075: GROUP
2076: BY inv_layer_id),
2077: (unburdened_cost,burden_cost) = (

Line 2084: FROM cst_inv_layer_cost_details

2080: layer_cost)),
2081: SUM(decode(cost_element_id,
2082: 2,decode(level_type,1,layer_cost,0),
2083: 0))
2084: FROM cst_inv_layer_cost_details
2085: WHERE inv_layer_id = l_inv_layer_id
2086: GROUP
2087: BY inv_layer_id)
2088: WHERE layer_id = i_layer_id

Line 2753: table 'cst_inv_layer_cost_details' then mtl_cst_layer_actual_cost_details

2749: BUG 12751466
2750: In case when prior onhand quantity and item cost is zero, if
2751: wip component issue transaction for an asset item is performed
2752: in asset subinventory,if inventory layer doesnot exists in
2753: table 'cst_inv_layer_cost_details' then mtl_cst_layer_actual_cost_details
2754: is inserted with zero cost against this level Material element.
2755: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
2756:
2757: select count(*)

Line 2759: from cst_inv_layer_cost_details

2755: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
2756:
2757: select count(*)
2758: into l_inv_layer_exists
2759: from cst_inv_layer_cost_details
2760: where layer_id=i_layer_id;
2761:
2762: if (l_txn_cost_exists > 0) then
2763: l_actual_cost_table := 'MCTCD';

Line 4570: from cst_inv_layer_cost_details cilcd,

4566: i_prg_appl_id,
4567: i_prg_id,
4568: sysdate,
4569: (sum((cilcd.layer_cost*cil.layer_quantity)/l_total_layer_qty)) -- modified for bug#3835412
4570: from cst_inv_layer_cost_details cilcd,
4571: cst_inv_layers cil
4572: where cil.layer_id = i_layer_id*/
4573: /*commented for bug 15979260
4574: and cil.organization_id = i_org_id

Line 4972: cst_inv_layer_cost_details cilcd

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
4975: AND cil.layer_id = i_layer_id
4976: AND cil.inv_layer_id = l_inv_layer_id

Line 5000: Delete from cst_inv_layer_cost_details and insert the new rows

4996: raise neg_cost_error;
4997: end if; */ --removed for bug #4005770
4998:
4999: /************************************************************************
5000: ** Delete from cst_inv_layer_cost_details and insert the new rows **
5001: ** from mtl_cst_actual_cost_details. **
5002: ***********************************************************************/
5003: l_stmt_num := 30;
5004:

Line 5005: Delete from cst_inv_layer_cost_details

5001: ** from mtl_cst_actual_cost_details. **
5002: ***********************************************************************/
5003: l_stmt_num := 30;
5004:
5005: Delete from cst_inv_layer_cost_details
5006: where layer_id = i_layer_id
5007: and inv_layer_id = l_inv_layer_id;
5008:
5009: l_stmt_num := 40;

Line 5010: Insert into cst_inv_layer_cost_details (

5006: where layer_id = i_layer_id
5007: and inv_layer_id = l_inv_layer_id;
5008:
5009: l_stmt_num := 40;
5010: Insert into cst_inv_layer_cost_details (
5011: layer_id,
5012: inv_layer_id,
5013: cost_element_id,
5014: level_type,

Line 5068: from cst_inv_layer_cost_details cilcd

5064: i_prg_appl_id,
5065: i_prg_id,
5066: sysdate,
5067: nvl(sum(layer_cost),0)
5068: from cst_inv_layer_cost_details cilcd
5069: where cilcd.layer_id = i_layer_id
5070: and cilcd.inv_layer_id = l_inv_layer_id)
5071: where cil.layer_id = i_layer_id
5072: and cil.inv_layer_id = l_inv_layer_id

Line 5075: from cst_inv_layer_cost_details cilcd

5071: where cil.layer_id = i_layer_id
5072: and cil.inv_layer_id = l_inv_layer_id
5073: and exists
5074: (select 'there is detail cost'
5075: from cst_inv_layer_cost_details cilcd
5076: where cilcd.layer_id = i_layer_id
5077: and cilcd.inv_layer_id = l_inv_layer_id);
5078:
5079:

Line 5289: insert into cst_inv_layer_cost_details (

5285: i_prg_id,
5286: sysdate
5287: from dual;
5288:
5289: insert into cst_inv_layer_cost_details (
5290: layer_id,
5291: inv_layer_id,
5292: cost_element_id,
5293: level_type,

Line 5461: FROM CST_INV_LAYER_COST_DETAILS CILCD

5457: i_request_id,
5458: i_prog_appl_id,
5459: i_prog_id,
5460: sysdate
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

Line 5598: CST_INV_LAYER_COST_DETAILS CILCD

5594:
5595: cursor cost_elmt_ids is
5596: SELECT CILCD.COST_ELEMENT_ID
5597: FROM CST_INV_LAYERS CIL,
5598: CST_INV_LAYER_COST_DETAILS CILCD
5599: WHERE CIL.LAYER_ID = l_layer_id
5600: AND CIL.INV_LAYER_ID = i_inv_layer_id
5601: AND CILCD.LAYER_ID = l_layer_id
5602: AND CILCD.INV_LAYER_ID = i_inv_layer_id;

Line 5665: FROM CST_INV_LAYER_COST_DETAILS

5661:
5662: if (cl_item_cost = 0) then
5663: SELECT count(COST_ELEMENT_ID)
5664: INTO cost_element_count
5665: FROM CST_INV_LAYER_COST_DETAILS
5666: WHERE LAYER_ID = l_layer_id
5667: AND INV_LAYER_ID = i_inv_layer_id;
5668: end if;
5669:

Line 5712: FROM CST_INV_LAYERS CIL, CST_INV_LAYER_COST_DETAILS CILCD

5708: i_request_id,
5709: i_prog_appl_id,
5710: i_prog_id,
5711: sysdate
5712: FROM CST_INV_LAYERS CIL, CST_INV_LAYER_COST_DETAILS CILCD
5713: WHERE CIL.LAYER_ID = l_layer_id
5714: AND CIL.INV_LAYER_ID = i_inv_layer_id
5715: AND CILCD.LAYER_ID = l_layer_id
5716: AND CILCD.INV_LAYER_ID = i_inv_layer_id;

Line 6295: delete from cst_inv_layer_cost_details

6291: unburdened_cost = 0
6292: where organization_id = i_org_id
6293: and inventory_item_id = i_item_id;
6294:
6295: delete from cst_inv_layer_cost_details
6296: where inv_layer_id IN (select inv_layer_id
6297: from cst_inv_layers
6298: where organization_id = i_org_id
6299: and inventory_item_id = i_item_id);