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.CSTPPWAC dependencies on CST_PAC_ITEM_COST_DETAILS

Line 1621: records in CST_PAC_ITEM_COST_DETAILS. Since we are using

1617: l_ret_val := 0;
1618:
1619: /********************************************************************
1620: ** Create detail rows in MTL_PAC_ACTUAL_COST_DETAILS based on **
1621: ** records in CST_PAC_ITEM_COST_DETAILS. Since we are using **
1622: ** current average the actual cost, prior cost and new cost are **
1623: ** all the same. **
1624: ** If detail rows do not exist in CST_PAC_ITEM_COST_DETAILS, **
1625: ** we will insert a TL material 0 cost layer. **

Line 1624: If detail rows do not exist in CST_PAC_ITEM_COST_DETAILS,

1620: ** Create detail rows in MTL_PAC_ACTUAL_COST_DETAILS based on **
1621: ** records in CST_PAC_ITEM_COST_DETAILS. Since we are using **
1622: ** current average the actual cost, prior cost and new cost are **
1623: ** all the same. **
1624: ** If detail rows do not exist in CST_PAC_ITEM_COST_DETAILS, **
1625: ** we will insert a TL material 0 cost layer. **
1626: ********************************************************************/
1627:
1628: l_stmt_num := 30;

Line 1632: from cst_pac_item_cost_details

1628: l_stmt_num := 30;
1629:
1630: select count(*)
1631: into l_cost_details
1632: from cst_pac_item_cost_details
1633: where cost_layer_id = i_cost_layer_id;
1634:
1635:
1636:

Line 1724: FROM cst_pac_item_cost_details cpicd

1720: 'N',
1721: 'N',
1722: SYSDATE,
1723: i_txn_category
1724: FROM cst_pac_item_cost_details cpicd
1725: WHERE cpicd.cost_layer_id = i_cost_layer_id;
1726:
1727: else
1728: l_stmt_num := 50;

Line 2563: FROM cst_pac_item_cost_details cpicd

2559: 'N',
2560: 'N',
2561: sysdate,
2562: i_txn_category
2563: FROM cst_pac_item_cost_details cpicd
2564: WHERE cost_layer_id = i_cost_layer_id
2565: AND NOT EXISTS
2566: (SELECT 'this detail is not in mpacd already'
2567: FROM mtl_pac_actual_cost_details mpacd

Line 2837: FROM cst_pac_item_cost_details cpicd

2833: 'Y',
2834: 'N',
2835: sysdate,
2836: i_txn_category
2837: FROM cst_pac_item_cost_details cpicd
2838: WHERE cpicd.cost_layer_id = i_cost_layer_id
2839: AND not exists (
2840: SELECT 'not exists in mptcd'
2841: FROM mtl_pac_txn_cost_details mptcd

Line 2952: cst_pac_item_cost_details cpicd,

2948: 0
2949: )
2950: )
2951: FROM mtl_pac_txn_cost_details mptcd,
2952: cst_pac_item_cost_details cpicd,
2953: cst_pac_quantity_layers cpql
2954: WHERE mptcd.transaction_id = i_txn_id
2955: AND mptcd.pac_period_id = i_pac_period_id
2956: AND mptcd.cost_group_id = i_cost_group_id

Line 2990: DELETE FROM cst_pac_item_cost_details

