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.CSTPSCCR dependencies on CST_ITEM_COST_DETAILS

Line 76: DELETE CST_ITEM_COST_DETAILS cicd

72: | Delete item costs that were generated by the previous cost |
73: | rollup. |
74: +------------------------------------------------------------*/
75:
76: DELETE CST_ITEM_COST_DETAILS cicd
77: WHERE cicd.COST_TYPE_ID = p_dest_cost_type_id
78: AND (cicd.ROLLUP_SOURCE_TYPE = 2
79: OR cicd.ROLLUP_SOURCE_TYPE = 3
80: )

Line 209: INSERT INTO CST_ITEM_COST_DETAILS (

205: | from the default cost type |
206: +------------------------------------------------------------*/
207: /* man: modfied the AND clause so that even defaulted rows
208: from the defaulted cost type would be copied over */
209: INSERT INTO CST_ITEM_COST_DETAILS (
210: INVENTORY_ITEM_ID,
211: COST_TYPE_ID,
212: LAST_UPDATE_DATE,
213: LAST_UPDATED_BY,

Line 280: CST_ITEM_COST_DETAILS cicd,

276: l_rollup_date, NULL)
277: FROM
278: CST_SC_LOW_LEVEL_CODES csllc,
279: CST_ITEM_COSTS cia,
280: CST_ITEM_COST_DETAILS cicd,
281: MTL_PARAMETERS mp
282: WHERE csllc.ROLLUP_ID = p_rollup_id
283: AND cia.ORGANIZATION_ID = csllc.organization_id
284: AND cia.INVENTORY_ITEM_ID = csllc.INVENTORY_ITEM_ID

Line 396: UPDATE cst_item_cost_details CICD

392: FROM cst_sc_lists CSL
393: WHERE CSL.rollup_id = p_rollup_id);
394:
395: l_stmt_num := 70;
396: UPDATE cst_item_cost_details CICD
397: SET (CICD.basis_factor, CICD.item_cost) =
398: (SELECT nvl(1/CIC.lot_size, CICD.basis_factor),
399: nvl(CICD.item_cost/(CICD.basis_factor*CIC.lot_size), CICD.item_cost)
400: FROM cst_item_costs CIC

Line 462: CST_ITEM_COST_DETAILS CICD

458:
459: CURSOR cd is
460: SELECT CICD.INVENTORY_ITEM_ID
461: FROM CST_SC_LOW_LEVEL_CODES CSLLC,
462: CST_ITEM_COST_DETAILS CICD
463: WHERE CSLLC.ROLLUP_ID = l_rollup_id
464: AND CICD.INVENTORY_ITEM_ID = CSLLC.INVENTORY_ITEM_ID
465: AND CICD.ORGANIZATION_ID = CSLLC.organization_id
466: AND CICD.COST_TYPE_ID = l_dest_cost_type_id

Line 485: CST_ITEM_COST_DETAILS CICD

481:
482: CURSOR cf is
483: SELECT CICD.INVENTORY_ITEM_ID
484: FROM CST_SC_LOW_LEVEL_CODES CSLLC,
485: CST_ITEM_COST_DETAILS CICD
486: WHERE CSLLC.ROLLUP_ID = l_rollup_id
487: AND CICD.INVENTORY_ITEM_ID = CSLLC.INVENTORY_ITEM_ID
488: AND CICD.ORGANIZATION_ID = CSLLC.organization_id
489: AND CICD.COST_TYPE_ID = l_dest_cost_type_id

Line 498: elsif (table_name = 'CST_ITEM_COST_DETAILS' and l_locking_flag = 2) then

494:
495: if (table_name = 'CST_ITEM_COSTS' and l_locking_flag = 2) then
496: OPEN cc;
497: status := SQLCODE;
498: elsif (table_name = 'CST_ITEM_COST_DETAILS' and l_locking_flag = 2) then
499: OPEN cd;
500: status := SQLCODE;
501: elsif (table_name = 'CST_ITEM_COSTS' and l_locking_flag = 1) then
502: OPEN ce;

Line 504: elsif (table_name = 'CST_ITEM_COST_DETAILS' and l_locking_flag = 1) then

500: status := SQLCODE;
501: elsif (table_name = 'CST_ITEM_COSTS' and l_locking_flag = 1) then
502: OPEN ce;
503: status := SQLCODE;
504: elsif (table_name = 'CST_ITEM_COST_DETAILS' and l_locking_flag = 1) then
505: OPEN cf;
506: status := SQLCODE;
507: else
508: status := NO_DATAS_FOUND;

Line 564: ** Lock the table of CST_ITEM_COST_DETAILS

560: err_buf := err_buf || status;
561: return(status);
562: else
563: /*
564: ** Lock the table of CST_ITEM_COST_DETAILS
565: */
566: -- SCAPI: use loop only if locking_flag is not yes
567: status := -54;
568: if (l_locking_flag = 1) then

Line 569: status := CSTPSCCR.cstrlock('CST_ITEM_COST_DETAILS',l_dest_cost_type_id,

565: */
566: -- SCAPI: use loop only if locking_flag is not yes
567: status := -54;
568: if (l_locking_flag = 1) then
569: status := CSTPSCCR.cstrlock('CST_ITEM_COST_DETAILS',l_dest_cost_type_id,
570: l_default_cost_type_id,
571: l_rollup_id,err_buf,l_locking_flag);
572: else
573: while (counter < NUM_TRIES and status = -54)

Line 575: status := CSTPSCCR.cstrlock('CST_ITEM_COST_DETAILS',

571: l_rollup_id,err_buf,l_locking_flag);
572: else
573: while (counter < NUM_TRIES and status = -54)
574: LOOP
575: status := CSTPSCCR.cstrlock('CST_ITEM_COST_DETAILS',
576: l_dest_cost_type_id, l_default_cost_type_id,
577: l_rollup_id,err_buf,l_locking_flag);
578: if status = -54 then
579: DBMS_LOCK.SLEEP(SLEEP_TIME);

Line 913: INSERT INTO CST_ITEM_COST_DETAILS (

909: | Note: Will use cursor for 1 item, mainly for create config |
910: | program. This improves performance from 150 sec to |
911: | less than a second in a database. |
912: +------------------------------------------------------------*/
913: INSERT INTO CST_ITEM_COST_DETAILS (
914: INVENTORY_ITEM_ID,
915: COST_TYPE_ID,
916: LAST_UPDATE_DATE,
917: LAST_UPDATED_BY,

Line 1105: INSERT INTO CST_ITEM_COST_DETAILS (

1101:
1102: --NOTE : Any changes done to the Above Insert statement need to be incorporated into this
1103: -- Statement as well since they are for similar purpose and are majorly similar.
1104: --======================================================================================
1105: INSERT INTO CST_ITEM_COST_DETAILS (
1106: inventory_item_id,
1107: cost_type_id,
1108: last_update_date,
1109: last_updated_by,

Line 1281: INSERT INTO CST_ITEM_COST_DETAILS (

1277: USAGE_RATE_OR_AMOUNT * BASIS_FACTOR * RESOURCE_RATE = Resource Value Factor
1278: In Previous code, the NET_YIELD_OR_SHRINKAGE_FACTOR was wrongly populated as 1 for BASIS_TYPE 4,
1279: instead of 1/(1-CIC.SHRINKAGE_FACTOR)
1280: */
1281: INSERT INTO CST_ITEM_COST_DETAILS (
1282: INVENTORY_ITEM_ID,
1283: COST_TYPE_ID,
1284: LAST_UPDATE_DATE,
1285: LAST_UPDATED_BY,

Line 1352: CST_ITEM_COST_DETAILS cicd,

1348: l_rollup_date, NULL)
1349: FROM
1350: CST_SC_LOW_LEVEL_CODES csllc,
1351: CST_ITEM_COSTS cia,
1352: CST_ITEM_COST_DETAILS cicd,
1353: CST_RESOURCE_OVERHEADS cro,
1354: CST_DEPARTMENT_OVERHEADS cdo,
1355: MTL_PARAMETERS mp
1356: WHERE csllc.ROLLUP_ID = l_rollup_id

Line 1415: INSERT INTO CST_ITEM_COST_DETAILS (

1411: sql_stmt_num := 80;
1412: /*------------------------------------------------------------+
1413: | Calculate the this level departmental overhead charges. |
1414: +------------------------------------------------------------*/
1415: INSERT INTO CST_ITEM_COST_DETAILS (
1416: INVENTORY_ITEM_ID,
1417: COST_TYPE_ID,
1418: LAST_UPDATE_DATE,
1419: LAST_UPDATED_BY,

Line 1615: UPDATE CST_ITEM_COST_DETAILS cicd

1611: l_ext_tbl
1612: LIMIT 1000;
1613:
1614: FORALL i IN l_inv_item_tbl.first..l_inv_item_tbl.last
1615: UPDATE CST_ITEM_COST_DETAILS cicd
1616: SET (BASIS_FACTOR,
1617: ITEM_COST) =
1618: (SELECT DECODE(cicd.BASIS_TYPE,
1619: 3,NVL(SUM(ROUND(cicd1.USAGE_RATE_OR_AMOUNT*

Line 1633: CST_ITEM_COST_DETAILS cicd1,

1629: l_ext_tbl(i)),
1630: 4,ROUND(cicd.USAGE_RATE_OR_AMOUNT*
1631: NVL(SUM(cicd1.ITEM_COST),0),l_ext_tbl(i)))
1632: FROM
1633: CST_ITEM_COST_DETAILS cicd1,
1634: CST_RESOURCE_OVERHEADS cro
1635: WHERE cicd1.INVENTORY_ITEM_ID = cicd.INVENTORY_ITEM_ID
1636: AND cicd1.ORGANIZATION_ID = l_org_id_tbl(i)
1637: AND cicd1.COST_TYPE_ID = l_dest_cost_type_id

Line 1721: INSERT INTO cst_item_cost_details

1717:
1718: sql_stmt_num := 112;
1719:
1720: FORALL i IN l_inv_item_tbl.first..l_inv_item_tbl.last
1721: INSERT INTO cst_item_cost_details
1722: (INVENTORY_ITEM_ID,
1723: COST_TYPE_ID,
1724: LAST_UPDATE_DATE,
1725: LAST_UPDATED_BY,

Line 1889: CST_ITEM_COST_DETAILS cicd,

1885: 5, cicd.resource_seq_num, null), null), null), null)
1886: FROM BOM_BILL_OF_MATERIALS bbom,
1887: BOM_INVENTORY_COMPONENTS bic,
1888: CST_ITEM_COSTS cia_assy,
1889: CST_ITEM_COST_DETAILS cicd,
1890: CST_ITEM_COSTS cia_comp,
1891: BOM_PARAMETERS bp,
1892: mtl_system_items msi,
1893: BOM_OPERATION_RESOURCES bomres

Line 2181: UPDATE CST_ITEM_COST_DETAILS cicd

2177:
2178: sql_stmt_num := 130;
2179:
2180:
2181: UPDATE CST_ITEM_COST_DETAILS cicd
2182: SET (ITEM_COST,BASIS_FACTOR) =
2183: (SELECT ROUND((cicd.USAGE_RATE_OR_AMOUNT *
2184: NVL(SUM(cicd1.ITEM_COST),0)),inv_cursor.ext_precision),
2185: NVL(SUM(cicd1.ITEM_COST),0) /

Line 2188: FROM CST_ITEM_COST_DETAILS cicd1

2184: NVL(SUM(cicd1.ITEM_COST),0)),inv_cursor.ext_precision),
2185: NVL(SUM(cicd1.ITEM_COST),0) /
2186: NVL(cicd.net_yield_or_shrinkage_factor,1) /
2187: DECODE(cicd.resource_rate,0 , 1 , NVL(cicd.resource_rate,1))
2188: FROM CST_ITEM_COST_DETAILS cicd1
2189: WHERE cicd1.ORGANIZATION_ID = inv_cursor.organization_id
2190: AND cicd1.COST_TYPE_ID = l_dest_cost_type_id
2191: AND cicd1.INVENTORY_ITEM_ID = cicd.INVENTORY_ITEM_ID
2192: AND cicd1.BASIS_TYPE <> 5 /* Total Value */

Line 2225: UPDATE CST_ITEM_COST_DETAILS cicd

2221: l_ext_tbl
2222: LIMIT 1000;
2223:
2224: FORALL i IN l_inv_item_tbl.first..l_inv_item_tbl.last
2225: UPDATE CST_ITEM_COST_DETAILS cicd
2226: SET (OPERATION_SEQUENCE_ID,
2227: DEPARTMENT_ID) =
2228: (SELECT bos.OPERATION_SEQUENCE_ID,
2229: bos.DEPARTMENT_ID

Line 2394: FROM CST_ITEM_COST_DETAILS cicd

2390: l_rollup_date,
2391: l_last_updated_by,
2392: l_rollup_id,
2393: l_assignment_set_id
2394: FROM CST_ITEM_COST_DETAILS cicd
2395: WHERE cicd.INVENTORY_ITEM_ID = cic.INVENTORY_ITEM_ID
2396: AND cicd.ORGANIZATION_ID = l_org_id_tbl(i)
2397: AND cicd.COST_TYPE_ID = l_dest_cost_type_id)
2398:

Line 2745: FROM CST_ITEM_COST_DETAILS CICD, MTL_PARAMETERS MP

2741: SET (ITEM_COST,
2742: BUY_COST_FLAG) =
2743: (SELECT NVL(SUM(CICD.ITEM_COST),0),
2744: 'Y'
2745: FROM CST_ITEM_COST_DETAILS CICD, MTL_PARAMETERS MP
2746: WHERE CICD.inventory_item_id = l_item_id
2747: AND CICD.organization_id = l_org_id
2748: AND MP.organization_id = l_org_id
2749: AND (

Line 2932: INSERT INTO CST_ITEM_COST_DETAILS (

2928:
2929: IF (esa_flag = 1) then
2930: sql_stmt_num := 30;
2931: FORALL i in l_inv_item_tbl.first..l_inv_item_tbl.last
2932: INSERT INTO CST_ITEM_COST_DETAILS (
2933: inventory_item_id,
2934: organization_id,
2935: SOURCE_ORGANIZATION_ID,
2936: cost_type_id,

Line 2985: FROM cst_item_cost_details

2981: decode(conc_flag,1,prgm_id,NULL),
2982: decode(conc_flag,1,sysdate,NULL),
2983: round(sum(item_cost*l_op_yield_factor_tbl(i)),ext_precision),
2984: NULL
2985: FROM cst_item_cost_details
2986: WHERE organization_id = l_organization_id
2987: AND inventory_item_id = l_inv_item_tbl(i)
2988: AND cost_type_id = l_cost_type_id
2989: AND operation_seq_num <= l_op_seq_num_tbl(i)

Line 2997: INSERT into cst_item_cost_details (

2993: then we need to distinguish between the this level
2994: and previous level operation yield costs */
2995: sql_stmt_num := 35;
2996: FORALL i in l_inv_item_tbl.first..l_inv_item_tbl.last
2997: INSERT into cst_item_cost_details (
2998: inventory_item_id,
2999: organization_id,
3000: SOURCE_ORGANIZATION_ID,
3001: cost_type_id,

Line 3050: FROM cst_item_cost_details

3046: decode(conc_flag,1,prgm_id,NULL),
3047: decode(conc_flag,1,sysdate,NULL),
3048: round(sum(item_cost*l_op_yield_factor_tbl(i)),ext_precision),
3049: NULL
3050: FROM cst_item_cost_details
3051: WHERE organization_id = l_organization_id
3052: AND inventory_item_id = l_inv_item_tbl(i)
3053: AND cost_type_id = l_cost_type_id
3054: AND operation_seq_num <= l_op_seq_num_tbl(i)

Line 3070: FROM cst_item_cost_details

3066: end if;
3067:
3068: SELECT count(*)
3069: INTO l_invalid_rows
3070: FROM cst_item_cost_details
3071: WHERE organization_id = l_organization_id
3072: AND inventory_item_id = l_inv_item_tbl(dummy)
3073: AND cost_type_id = l_cost_type_id
3074: AND yielded_cost IS NOT NULL