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 1106: INSERT INTO CST_ITEM_COST_DETAILS (

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

Line 1272: INSERT INTO CST_ITEM_COST_DETAILS (

1268: sql_stmt_num := 70;
1269: /*------------------------------------------------------------+
1270: | Calculate the this level overheads based on resources. |
1271: +------------------------------------------------------------*/
1272: INSERT INTO CST_ITEM_COST_DETAILS (
1273: INVENTORY_ITEM_ID,
1274: COST_TYPE_ID,
1275: LAST_UPDATE_DATE,
1276: LAST_UPDATED_BY,

Line 1349: CST_ITEM_COST_DETAILS cicd,

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

Line 1412: INSERT INTO CST_ITEM_COST_DETAILS (

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

Line 1612: UPDATE CST_ITEM_COST_DETAILS cicd

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

Line 1630: CST_ITEM_COST_DETAILS cicd1,

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

Line 1718: INSERT INTO cst_item_cost_details

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

Line 1888: CST_ITEM_COST_DETAILS cicd,

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

Line 2180: UPDATE CST_ITEM_COST_DETAILS cicd

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

Line 2187: FROM CST_ITEM_COST_DETAILS cicd1

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

Line 2224: UPDATE CST_ITEM_COST_DETAILS cicd

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

Line 2393: FROM CST_ITEM_COST_DETAILS cicd

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

Line 2744: FROM CST_ITEM_COST_DETAILS CICD, MTL_PARAMETERS MP

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

Line 2931: INSERT INTO CST_ITEM_COST_DETAILS (

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

Line 2984: FROM cst_item_cost_details

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

Line 2996: INSERT into cst_item_cost_details (

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

Line 3049: FROM cst_item_cost_details

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

Line 3069: FROM cst_item_cost_details

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