2986: IF (l_value_change_flag <> 0)
2987: THEN
2988: -- New Cost or percent change cost update
2989: l_stmt_num := 50;
2990: DELETE FROM cst_pac_item_cost_details
2991: WHERE cost_layer_id = i_cost_layer_id;
2992:
2993: l_stmt_num := 60;
2994: INSERT INTO cst_pac_item_cost_details(

Line 2994: INSERT INTO cst_pac_item_cost_details(

2990: DELETE FROM cst_pac_item_cost_details
2991: WHERE cost_layer_id = i_cost_layer_id;
2992:
2993: l_stmt_num := 60;
2994: INSERT INTO cst_pac_item_cost_details(
2995: cost_layer_id,
2996: cost_element_id,
2997: level_type,
2998: last_update_date,

Line 3099: FROM CST_PAC_ITEM_COST_DETAILS

3095: SUM(ITEM_BUY_COST), -- ITEM_BUY_COST
3096: SUM(ITEM_MAKE_COST), -- ITEM_MAKE_COST
3097: SUM(DECODE(COST_ELEMENT_ID,2,DECODE(LEVEL_TYPE,2,ITEM_COST,0),ITEM_COST)),-- UNBURDENED_COST
3098: SUM(DECODE(COST_ELEMENT_ID,2,DECODE(LEVEL_TYPE,1,ITEM_COST,0),0)) -- BURDEN_COST
3099: FROM CST_PAC_ITEM_COST_DETAILS
3100: WHERE COST_LAYER_ID = i_cost_layer_id
3101: GROUP BY COST_LAYER_ID)
3102: WHERE cpic.cost_layer_id = i_cost_layer_id
3103: AND EXISTS

Line 3105: FROM cst_pac_item_cost_details cpicd

3101: GROUP BY COST_LAYER_ID)
3102: WHERE cpic.cost_layer_id = i_cost_layer_id
3103: AND EXISTS
3104: (SELECT 'there is detail cost'
3105: FROM cst_pac_item_cost_details cpicd
3106: WHERE cpicd.cost_layer_id = i_cost_layer_id);
3107:
3108: l_stmt_num := 80;
3109: MERGE INTO CST_PAC_PERIOD_BALANCES cppb

Line 3703: UPDATE CST_PAC_ITEM_COST_DETAILS cpicd

3699:
3700: l_stmt_num := 30;
3701: -- Update balance of existing rows in CPICD
3702: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3703: UPDATE CST_PAC_ITEM_COST_DETAILS cpicd
3704: SET item_balance = nvl(item_balance, 0) + CSTPPINV.l_item_balance_tbl (l_index),
3705: /* 11834257: The total item cost and make cost needs to be updated for non-rework
3706: completions as calculate_periodic_cost is not called for this category */
3707: item_cost = decode(i_txn_category, 4,

Line 3735: INSERT INTO CST_PAC_ITEM_COST_DETAILS cpicd

3731:
3732: l_stmt_num := 40;
3733: -- Insert missing cost elements into CPICD
3734: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3735: INSERT INTO CST_PAC_ITEM_COST_DETAILS cpicd
3736: (cost_layer_id,
3737: cost_element_id,
3738: level_type,
3739: last_update_date,

Line 3786: FROM cst_pac_item_cost_details cpicd1

3782: CSTPPINV.l_make_balance_tbl (l_index),
3783: CSTPPINV.l_buy_balance_tbl (l_index)
3784: FROM dual
3785: WHERE NOT EXISTS (SELECT 1
3786: FROM cst_pac_item_cost_details cpicd1
3787: WHERE cpicd1.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index)
3788: AND cpicd1.cost_element_id = CSTPPINV.l_cost_element_id_tbl (l_index)
3789: AND cpicd1.level_type = CSTPPINV.l_level_type_tbl (l_index)));
3790:

Line 4075: cst_pac_item_cost_details cpicd

4071: 0, cpicd.item_balance,
4072: (-1 * sign(cpicd.item_balance)), cpicd.item_balance,
4073: 0)
4074: FROM cst_pac_item_costs cpic,
4075: cst_pac_item_cost_details cpicd
4076: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
4077: AND cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
4078: AND cpicd.cost_element_id = mpacd.cost_element_id
4079: AND cpicd.level_type = mpacd.level_type),

Line 4092: FROM cst_pac_item_cost_details cpicd

4088: AND mpacd.cost_group_id = i_cost_group_id
4089: AND mpacd.pac_period_id = i_pac_period_id
4090: AND mpacd.cost_layer_id = l_cost_layer_id_tbl(l_index)
4091: AND (cost_element_id, level_type) = (SELECT cost_element_id, level_type
4092: FROM cst_pac_item_cost_details cpicd
4093: WHERE cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
4094: AND cpicd.cost_element_id = mpacd.cost_element_id
4095: AND cpicd.level_type = mpacd.level_type);
4096:

Line 4149: FROM cst_pac_item_cost_details cpicd,

