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_COSTS

Line 86: cst_item_costs cia

82: ( SELECT
83: csllc.inventory_item_id,
84: csllc.organization_id
85: FROM cst_sc_low_level_codes csllc,
86: cst_item_costs cia
87: WHERE
88: csllc.rollup_id = p_rollup_id
89: AND csllc.inventory_item_id = cia.inventory_item_id
90: AND cia.organization_id = csllc.organization_id

Line 102: FROM cst_item_costs CIC

98: IF (p_lot_size_option IS NOT NULL) THEN
99: UPDATE cst_sc_low_level_codes CSLLC
100: SET CSLLC.lot_size =
101: (SELECT CIC.lot_size
102: FROM cst_item_costs CIC
103: WHERE CIC.cost_type_id = p_dest_cost_type_id
104: AND CIC.inventory_item_id = CSLLC.inventory_item_id
105: AND CIC.organization_id = CSLLC.organization_id
106: )

Line 115: DELETE CST_ITEM_COSTS cia

111: /*------------------------------------------------------------+
112: | Delete item attributes that were generated by the cost |
113: | rollup. |
114: +------------------------------------------------------------*/
115: DELETE CST_ITEM_COSTS cia
116: WHERE
117: COST_TYPE_ID = p_dest_cost_type_id
118: AND DEFAULTED_FLAG = 1 /* YES */
119: AND default_cost_type_id <> p_dest_cost_type_id

Line 128: | Create rows in CST_ITEM_COSTS for make items that do |

124: );
125:
126: l_stmt_num := 40;
127: /*------------------------------------------------------------+
128: | Create rows in CST_ITEM_COSTS for make items that do |
129: | not already have rows in there from default cost type |
130: +------------------------------------------------------------*/
131: INSERT INTO CST_ITEM_COSTS (
132: INVENTORY_ITEM_ID,

Line 131: INSERT INTO CST_ITEM_COSTS (

127: /*------------------------------------------------------------+
128: | Create rows in CST_ITEM_COSTS for make items that do |
129: | not already have rows in there from default cost type |
130: +------------------------------------------------------------*/
131: INSERT INTO CST_ITEM_COSTS (
132: INVENTORY_ITEM_ID,
133: ORGANIZATION_ID,
134: COST_TYPE_ID,
135: LAST_UPDATE_DATE,

Line 170: CST_ITEM_COSTS cia,

166: DECODE(p_conc_flag, 1,
167: l_rollup_date, NULL)
168: FROM
169: CST_SC_LOW_LEVEL_CODES csllc,
170: CST_ITEM_COSTS cia,
171: MTL_PARAMETERS mp
172: WHERE cia.ORGANIZATION_ID = csllc.organization_id
173: AND csllc.ROLLUP_ID = p_rollup_id
174: AND cia.INVENTORY_ITEM_ID = csllc.INVENTORY_ITEM_ID

Line 185: FROM CST_ITEM_COSTS cia2

181: (cia.COST_TYPE_ID = mp.PRIMARY_COST_METHOD)
182: AND
183: (NOT EXISTS
184: (SELECT 'X'
185: FROM CST_ITEM_COSTS cia2
186: WHERE cia2.INVENTORY_ITEM_ID = cia.INVENTORY_ITEM_ID
187: AND cia2.ORGANIZATION_ID = cia.ORGANIZATION_ID
188: AND cia2.COST_TYPE_ID = default_cost_type_id)
189: )

Line 194: FROM CST_ITEM_COSTS cia1

190: )
191: ) /* Supply chain enhancement: default valuation cost type */
192: AND NOT EXISTS
193: (SELECT 'X'
194: FROM CST_ITEM_COSTS cia1
195: WHERE cia1.INVENTORY_ITEM_ID = cia.INVENTORY_ITEM_ID
196: AND cia1.ORGANIZATION_ID = cia.ORGANIZATION_ID
197: AND cia1.COST_TYPE_ID = p_dest_cost_type_id
198: );

Line 279: CST_ITEM_COSTS cia,

275: DECODE(p_conc_flag, 1,
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

Line 301: FROM CST_ITEM_COSTS cia2

297: (cicd.COST_TYPE_ID = mp.PRIMARY_COST_METHOD)
298: AND
299: (NOT EXISTS
300: (SELECT 'X'
301: FROM CST_ITEM_COSTS cia2
302: WHERE cia2.INVENTORY_ITEM_ID = csllc.INVENTORY_ITEM_ID
303: AND cia2.ORGANIZATION_ID = csllc.ORGANIZATION_ID
304: AND cia2.COST_TYPE_ID = default_cost_type_id)
305: )

Line 318: INSERT INTO CST_ITEM_COSTS (

314: | already have costs within the cost type in CIC |
315: +------------------------------------------------------------*/
316:
317:
318: INSERT INTO CST_ITEM_COSTS (
319: INVENTORY_ITEM_ID,
320: ORGANIZATION_ID,
321: COST_TYPE_ID,
322: LAST_UPDATE_DATE,

Line 367: FROM CST_ITEM_COSTS cia1, MTL_PARAMETERS mp

363: AND csllc.ROLLUP_ID = p_rollup_id
364: AND msi.INVENTORY_ITEM_ID = csllc.INVENTORY_ITEM_ID
365: AND NOT EXISTS
366: (SELECT 'X'
367: FROM CST_ITEM_COSTS cia1, MTL_PARAMETERS mp
368: WHERE cia1.INVENTORY_ITEM_ID = csllc.INVENTORY_ITEM_ID
369: AND cia1.ORGANIZATION_ID = csllc.ORGANIZATION_ID
370: AND mp.ORGANIZATION_ID = csllc.ORGANIZATION_ID
371: AND cia1.COST_TYPE_ID

Line 381: UPDATE cst_item_costs CIC

377: -- lot_size_option = 2 is set to number
378: -- lot_size_option = 3 is set to factor
379: if ((p_lot_size_option = 2) or (p_lot_size_option = 3)) then
380: l_stmt_num := 60;
381: UPDATE cst_item_costs CIC
382: SET CIC.lot_size =
383: (SELECT decode(p_lot_size_option, 2, nvl(p_lot_size_setting, CIC.lot_size),
384: 3, nvl(p_lot_size_setting*MSI.std_lot_size, CIC.lot_size))
385: FROM mtl_system_items MSI

Line 400: FROM cst_item_costs CIC

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
401: WHERE CIC.inventory_item_id = CICD.inventory_item_id
402: AND CIC.organization_id = CICD.organization_id
403: AND CIC.cost_type_id = CICD.cost_type_id)
404: WHERE CICD.cost_type_id = p_dest_cost_type_id

Line 412: (SELECT 'x' FROM cst_item_costs CIC2

408: (SELECT CSL.inventory_item_id, CSL.organization_id
409: FROM cst_sc_lists CSL
410: WHERE CSL.rollup_id = p_rollup_id)
411: AND EXISTS
412: (SELECT 'x' FROM cst_item_costs CIC2
413: WHERE CIC2.inventory_item_id = CICD.inventory_item_id
414: AND CIC2.organization_id = CICD.organization_id
415: AND CIC2.cost_type_id = CICD.cost_type_id
416: AND CIC2.based_on_rollup_flag = 1);

Line 451: CST_ITEM_COSTS CIA,

447: CURSOR cc is
448: SELECT
449: CIA.INVENTORY_ITEM_ID
450: FROM
451: CST_ITEM_COSTS CIA,
452: CST_SC_LOW_LEVEL_CODES CSLLC
453: WHERE CSLLC.ROLLUP_ID = l_rollup_id
454: AND CIA.INVENTORY_ITEM_ID = CSLLC.INVENTORY_ITEM_ID
455: AND CIA.ORGANIZATION_ID = CSLLC.organization_id

Line 474: CST_ITEM_COSTS CIA,

470: CURSOR ce is
471: SELECT
472: CIA.INVENTORY_ITEM_ID
473: FROM
474: CST_ITEM_COSTS CIA,
475: CST_SC_LOW_LEVEL_CODES CSLLC
476: WHERE CSLLC.ROLLUP_ID = l_rollup_id
477: AND CIA.INVENTORY_ITEM_ID = CSLLC.INVENTORY_ITEM_ID
478: AND CIA.ORGANIZATION_ID = CSLLC.organization_id

Line 495: if (table_name = 'CST_ITEM_COSTS' and l_locking_flag = 2) then

491:
492: BEGIN
493: -- SCAPI: use different cursors based on the locking flag
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;

Line 501: elsif (table_name = 'CST_ITEM_COSTS' and l_locking_flag = 1) then

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;
503: status := SQLCODE;
504: elsif (table_name = 'CST_ITEM_COST_DETAILS' and l_locking_flag = 1) then
505: OPEN cf;

Line 535: ** Lock the table of CST_ITEM_COSTS

531: status number := -54;
532: counter number := 0;
533: BEGIN
534: /*
535: ** Lock the table of CST_ITEM_COSTS
536: */
537: -- SCAPI: use loop only if locking_flag is not yes
538: if (l_locking_flag = 1) then
539: status := CSTPSCCR.cstrlock('CST_ITEM_COSTS',l_dest_cost_type_id,

Line 539: status := CSTPSCCR.cstrlock('CST_ITEM_COSTS',l_dest_cost_type_id,

535: ** Lock the table of CST_ITEM_COSTS
536: */
537: -- SCAPI: use loop only if locking_flag is not yes
538: if (l_locking_flag = 1) then
539: status := CSTPSCCR.cstrlock('CST_ITEM_COSTS',l_dest_cost_type_id,
540: l_default_cost_type_id,
541: l_rollup_id,err_buf,l_locking_flag);
542: else
543: WHILE (counter < NUM_TRIES and status = -54)

Line 545: status := CSTPSCCR.cstrlock('CST_ITEM_COSTS',l_dest_cost_type_id,

541: l_rollup_id,err_buf,l_locking_flag);
542: else
543: WHILE (counter < NUM_TRIES and status = -54)
544: LOOP
545: status := CSTPSCCR.cstrlock('CST_ITEM_COSTS',l_dest_cost_type_id,
546: l_default_cost_type_id,
547: l_rollup_id,err_buf,l_locking_flag);
548: if status = -54 then
549: DBMS_LOCK.SLEEP(SLEEP_TIME);

Line 989: CST_ITEM_COSTS cia,

985: l_rollup_date, NULL)
986: FROM
987: CST_SC_LOW_LEVEL_CODES csllc,
988: MTL_PARAMETERS mp,
989: CST_ITEM_COSTS cia,
990: BOM_OPERATIONAL_ROUTINGS bor,
991: BOM_OPERATION_SEQUENCES bos,
992: BOM_OPERATION_RESOURCES bomres,
993: BOM_RESOURCES br,

Line 1169: CST_ITEM_COSTS cia,

1165: DECODE(conc_flag, 1, l_rollup_date, NULL)
1166: FROM
1167: CST_SC_LOW_LEVEL_CODES csllc,
1168: MTL_PARAMETERS mp,
1169: CST_ITEM_COSTS cia,
1170: BOM_OPERATIONAL_ROUTINGS bor,
1171: BOM_OPERATION_SEQUENCES bos,
1172: BOM_OPERATION_RESOURCES bomres,
1173: BOM_RESOURCES br

Line 1348: CST_ITEM_COSTS cia,

1344: DECODE(conc_flag, 1,
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

Line 1482: CST_ITEM_COSTS cia,

1478: DECODE(conc_flag, 1,
1479: l_rollup_date, NULL)
1480: FROM
1481: CST_SC_LOW_LEVEL_CODES csllc,
1482: CST_ITEM_COSTS cia,
1483: BOM_OPERATIONAL_ROUTINGS bor,
1484: BOM_OPERATION_SEQUENCES bos,
1485: CST_DEPARTMENT_OVERHEADS cdo,
1486: MTL_PARAMETERS mp

Line 1887: CST_ITEM_COSTS cia_assy,

1883: 4, cicd.resource_seq_num,
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,

Line 1889: CST_ITEM_COSTS cia_comp,

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
1893:

Line 2000: FROM CST_ITEM_COSTS cia1

1996: OR
1997: ( cia_comp.COST_TYPE_ID = default_cost_type_id
1998: AND NOT EXISTS (
1999: SELECT /*+ PUSH_SUBQ */ 'X' -- Added hint for 5678464
2000: FROM CST_ITEM_COSTS cia1
2001: WHERE cia1.ORGANIZATION_ID = l_org_id_tbl(i)
2002: AND cia1.INVENTORY_ITEM_ID = bic.COMPONENT_ITEM_ID
2003: AND cia1.COST_TYPE_ID = l_dest_cost_type_id)
2004: )

Line 2009: FROM CST_ITEM_COSTS cia2

2005: OR
2006: ( cia_comp.COST_TYPE_ID = l_pcm_tbl(i)
2007: AND NOT EXISTS (
2008: SELECT /*+ PUSH_SUBQ */ 'X' -- Added hint for 5678464
2009: FROM CST_ITEM_COSTS cia2
2010: WHERE cia2.ORGANIZATION_ID = l_org_id_tbl(i)
2011: AND cia2.INVENTORY_ITEM_ID = bic.COMPONENT_ITEM_ID
2012: AND cia2.COST_TYPE_ID in (l_dest_cost_type_id, default_cost_type_id))
2013: )

Line 2306: | Update rows in CST_ITEM_COSTS which had costs altered. |

2302:
2303:
2304: sql_stmt_num := 150;
2305: /*------------------------------------------------------------+
2306: | Update rows in CST_ITEM_COSTS which had costs altered. |
2307: | Because we need to include denormalized cost information. |
2308: +------------------------------------------------------------*/
2309:
2310: OPEN cllc_cur;

Line 2321: UPDATE CST_ITEM_COSTS cic

2317: l_ext_tbl
2318: LIMIT 1000;
2319:
2320: FORALL i IN l_inv_item_tbl.first..l_inv_item_tbl.last
2321: UPDATE CST_ITEM_COSTS cic
2322: SET ( PL_MATERIAL ,
2323: PL_MATERIAL_OVERHEAD ,
2324: PL_RESOURCE ,
2325: PL_OUTSIDE_PROCESSING ,

Line 2755: FROM CST_ITEM_COSTS cia1

2751: (
2752: CICD.cost_type_id = default_cost_type_id
2753: AND NOT EXISTS (
2754: SELECT 'X'
2755: FROM CST_ITEM_COSTS cia1
2756: WHERE cia1.inventory_item_id = l_item_id
2757: AND cia1.organization_id = l_org_id
2758: AND cia1.cost_type_id = l_buy_cost_type_id)
2759: )

Line 2765: FROM CST_ITEM_COSTS cia2

2761: (
2762: CICD.cost_type_id = MP.primary_cost_method
2763: AND NOT EXISTS (
2764: SELECT 'X'
2765: FROM CST_ITEM_COSTS cia2
2766: WHERE cia2.inventory_item_id = l_item_id
2767: AND cia2.organization_id = l_org_id
2768: AND cia2.cost_type_id in (l_buy_cost_type_id, default_cost_type_id))
2769: )

Line 3215: cst_item_costs cia,

3211: WHERE bbom.BILL_SEQUENCE_ID IN
3212: (SELECT bbom2.BILL_SEQUENCE_ID
3213: FROM BOM_BILL_OF_MATERIALS bbom2,
3214: CST_SC_LOW_LEVEL_CODES csllc,
3215: cst_item_costs cia,
3216: cst_sc_sourcing_rules cssr
3217: WHERE csllc.ROLLUP_ID = l_rollup_id
3218: AND cssr.rollup_id (+)= l_rollup_id
3219: AND cssr.inventory_item_id (+)= csllc.inventory_item_id

Line 3310: CST_ITEM_COSTS cia,

3306: bbom.assembly_item_id,
3307: bbom.organization_id,
3308: BOM_INVENTORY_COMPONENTS_S.NEXTVAL
3309: FROM BOM_BILL_OF_MATERIALS bbom,
3310: CST_ITEM_COSTS cia,
3311: CST_SC_LOW_LEVEL_CODES csllc,
3312: cst_sc_sourcing_rules cssr
3313: WHERE csllc.ROLLUP_ID = l_rollup_id
3314: AND cssr.rollup_id(+) = l_rollup_id

Line 3492: CST_ITEM_COSTS cia,

3488: bic.BOM_ITEM_TYPE
3489: FROM BOM_BILL_OF_MATERIALS bbom,
3490: BOM_BILL_OF_MATERIALS bbom2,
3491: bom_inventory_components bic,
3492: CST_ITEM_COSTS cia,
3493: CST_SC_LOW_LEVEL_CODES csllc,
3494: cst_sc_sourcing_rules cssr
3495: WHERE csllc.ROLLUP_ID = l_rollup_id
3496: AND cssr.rollup_id(+) = l_rollup_id