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 3698: UPDATE CST_PAC_ITEM_COST_DETAILS cpicd

3694:
3695: l_stmt_num := 30;
3696: -- Update balance of existing rows in CPICD
3697: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3698: UPDATE CST_PAC_ITEM_COST_DETAILS cpicd
3699: SET item_balance = nvl(item_balance, 0) + CSTPPINV.l_item_balance_tbl (l_index),
3700: make_balance = nvl(make_balance, 0) + CSTPPINV.l_make_balance_tbl (l_index),
3701: buy_balance = nvl(buy_balance, 0) + CSTPPINV.l_buy_balance_tbl (l_index),
3702: last_update_date = sysdate,

Line 3716: INSERT INTO CST_PAC_ITEM_COST_DETAILS cpicd

3712:
3713: l_stmt_num := 40;
3714: -- Insert missing cost elements into CPICD
3715: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3716: INSERT INTO CST_PAC_ITEM_COST_DETAILS cpicd
3717: (cost_layer_id,
3718: cost_element_id,
3719: level_type,
3720: last_update_date,

Line 3755: FROM cst_pac_item_cost_details cpicd1

3751: CSTPPINV.l_make_balance_tbl (l_index),
3752: CSTPPINV.l_buy_balance_tbl (l_index)
3753: FROM dual
3754: WHERE NOT EXISTS (SELECT 1
3755: FROM cst_pac_item_cost_details cpicd1
3756: WHERE cpicd1.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index)
3757: AND cpicd1.cost_element_id = CSTPPINV.l_cost_element_id_tbl (l_index)
3758: AND cpicd1.level_type = CSTPPINV.l_level_type_tbl (l_index)));
3759:

Line 4044: cst_pac_item_cost_details cpicd

4040: 0, cpicd.item_balance,
4041: (-1 * sign(cpicd.item_balance)), cpicd.item_balance,
4042: 0)
4043: FROM cst_pac_item_costs cpic,
4044: cst_pac_item_cost_details cpicd
4045: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
4046: AND cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
4047: AND cpicd.cost_element_id = mpacd.cost_element_id
4048: AND cpicd.level_type = mpacd.level_type),

Line 4061: FROM cst_pac_item_cost_details cpicd

4057: AND mpacd.cost_group_id = i_cost_group_id
4058: AND mpacd.pac_period_id = i_pac_period_id
4059: AND mpacd.cost_layer_id = l_cost_layer_id_tbl(l_index)
4060: AND (cost_element_id, level_type) = (SELECT cost_element_id, level_type
4061: FROM cst_pac_item_cost_details cpicd
4062: WHERE cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
4063: AND cpicd.cost_element_id = mpacd.cost_element_id
4064: AND cpicd.level_type = mpacd.level_type);
4065:

Line 4118: FROM cst_pac_item_cost_details cpicd,

4114: 0, cpicd.item_balance,
4115: (-1 * sign(cpicd.item_balance)), cpicd.item_balance,
4116: 0),
4117: l_txn_category_tbl(l_index)
4118: FROM cst_pac_item_cost_details cpicd,
4119: cst_pac_item_costs cpic
4120: WHERE cpicd.cost_layer_id = cpic.cost_layer_id
4121: AND cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
4122: AND NOT EXISTS (SELECT 1

Line 4133: UPDATE cst_pac_item_cost_details cpicd

4129: l_stmt_num := 50;
4130:
4131: IF (i_low_level_code = -1) THEN
4132: -- Items that do not have completion
4133: UPDATE cst_pac_item_cost_details cpicd
4134: SET (last_update_date,
4135: last_updated_by,
4136: last_update_login,
4137: request_id,

Line 4280: FROM cst_pac_item_cost_details cpicd

4276: AND cpllc.pac_period_id = i_pac_period_id
4277: AND cpllc.cost_group_id = i_cost_group_id)
4278: AND EXISTS
4279: (SELECT 'there is detail cost'
4280: FROM cst_pac_item_cost_details cpicd
4281: WHERE cpicd.cost_layer_id = cpic.cost_layer_id);
4282: ELSE
4283: -- low_level_code <> -1; items having completion
4284:

Line 4286: UPDATE cst_pac_item_cost_details cpicd

4282: ELSE
4283: -- low_level_code <> -1; items having completion
4284:
4285: l_stmt_num := 70;
4286: UPDATE cst_pac_item_cost_details cpicd
4287: SET (last_update_date,
4288: last_updated_by,
4289: last_update_login,
4290: request_id,

Line 4435: FROM cst_pac_item_cost_details cpicd

4431: AND cpllc.pac_period_id = i_pac_period_id
4432: AND cpllc.cost_group_id = i_cost_group_id)
4433: AND EXISTS
4434: (SELECT 'there is detail cost'
4435: FROM cst_pac_item_cost_details cpicd
4436: WHERE cpicd.cost_layer_id = cpic.cost_layer_id);
4437: END IF;
4438:
4439: /* --- start of auto log --- */

Line 4648: cst_pac_item_cost_details cpicd

4644: 0, cpicd.item_balance,
4645: (-1 * sign(cpicd.item_balance)), cpicd.item_balance,
4646: 0)
4647: FROM cst_pac_item_costs cpic,
4648: cst_pac_item_cost_details cpicd
4649: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
4650: AND cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
4651: AND cpicd.cost_element_id = mpacd.cost_element_id
4652: AND cpicd.level_type = mpacd.level_type),