4145: 0, cpicd.item_balance,
4146: (-1 * sign(cpicd.item_balance)), cpicd.item_balance,
4147: 0),
4148: l_txn_category_tbl(l_index)
4149: FROM cst_pac_item_cost_details cpicd,
4150: cst_pac_item_costs cpic
4151: WHERE cpicd.cost_layer_id = cpic.cost_layer_id
4152: AND cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
4153: AND NOT EXISTS (SELECT 1

Line 4164: UPDATE cst_pac_item_cost_details cpicd

4160: l_stmt_num := 50;
4161:
4162: IF (i_low_level_code = -1) THEN
4163: -- Items that do not have completion
4164: UPDATE cst_pac_item_cost_details cpicd
4165: SET (last_update_date,
4166: last_updated_by,
4167: last_update_login,
4168: request_id,

Line 4311: FROM cst_pac_item_cost_details cpicd

4307: AND cpllc.pac_period_id = i_pac_period_id
4308: AND cpllc.cost_group_id = i_cost_group_id)
4309: AND EXISTS
4310: (SELECT 'there is detail cost'
4311: FROM cst_pac_item_cost_details cpicd
4312: WHERE cpicd.cost_layer_id = cpic.cost_layer_id);
4313: ELSE
4314: -- low_level_code <> -1; items having completion
4315:

Line 4317: UPDATE cst_pac_item_cost_details cpicd

4313: ELSE
4314: -- low_level_code <> -1; items having completion
4315:
4316: l_stmt_num := 70;
4317: UPDATE cst_pac_item_cost_details cpicd
4318: SET (last_update_date,
4319: last_updated_by,
4320: last_update_login,
4321: request_id,

Line 4466: FROM cst_pac_item_cost_details cpicd

4462: AND cpllc.pac_period_id = i_pac_period_id
4463: AND cpllc.cost_group_id = i_cost_group_id)
4464: AND EXISTS
4465: (SELECT 'there is detail cost'
4466: FROM cst_pac_item_cost_details cpicd
4467: WHERE cpicd.cost_layer_id = cpic.cost_layer_id);
4468: END IF;
4469:
4470: /* --- start of auto log --- */

Line 4679: cst_pac_item_cost_details cpicd

4675: 0, cpicd.item_balance,
4676: (-1 * sign(cpicd.item_balance)), cpicd.item_balance,
4677: 0)
4678: FROM cst_pac_item_costs cpic,
4679: cst_pac_item_cost_details cpicd
4680: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
4681: AND cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
4682: AND cpicd.cost_element_id = mpacd.cost_element_id
4683: AND cpicd.level_type = mpacd.level_type),

Line 4696: FROM cst_pac_item_cost_details cpicd

4692: AND mpacd.cost_group_id = i_cost_group_id
4693: AND mpacd.pac_period_id = i_pac_period_id
4694: AND mpacd.cost_layer_id = l_cost_layer_id_tbl(l_index)
4695: AND (cost_element_id, level_type) = (SELECT cost_element_id, level_type
4696: FROM cst_pac_item_cost_details cpicd
4697: WHERE cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
4698: AND cpicd.cost_element_id = mpacd.cost_element_id
4699: AND cpicd.level_type = mpacd.level_type);
4700:

Line 4753: FROM cst_pac_item_cost_details cpicd,

4749: 0, cpicd.item_balance,
4750: (-1 * sign(cpicd.item_balance)), cpicd.item_balance,
4751: 0),
4752: l_txn_category_tbl(l_index)
4753: FROM cst_pac_item_cost_details cpicd,
4754: cst_pac_item_costs cpic
4755: WHERE cpicd.cost_layer_id = cpic.cost_layer_id
4756: AND cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
4757: AND NOT EXISTS (SELECT 1

Line 4768: UPDATE cst_pac_item_cost_details cpicd

4764: l_stmt_num := 50;
4765:
4766: IF (i_low_level_code = -1) THEN
4767: -- Items that do not have completion
4768: UPDATE cst_pac_item_cost_details cpicd
4769: SET (last_update_date,
4770: last_updated_by,
4771: last_update_login,
4772: request_id,

Line 4914: FROM cst_pac_item_cost_details cpicd

4910: AND cpllc.pac_period_id = i_pac_period_id
4911: AND cpllc.cost_group_id = i_cost_group_id)
4912: AND EXISTS
4913: (SELECT 'there is detail cost'
4914: FROM cst_pac_item_cost_details cpicd
4915: WHERE cpicd.cost_layer_id = cpic.cost_layer_id);
4916: ELSE
4917: -- low_level_code <> -1; items having completion
4918:

Line 4920: UPDATE cst_pac_item_cost_details cpicd

4916: ELSE
4917: -- low_level_code <> -1; items having completion
4918:
4919: l_stmt_num := 70;
4920: UPDATE cst_pac_item_cost_details cpicd
4921: SET (last_update_date,
4922: last_updated_by,
4923: last_update_login,
4924: request_id,

Line 5068: FROM cst_pac_item_cost_details cpicd

5064: AND cpllc.pac_period_id = i_pac_period_id
5065: AND cpllc.cost_group_id = i_cost_group_id)
5066: AND EXISTS
5067: (SELECT 'there is detail cost'
5068: FROM cst_pac_item_cost_details cpicd
5069: WHERE cpicd.cost_layer_id = cpic.cost_layer_id);
5070: END IF;
5071:
5072: /* --- start of auto log --- */

Line 5294: FROM cst_pac_item_cost_details cpicd,

5290: AND mpacd.cost_group_id = i_cost_group_id
5291: AND mpacd.cost_layer_id = cppb.cost_layer_id
5292: AND mpacd.cost_element_id = cppb.cost_element_id
5293: AND mpacd.level_type = cppb.level_type)
5294: FROM cst_pac_item_cost_details cpicd,
5295: cst_pac_item_costs cpic
5296: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
5297: AND cppb.cost_layer_id = cpicd.cost_layer_id
5298: AND cppb.cost_element_id = cpicd.cost_element_id

