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 4467: from cst_inv_layer_cost_details cilcd,

4463: i_prg_appl_id,
4464: i_prg_id,
4465: sysdate,
4466: (sum((cilcd.layer_cost*cil.layer_quantity)/l_total_layer_qty)) -- modified for bug#3835412
4467: from cst_inv_layer_cost_details cilcd,
4468: cst_inv_layers cil
4469: where cil.layer_id = i_layer_id
4470: and cil.organization_id = i_org_id
4471: and cil.inventory_item_id = i_item_id

Line 4868: cst_inv_layer_cost_details cilcd

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

Line 4896: Delete from cst_inv_layer_cost_details and insert the new rows

4892: raise neg_cost_error;
4893: end if; */ --removed for bug #4005770
4894:
4895: /************************************************************************
4896: ** Delete from cst_inv_layer_cost_details and insert the new rows **
4897: ** from mtl_cst_actual_cost_details. **
4898: ***********************************************************************/
4899: l_stmt_num := 30;
4900:

Line 4901: Delete from cst_inv_layer_cost_details

4897: ** from mtl_cst_actual_cost_details. **
4898: ***********************************************************************/
4899: l_stmt_num := 30;
4900:
4901: Delete from cst_inv_layer_cost_details
4902: where layer_id = i_layer_id
4903: and inv_layer_id = l_inv_layer_id;
4904:
4905: l_stmt_num := 40;

Line 4906: Insert into cst_inv_layer_cost_details (

4902: where layer_id = i_layer_id
4903: and inv_layer_id = l_inv_layer_id;
4904:
4905: l_stmt_num := 40;
4906: Insert into cst_inv_layer_cost_details (
4907: layer_id,
4908: inv_layer_id,
4909: cost_element_id,
4910: level_type,

Line 4964: from cst_inv_layer_cost_details cilcd

4960: i_prg_appl_id,
4961: i_prg_id,
4962: sysdate,
4963: nvl(sum(layer_cost),0)
4964: from cst_inv_layer_cost_details cilcd
4965: where cilcd.layer_id = i_layer_id
4966: and cilcd.inv_layer_id = l_inv_layer_id)
4967: where cil.layer_id = i_layer_id
4968: and cil.inv_layer_id = l_inv_layer_id

Line 4971: from cst_inv_layer_cost_details cilcd

4967: where cil.layer_id = i_layer_id
4968: and cil.inv_layer_id = l_inv_layer_id
4969: and exists
4970: (select 'there is detail cost'
4971: from cst_inv_layer_cost_details cilcd
4972: where cilcd.layer_id = i_layer_id
4973: and cilcd.inv_layer_id = l_inv_layer_id);
4974:
4975:

Line 5185: insert into cst_inv_layer_cost_details (

5181: i_prg_id,
5182: sysdate
5183: from dual;
5184:
5185: insert into cst_inv_layer_cost_details (
5186: layer_id,
5187: inv_layer_id,
5188: cost_element_id,
5189: level_type,

Line 5357: FROM CST_INV_LAYER_COST_DETAILS CILCD

5353: i_request_id,
5354: i_prog_appl_id,
5355: i_prog_id,
5356: sysdate
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

Line 5494: CST_INV_LAYER_COST_DETAILS CILCD

5490:
5491: cursor cost_elmt_ids is
5492: SELECT CILCD.COST_ELEMENT_ID
5493: FROM CST_INV_LAYERS CIL,
5494: CST_INV_LAYER_COST_DETAILS CILCD
5495: WHERE CIL.LAYER_ID = l_layer_id
5496: AND CIL.INV_LAYER_ID = i_inv_layer_id
5497: AND CILCD.LAYER_ID = l_layer_id
5498: AND CILCD.INV_LAYER_ID = i_inv_layer_id;

Line 5561: FROM CST_INV_LAYER_COST_DETAILS

5557:
5558: if (cl_item_cost = 0) then
5559: SELECT count(COST_ELEMENT_ID)
5560: INTO cost_element_count
5561: FROM CST_INV_LAYER_COST_DETAILS
5562: WHERE LAYER_ID = l_layer_id
5563: AND INV_LAYER_ID = i_inv_layer_id;
5564: end if;
5565:

Line 5608: FROM CST_INV_LAYERS CIL, CST_INV_LAYER_COST_DETAILS CILCD

5604: i_request_id,
5605: i_prog_appl_id,
5606: i_prog_id,
5607: sysdate
5608: FROM CST_INV_LAYERS CIL, CST_INV_LAYER_COST_DETAILS CILCD
5609: WHERE CIL.LAYER_ID = l_layer_id
5610: AND CIL.INV_LAYER_ID = i_inv_layer_id
5611: AND CILCD.LAYER_ID = l_layer_id
5612: AND CILCD.INV_LAYER_ID = i_inv_layer_id;

Line 6183: delete from cst_inv_layer_cost_details

6179: unburdened_cost = 0
6180: where organization_id = i_org_id
6181: and inventory_item_id = i_item_id;
6182:
6183: delete from cst_inv_layer_cost_details
6184: where inv_layer_id IN (select inv_layer_id
6185: from cst_inv_layers
6186: where organization_id = i_org_id
6187: and inventory_item_id = i_item_id);