Line 4665: FROM cst_pac_item_cost_details cpicd

4661: AND mpacd.cost_group_id = i_cost_group_id
4662: AND mpacd.pac_period_id = i_pac_period_id
4663: AND mpacd.cost_layer_id = l_cost_layer_id_tbl(l_index)
4664: AND (cost_element_id, level_type) = (SELECT cost_element_id, level_type
4665: FROM cst_pac_item_cost_details cpicd
4666: WHERE cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
4667: AND cpicd.cost_element_id = mpacd.cost_element_id
4668: AND cpicd.level_type = mpacd.level_type);
4669:

Line 4722: FROM cst_pac_item_cost_details cpicd,

4718: 0, cpicd.item_balance,
4719: (-1 * sign(cpicd.item_balance)), cpicd.item_balance,
4720: 0),
4721: l_txn_category_tbl(l_index)
4722: FROM cst_pac_item_cost_details cpicd,
4723: cst_pac_item_costs cpic
4724: WHERE cpicd.cost_layer_id = cpic.cost_layer_id
4725: AND cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
4726: AND NOT EXISTS (SELECT 1

Line 4737: UPDATE cst_pac_item_cost_details cpicd

4733: l_stmt_num := 50;
4734:
4735: IF (i_low_level_code = -1) THEN
4736: -- Items that do not have completion
4737: UPDATE cst_pac_item_cost_details cpicd
4738: SET (last_update_date,
4739: last_updated_by,
4740: last_update_login,
4741: request_id,

Line 4883: FROM cst_pac_item_cost_details cpicd

4879: AND cpllc.pac_period_id = i_pac_period_id
4880: AND cpllc.cost_group_id = i_cost_group_id)
4881: AND EXISTS
4882: (SELECT 'there is detail cost'
4883: FROM cst_pac_item_cost_details cpicd
4884: WHERE cpicd.cost_layer_id = cpic.cost_layer_id);
4885: ELSE
4886: -- low_level_code <> -1; items having completion
4887:

Line 4889: UPDATE cst_pac_item_cost_details cpicd

4885: ELSE
4886: -- low_level_code <> -1; items having completion
4887:
4888: l_stmt_num := 70;
4889: UPDATE cst_pac_item_cost_details cpicd
4890: SET (last_update_date,
4891: last_updated_by,
4892: last_update_login,
4893: request_id,

Line 5037: FROM cst_pac_item_cost_details cpicd

5033: AND cpllc.pac_period_id = i_pac_period_id
5034: AND cpllc.cost_group_id = i_cost_group_id)
5035: AND EXISTS
5036: (SELECT 'there is detail cost'
5037: FROM cst_pac_item_cost_details cpicd
5038: WHERE cpicd.cost_layer_id = cpic.cost_layer_id);
5039: END IF;
5040:
5041: /* --- start of auto log --- */

Line 5262: FROM cst_pac_item_cost_details cpicd,

5258: AND mpacd.cost_group_id = i_cost_group_id
5259: AND mpacd.cost_layer_id = cppb.cost_layer_id
5260: AND mpacd.cost_element_id = cppb.cost_element_id
5261: AND mpacd.level_type = cppb.level_type)
5262: FROM cst_pac_item_cost_details cpicd,
5263: cst_pac_item_costs cpic
5264: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
5265: AND cppb.cost_layer_id = cpicd.cost_layer_id
5266: AND cppb.cost_element_id = cpicd.cost_element_id

Line 5277: FROM CST_PAC_ITEM_COST_DETAILS cpicd1