Line 5309: AND EXISTS (SELECT /+ INDEX(CPICD1 CST_PAC_ITEM_COST_DETAILS_U1)/

5305: FROM MTL_PAC_ACTUAL_COST_DETAILS MPACD1
5306: WHERE MPACD1.pac_period_id = i_pac_period_id
5307: AND MPACD1.cost_group_id = i_cost_group_id
5308: AND MPACD1.inventory_item_id = cppb.inventory_item_id)
5309: AND EXISTS (SELECT /*+ INDEX(CPICD1 CST_PAC_ITEM_COST_DETAILS_U1)*/
5310: 1
5311: FROM CST_PAC_ITEM_COST_DETAILS cpicd1
5312: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
5313: AND cppb.cost_element_id = cpicd1.cost_element_id

Line 5311: FROM CST_PAC_ITEM_COST_DETAILS cpicd1

5307: AND MPACD1.cost_group_id = i_cost_group_id
5308: AND MPACD1.inventory_item_id = cppb.inventory_item_id)
5309: AND EXISTS (SELECT /*+ INDEX(CPICD1 CST_PAC_ITEM_COST_DETAILS_U1)*/
5310: 1
5311: FROM CST_PAC_ITEM_COST_DETAILS cpicd1
5312: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
5313: AND cppb.cost_element_id = cpicd1.cost_element_id
5314: AND cppb.level_type = cpicd1.level_type);
5315:

Line 5353: FROM cst_pac_item_cost_details cpicd,

5349: AND mpacd.cost_group_id = i_cost_group_id
5350: AND mpacd.cost_layer_id = cppb.cost_layer_id
5351: AND mpacd.cost_element_id = cppb.cost_element_id
5352: AND mpacd.level_type = cppb.level_type)
5353: FROM cst_pac_item_cost_details cpicd,
5354: cst_pac_item_costs cpic
5355: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
5356: AND cppb.cost_layer_id = cpicd.cost_layer_id
5357: AND cppb.cost_element_id = cpicd.cost_element_id

Line 5368: AND EXISTS (SELECT /+ INDEX(CPICD1 CST_PAC_ITEM_COST_DETAILS_U1)/

5364: FROM MTL_PAC_ACTUAL_COST_DETAILS MPACD1
5365: WHERE MPACD1.pac_period_id = i_pac_period_id
5366: AND MPACD1.cost_group_id = i_cost_group_id
5367: AND MPACD1.inventory_item_id = cppb.inventory_item_id)
5368: AND EXISTS (SELECT /*+ INDEX(CPICD1 CST_PAC_ITEM_COST_DETAILS_U1)*/
5369: 1
5370: FROM CST_PAC_ITEM_COST_DETAILS cpicd1
5371: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
5372: AND cppb.cost_element_id = cpicd1.cost_element_id

Line 5370: FROM CST_PAC_ITEM_COST_DETAILS cpicd1

5366: AND MPACD1.cost_group_id = i_cost_group_id
5367: AND MPACD1.inventory_item_id = cppb.inventory_item_id)
5368: AND EXISTS (SELECT /*+ INDEX(CPICD1 CST_PAC_ITEM_COST_DETAILS_U1)*/
5369: 1
5370: FROM CST_PAC_ITEM_COST_DETAILS cpicd1
5371: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
5372: AND cppb.cost_element_id = cpicd1.cost_element_id
5373: AND cppb.level_type = cpicd1.level_type)
5374: AND NOT EXISTS (SELECT 1

Line 5396: (SELECT /+ INDEX(CPICD CST_PAC_ITEM_COST_DETAILS_U1)/

5392: period_balance,
5393: period_quantity,
5394: periodic_cost,
5395: variance_amount) =
5396: (SELECT /*+ INDEX(CPICD CST_PAC_ITEM_COST_DETAILS_U1)*/
5397: i_user_id,
5398: sysdate,
5399: i_login_id,
5400: i_request_id,

Line 5417: FROM cst_pac_item_cost_details cpicd,

5413: and mpacd.cost_group_id = i_cost_group_id
5414: and mpacd.cost_layer_id = cppb.cost_layer_id
5415: and mpacd.cost_element_id = cppb.cost_element_id
5416: and mpacd.level_type = cppb.level_type)
5417: FROM cst_pac_item_cost_details cpicd,
5418: cst_pac_item_costs cpic
5419: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
5420: AND cppb.cost_layer_id = cpicd.cost_layer_id
5421: AND cppb.cost_element_id = cpicd.cost_element_id

Line 5432: AND EXISTS (SELECT /+ INDEX(CPICD1 CST_PAC_ITEM_COST_DETAILS_U1)/

5428: FROM MTL_PAC_ACTUAL_COST_DETAILS MPACD1
5429: WHERE MPACD1.pac_period_id = i_pac_period_id
5430: AND MPACD1.cost_group_id = i_cost_group_id
5431: AND MPACD1.inventory_item_id = cppb.inventory_item_id)
5432: AND EXISTS (SELECT /*+ INDEX(CPICD1 CST_PAC_ITEM_COST_DETAILS_U1)*/
5433: 1
5434: FROM CST_PAC_ITEM_COST_DETAILS cpicd1
5435: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
5436: AND cppb.cost_element_id = cpicd1.cost_element_id

Line 5434: FROM CST_PAC_ITEM_COST_DETAILS cpicd1

5430: AND MPACD1.cost_group_id = i_cost_group_id
5431: AND MPACD1.inventory_item_id = cppb.inventory_item_id)
5432: AND EXISTS (SELECT /*+ INDEX(CPICD1 CST_PAC_ITEM_COST_DETAILS_U1)*/
5433: 1
5434: FROM CST_PAC_ITEM_COST_DETAILS cpicd1
5435: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
5436: AND cppb.cost_element_id = cpicd1.cost_element_id
5437: AND cppb.level_type = cpicd1.level_type)
5438: AND EXISTS (SELECT 1

Line 5560: FROM cst_pac_item_cost_details cpicd,

5556: AND mpacd.cost_group_id = cppb.cost_group_id
5557: AND mpacd.cost_layer_id = cppb.cost_layer_id
5558: AND mpacd.cost_element_id = cppb.cost_element_id
5559: AND mpacd.level_type = cppb.level_type)
5560: FROM cst_pac_item_cost_details cpicd,
5561: cst_pac_item_costs cpic
5562: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
5563: AND cppb.cost_layer_id = cpicd.cost_layer_id
5564: AND cppb.cost_element_id = cpicd.cost_element_id

Line 5576: FROM CST_PAC_ITEM_COST_DETAILS cpicd1

5572: WHERE pac_period_id = i_pac_period_id
5573: AND cost_group_id = i_cost_group_id
5574: AND inventory_item_id = cppb.inventory_item_id)
5575: AND EXISTS (SELECT 1
5576: FROM CST_PAC_ITEM_COST_DETAILS cpicd1
5577: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
5578: AND cppb.cost_element_id = cpicd1.cost_element_id
5579: AND cppb.level_type = cpicd1.level_type);
5580:

Line 5707: cst_pac_item_cost_details cpicd,

5703: i_prog_appl_id,
5704: i_prog_id,
5705: sysdate
5706: FROM cst_pac_item_costs cpic,
5707: cst_pac_item_cost_details cpicd,
5708: cst_pac_quantity_layers cpql
5709: WHERE cpic.pac_period_id = i_pac_period_id
5710: AND cpic.cost_group_id = i_cost_group_id
5711: AND cpicd.cost_layer_id = cpic.cost_layer_id