5273: WHERE pac_period_id = i_pac_period_id
5274: AND cost_group_id = i_cost_group_id
5275: AND inventory_item_id = cppb.inventory_item_id)
5276: AND EXISTS (SELECT 1
5277: FROM CST_PAC_ITEM_COST_DETAILS cpicd1
5278: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
5279: AND cppb.cost_element_id = cpicd1.cost_element_id
5280: AND cppb.level_type = cpicd1.level_type);
5281:

Line 5318: FROM cst_pac_item_cost_details cpicd,

5314: AND mpacd.cost_group_id = i_cost_group_id
5315: AND mpacd.cost_layer_id = cppb.cost_layer_id
5316: AND mpacd.cost_element_id = cppb.cost_element_id
5317: AND mpacd.level_type = cppb.level_type)
5318: FROM cst_pac_item_cost_details cpicd,
5319: cst_pac_item_costs cpic
5320: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
5321: AND cppb.cost_layer_id = cpicd.cost_layer_id
5322: AND cppb.cost_element_id = cpicd.cost_element_id

Line 5333: FROM CST_PAC_ITEM_COST_DETAILS cpicd1

5329: WHERE pac_period_id = i_pac_period_id
5330: AND cost_group_id = i_cost_group_id
5331: AND inventory_item_id = cppb.inventory_item_id)
5332: AND EXISTS (SELECT 1
5333: FROM CST_PAC_ITEM_COST_DETAILS cpicd1
5334: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
5335: AND cppb.cost_element_id = cpicd1.cost_element_id
5336: AND cppb.level_type = cpicd1.level_type)
5337: AND NOT EXISTS (SELECT 1

Line 5378: FROM cst_pac_item_cost_details cpicd,

5374: and mpacd.cost_group_id = i_cost_group_id
5375: and mpacd.cost_layer_id = cppb.cost_layer_id
5376: and mpacd.cost_element_id = cppb.cost_element_id
5377: and mpacd.level_type = cppb.level_type)
5378: FROM cst_pac_item_cost_details cpicd,
5379: cst_pac_item_costs cpic
5380: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
5381: AND cppb.cost_layer_id = cpicd.cost_layer_id
5382: AND cppb.cost_element_id = cpicd.cost_element_id

Line 5393: FROM CST_PAC_ITEM_COST_DETAILS cpicd1

5389: WHERE pac_period_id = i_pac_period_id
5390: AND cost_group_id = i_cost_group_id
5391: AND inventory_item_id = cppb.inventory_item_id)
5392: AND EXISTS (SELECT 1
5393: FROM CST_PAC_ITEM_COST_DETAILS cpicd1
5394: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
5395: AND cppb.cost_element_id = cpicd1.cost_element_id
5396: AND cppb.level_type = cpicd1.level_type)
5397: AND EXISTS (SELECT 1

Line 5519: FROM cst_pac_item_cost_details cpicd,

5515: AND mpacd.cost_group_id = cppb.cost_group_id
5516: AND mpacd.cost_layer_id = cppb.cost_layer_id
5517: AND mpacd.cost_element_id = cppb.cost_element_id
5518: AND mpacd.level_type = cppb.level_type)
5519: FROM cst_pac_item_cost_details cpicd,
5520: cst_pac_item_costs cpic
5521: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
5522: AND cppb.cost_layer_id = cpicd.cost_layer_id
5523: AND cppb.cost_element_id = cpicd.cost_element_id

Line 5535: FROM CST_PAC_ITEM_COST_DETAILS cpicd1

5531: WHERE pac_period_id = i_pac_period_id
5532: AND cost_group_id = i_cost_group_id
5533: AND inventory_item_id = cppb.inventory_item_id)
5534: AND EXISTS (SELECT 1
5535: FROM CST_PAC_ITEM_COST_DETAILS cpicd1
5536: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
5537: AND cppb.cost_element_id = cpicd1.cost_element_id
5538: AND cppb.level_type = cpicd1.level_type);
5539:

Line 5666: cst_pac_item_cost_details cpicd,

5662: i_prog_appl_id,
5663: i_prog_id,
5664: sysdate
5665: FROM cst_pac_item_costs cpic,
5666: cst_pac_item_cost_details cpicd,
5667: cst_pac_quantity_layers cpql
5668: WHERE cpic.pac_period_id = i_pac_period_id
5669: AND cpic.cost_group_id = i_cost_group_id
5670: AND cpicd.cost_layer_id = cpic.cost_layer_id