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 MTL_PAC_ACTUAL_COST_DETAILS

Line 1563: INSERT INTO mtl_pac_actual_cost_details (

1559:
1560: l_ret_val := 1;
1561: l_stmt_num := 20;
1562:
1563: INSERT INTO mtl_pac_actual_cost_details (
1564: transaction_id,
1565: pac_period_id,
1566: cost_type_id,
1567: cost_group_id,

Line 1620: Create detail rows in MTL_PAC_ACTUAL_COST_DETAILS based on

1616: else
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, **

Line 1678: INSERT INTO mtl_pac_actual_cost_details (

1674:
1675: l_stmt_num := 40;
1676:
1677:
1678: INSERT INTO mtl_pac_actual_cost_details (
1679: transaction_id,
1680: pac_period_id,
1681: cost_type_id,
1682: cost_group_id,

Line 1730: INSERT INTO mtl_pac_actual_cost_details (

1726:
1727: else
1728: l_stmt_num := 50;
1729:
1730: INSERT INTO mtl_pac_actual_cost_details (
1731: transaction_id,
1732: pac_period_id,
1733: cost_type_id,
1734: cost_group_id,

Line 1998: from mtl_pac_actual_cost_details mpacd

1994: l_stmt_num := 10;
1995:
1996: select count(*)
1997: into l_mpacd_mat_ovhds
1998: from mtl_pac_actual_cost_details mpacd
1999: where transaction_id = i_txn_id
2000: and cost_layer_id = i_cost_layer_id
2001: and cost_element_id = 2
2002: and level_type = decode(i_level, 1,1,level_type);

Line 2008: from mtl_pac_actual_cost_details mpacd

2004: l_stmt_num := 20;
2005:
2006: select nvl(sum(actual_cost),0)
2007: into l_item_cost
2008: from mtl_pac_actual_cost_details mpacd
2009: where transaction_id = i_txn_id
2010: and cost_layer_id = i_cost_layer_id;
2011:
2012: l_stmt_num := 30;

Line 2083: UPDATE mtl_pac_actual_cost_details mpacd

2079: if (l_mpacd_mat_ovhds > 0) then
2080:
2081: l_stmt_num := 60;
2082:
2083: UPDATE mtl_pac_actual_cost_details mpacd
2084: SET (last_update_date,
2085: last_updated_by,
2086: creation_date,
2087: created_by,

Line 2121: INSERT INTO mtl_pac_actual_cost_details(

2117: else
2118:
2119: l_stmt_num := 70;
2120:
2121: INSERT INTO mtl_pac_actual_cost_details(
2122: transaction_id,
2123: pac_period_id,
2124: cost_type_id,
2125: cost_group_id,

Line 2297: FROM mtl_pac_actual_cost_details mpacd

2293:
2294: l_stmt_num := 10;
2295: FOR x IN
2296: (SELECT actual_cost, cost_element_id, level_type
2297: FROM mtl_pac_actual_cost_details mpacd
2298: WHERE mpacd.cost_layer_id = i_cost_layer_id
2299: AND mpacd.transaction_id = i_txn_id)
2300: LOOP
2301: DECLARE

Line 2510: Update mtl_pac_actual_cost_details and update the prior cost

2506: l_new_make_qty := 0;
2507:
2508:
2509: /********************************************************************
2510: ** Update mtl_pac_actual_cost_details and update the prior cost **
2511: ** to the current average for the elements that exists and insert **
2512: ** in to mtl_pac_actual_cost_details the current average cost for **
2513: ** the elements that do not exist. **
2514: ********************************************************************/

Line 2512: in to mtl_pac_actual_cost_details the current average cost for

2508:
2509: /********************************************************************
2510: ** Update mtl_pac_actual_cost_details and update the prior cost **
2511: ** to the current average for the elements that exists and insert **
2512: ** in to mtl_pac_actual_cost_details the current average cost for **
2513: ** the elements that do not exist. **
2514: ********************************************************************/
2515:
2516: l_stmt_num := 10;

Line 2518: INSERT INTO mtl_pac_actual_cost_details (

2514: ********************************************************************/
2515:
2516: l_stmt_num := 10;
2517:
2518: INSERT INTO mtl_pac_actual_cost_details (
2519: transaction_id,
2520: pac_period_id,
2521: cost_type_id,
2522: cost_group_id,

Line 2567: FROM mtl_pac_actual_cost_details mpacd

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
2568: WHERE mpacd.transaction_id = i_txn_id
2569: AND mpacd.cost_group_id = i_cost_group_id
2570: AND mpacd.cost_layer_id = i_cost_layer_id
2571: AND mpacd.cost_element_id = cpicd.cost_element_id

Line 2577: FROM mtl_pac_actual_cost_details mpacd

2573:
2574: l_stmt_num := 20;
2575: FOR x IN
2576: (SELECT actual_cost, cost_element_id, level_type
2577: FROM mtl_pac_actual_cost_details mpacd
2578: WHERE mpacd.cost_layer_id = i_cost_layer_id
2579: AND mpacd.transaction_id = i_txn_id)
2580: LOOP
2581: DECLARE

Line 2777: INSERT INTO mtl_pac_actual_cost_details (

2773: ** It will use the current cost in cpicd as the new cost **
2774: ********************************************************************/
2775: l_stmt_num := 10;
2776:
2777: INSERT INTO mtl_pac_actual_cost_details (
2778: transaction_id,
2779: pac_period_id,
2780: cost_type_id,
2781: cost_group_id,

Line 2856: INSERT INTO mtl_pac_actual_cost_details (

2852: ** New cost will be calculated based on current cost (if exists) **
2853: ** and cost change in mptcd. **
2854: ********************************************************************/
2855: l_stmt_num := 20;
2856: INSERT INTO mtl_pac_actual_cost_details (
2857: transaction_id,
2858: pac_period_id,
2859: cost_type_id,
2860: cost_group_id,

Line 3031: FROM mtl_pac_actual_cost_details mpacd

3027: mpacd.new_make_cost,
3028: mpacd.new_cost * l_onhand,
3029: mpacd.new_buy_cost * l_buy_qty,
3030: mpacd.new_make_cost * l_make_qty
3031: FROM mtl_pac_actual_cost_details mpacd
3032: WHERE mpacd.transaction_id = i_txn_id
3033: AND mpacd.cost_group_id = i_cost_group_id
3034: AND mpacd.cost_layer_id = i_cost_layer_id;
3035:

Line 3123: FROM mtl_pac_actual_cost_details mpacd

3119: (l_onhand * (mpacd.actual_cost - mpacd.prior_cost)) category_balance,
3120: (l_onhand * mpacd.actual_cost) period_balance,
3121: l_onhand period_quantity,
3122: mpacd.actual_cost
3123: FROM mtl_pac_actual_cost_details mpacd
3124: WHERE mpacd.cost_layer_id = i_cost_layer_id
3125: AND mpacd.pac_period_id = i_pac_period_id
3126: AND mpacd.cost_group_id = i_cost_group_id
3127: AND mpacd.transaction_id = i_txn_id) mpacd

Line 3201: from mtl_pac_actual_cost_details mpacd

3197: l_stmt_num := 90;
3198:
3199: FOR x in
3200: (select actual_cost, cost_element_id, level_type
3201: from mtl_pac_actual_cost_details mpacd
3202: where mpacd.cost_layer_id = i_cost_layer_id
3203: and mpacd.cost_group_id = i_cost_group_id
3204: and mpacd.transaction_id = i_txn_id)
3205: LOOP

Line 3496: mtl_pac_actual_cost_details

3492: sum(actual_cost),
3493: sum(new_cost),
3494: sum(prior_cost)
3495: FROM
3496: mtl_pac_actual_cost_details
3497: WHERE pac_period_id = i_pac_period_id
3498: and cost_group_id = i_cost_group_id
3499: and transaction_id = i_txn_id)
3500: WHERE pac_period_id = i_pac_period_id

Line 3880: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE

3876: o_err_msg OUT NOCOPY VARCHAR2)
3877: IS
3878: l_stmt_num NUMBER;
3879: l_max_txn_category NUMBER;
3880: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
3881: INDEX BY BINARY_INTEGER;
3882: TYPE t_txn_category_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.txn_category%TYPE
3883: INDEX BY BINARY_INTEGER;
3884: l_last_txn_id_tbl t_txn_id_tbl;

Line 3882: TYPE t_txn_category_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.txn_category%TYPE

3878: l_stmt_num NUMBER;
3879: l_max_txn_category NUMBER;
3880: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
3881: INDEX BY BINARY_INTEGER;
3882: TYPE t_txn_category_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.txn_category%TYPE
3883: INDEX BY BINARY_INTEGER;
3884: l_last_txn_id_tbl t_txn_id_tbl;
3885: l_txn_category_tbl t_txn_category_tbl;
3886: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;

Line 3927: FROM mtl_pac_actual_cost_details mpacd

3923: l_stmt_num := 10;
3924: SELECT distinct cost_layer_id, mpacd.transaction_id, mpacd.txn_category
3925: BULK COLLECT
3926: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
3927: FROM mtl_pac_actual_cost_details mpacd
3928: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
3929: FROM mtl_pac_actual_cost_details mpacd1
3930: WHERE mpacd1.txn_category = (SELECT max(txn_category)
3931: FROM cst_pac_period_balances cppb

Line 3929: FROM mtl_pac_actual_cost_details mpacd1

3925: BULK COLLECT
3926: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
3927: FROM mtl_pac_actual_cost_details mpacd
3928: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
3929: FROM mtl_pac_actual_cost_details mpacd1
3930: WHERE mpacd1.txn_category = (SELECT max(txn_category)
3931: FROM cst_pac_period_balances cppb
3932: WHERE cppb.pac_period_id = i_pac_period_id
3933: AND cppb.cost_group_id = i_cost_group_id

Line 3955: FROM mtl_pac_actual_cost_details mpacd

3951: -- completions till this point in time.
3952:
3953: SELECT max(txn_category)
3954: INTO l_max_txn_category
3955: FROM mtl_pac_actual_cost_details mpacd
3956: WHERE mpacd.pac_period_id = i_pac_period_id
3957: AND mpacd.cost_group_id = i_cost_group_id
3958: AND mpacd.inventory_item_id = i_item_id
3959: AND EXISTS (SELECT 1

Line 3979: FROM mtl_pac_actual_cost_details mpacd

3975: l_stmt_num := 25;
3976: SELECT distinct cost_layer_id, mpacd.transaction_id, mpacd.txn_category
3977: BULK COLLECT
3978: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
3979: FROM mtl_pac_actual_cost_details mpacd
3980: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
3981: FROM mtl_pac_actual_cost_details mpacd1
3982: WHERE mpacd1.txn_category = (SELECT max(txn_category)
3983: FROM cst_pac_period_balances cppb

Line 3981: FROM mtl_pac_actual_cost_details mpacd1

3977: BULK COLLECT
3978: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
3979: FROM mtl_pac_actual_cost_details mpacd
3980: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
3981: FROM mtl_pac_actual_cost_details mpacd1
3982: WHERE mpacd1.txn_category = (SELECT max(txn_category)
3983: FROM cst_pac_period_balances cppb
3984: WHERE cppb.pac_period_id = i_pac_period_id
3985: AND cppb.cost_group_id = i_cost_group_id

Line 4007: FROM mtl_pac_actual_cost_details mpacd

4003: l_stmt_num := 30;
4004: SELECT distinct cost_layer_id, mpacd.transaction_id, mpacd.txn_category
4005: BULK COLLECT
4006: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
4007: FROM mtl_pac_actual_cost_details mpacd
4008: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
4009: FROM mtl_pac_actual_cost_details mpacd1
4010: WHERE mpacd1.txn_category = (SELECT max(txn_category)
4011: FROM cst_pac_period_balances cppb

Line 4009: FROM mtl_pac_actual_cost_details mpacd1

4005: BULK COLLECT
4006: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
4007: FROM mtl_pac_actual_cost_details mpacd
4008: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
4009: FROM mtl_pac_actual_cost_details mpacd1
4010: WHERE mpacd1.txn_category = (SELECT max(txn_category)
4011: FROM cst_pac_period_balances cppb
4012: WHERE cppb.pac_period_id = i_pac_period_id
4013: AND cppb.cost_group_id = i_cost_group_id

Line 4038: UPDATE mtl_pac_actual_cost_details mpacd

4034: ****************************************************************************/
4035:
4036: l_stmt_num := 35;
4037: FORALL l_index IN l_cost_layer_id_tbl.FIRST..l_cost_layer_id_tbl.LAST
4038: UPDATE mtl_pac_actual_cost_details mpacd
4039: SET variance_amount = (SELECT decode (sign(cpic.total_layer_quantity),
4040: 0, cpicd.item_balance,
4041: (-1 * sign(cpicd.item_balance)), cpicd.item_balance,
4042: 0)

Line 4068: INSERT INTO mtl_pac_actual_cost_details mpacd

4064: AND cpicd.level_type = mpacd.level_type);
4065:
4066: l_stmt_num := 40;
4067: FORALL l_index IN l_cost_layer_id_tbl.FIRST..l_cost_layer_id_tbl.LAST
4068: INSERT INTO mtl_pac_actual_cost_details mpacd
4069: (COST_GROUP_ID,
4070: TRANSACTION_ID,
4071: PAC_PERIOD_ID,
4072: COST_TYPE_ID,

Line 4123: FROM mtl_pac_actual_cost_details mpacd1

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
4123: FROM mtl_pac_actual_cost_details mpacd1
4124: WHERE mpacd1.transaction_id = l_last_txn_id_tbl (l_index)
4125: AND mpacd1.cost_layer_id = cpicd.cost_layer_id
4126: AND mpacd1.cost_element_id = cpicd.cost_element_id
4127: AND mpacd1.level_type = cpicd.level_type)

Line 4489: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE

4485: o_err_msg OUT NOCOPY VARCHAR2)
4486: IS
4487: l_stmt_num NUMBER;
4488: l_max_txn_category NUMBER;
4489: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
4490: INDEX BY BINARY_INTEGER;
4491: TYPE t_txn_category_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.txn_category%TYPE
4492: INDEX BY BINARY_INTEGER;
4493: l_last_txn_id_tbl t_txn_id_tbl;

Line 4491: TYPE t_txn_category_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.txn_category%TYPE

4487: l_stmt_num NUMBER;
4488: l_max_txn_category NUMBER;
4489: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
4490: INDEX BY BINARY_INTEGER;
4491: TYPE t_txn_category_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.txn_category%TYPE
4492: INDEX BY BINARY_INTEGER;
4493: l_last_txn_id_tbl t_txn_id_tbl;
4494: l_txn_category_tbl t_txn_category_tbl;
4495: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;

Line 4535: FROM mtl_pac_actual_cost_details mpacd

4531: l_stmt_num := 10;
4532: SELECT distinct cost_layer_id, mpacd.transaction_id, mpacd.txn_category
4533: BULK COLLECT
4534: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
4535: FROM mtl_pac_actual_cost_details mpacd
4536: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
4537: FROM mtl_pac_actual_cost_details mpacd1
4538: WHERE mpacd1.txn_category = (SELECT max(txn_category)
4539: FROM cst_pac_period_balances cppb

Line 4537: FROM mtl_pac_actual_cost_details mpacd1

4533: BULK COLLECT
4534: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
4535: FROM mtl_pac_actual_cost_details mpacd
4536: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
4537: FROM mtl_pac_actual_cost_details mpacd1
4538: WHERE mpacd1.txn_category = (SELECT max(txn_category)
4539: FROM cst_pac_period_balances cppb
4540: WHERE cppb.pac_period_id = i_pac_period_id
4541: AND cppb.cost_group_id = i_cost_group_id

Line 4562: FROM mtl_pac_actual_cost_details mpacd

4558: -- completions till this point in time.
4559:
4560: SELECT max(mpacd.txn_category)
4561: INTO l_max_txn_category
4562: FROM mtl_pac_actual_cost_details mpacd
4563: WHERE mpacd.pac_period_id = i_pac_period_id
4564: AND mpacd.cost_group_id = i_cost_group_id
4565: AND EXISTS (SELECT 1
4566: FROM cst_pac_low_level_codes cpllc

Line 4585: FROM mtl_pac_actual_cost_details mpacd

4581: l_stmt_num := 25;
4582: SELECT distinct cost_layer_id, mpacd.transaction_id, mpacd.txn_category
4583: BULK COLLECT
4584: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
4585: FROM mtl_pac_actual_cost_details mpacd
4586: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
4587: FROM mtl_pac_actual_cost_details mpacd1
4588: WHERE mpacd1.txn_category = (SELECT max(txn_category)
4589: FROM cst_pac_period_balances cppb

Line 4587: FROM mtl_pac_actual_cost_details mpacd1

4583: BULK COLLECT
4584: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
4585: FROM mtl_pac_actual_cost_details mpacd
4586: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
4587: FROM mtl_pac_actual_cost_details mpacd1
4588: WHERE mpacd1.txn_category = (SELECT max(txn_category)
4589: FROM cst_pac_period_balances cppb
4590: WHERE cppb.pac_period_id = i_pac_period_id
4591: AND cppb.cost_group_id = i_cost_group_id

Line 4612: FROM mtl_pac_actual_cost_details mpacd

4608: l_stmt_num := 30;
4609: SELECT distinct cost_layer_id, mpacd.transaction_id, mpacd.txn_category
4610: BULK COLLECT
4611: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
4612: FROM mtl_pac_actual_cost_details mpacd
4613: WHERE mpacd.transaction_id = (SELECT max(transaction_id)
4614: FROM mtl_pac_actual_cost_details mpacd1
4615: WHERE mpacd1.txn_category = (SELECT max(txn_category)
4616: FROM cst_pac_period_balances cppb

Line 4614: FROM mtl_pac_actual_cost_details mpacd1

4610: BULK COLLECT
4611: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
4612: FROM mtl_pac_actual_cost_details mpacd
4613: WHERE mpacd.transaction_id = (SELECT max(transaction_id)
4614: FROM mtl_pac_actual_cost_details mpacd1
4615: WHERE mpacd1.txn_category = (SELECT max(txn_category)
4616: FROM cst_pac_period_balances cppb
4617: WHERE cppb.pac_period_id = i_pac_period_id
4618: AND cppb.cost_group_id = i_cost_group_id

Line 4642: UPDATE mtl_pac_actual_cost_details mpacd

4638: ****************************************************************************/
4639:
4640: l_stmt_num := 35;
4641: FORALL l_index IN l_cost_layer_id_tbl.FIRST..l_cost_layer_id_tbl.LAST
4642: UPDATE mtl_pac_actual_cost_details mpacd
4643: SET variance_amount = (SELECT decode (sign(cpic.total_layer_quantity),
4644: 0, cpicd.item_balance,
4645: (-1 * sign(cpicd.item_balance)), cpicd.item_balance,
4646: 0)

Line 4672: INSERT INTO mtl_pac_actual_cost_details mpacd

4668: AND cpicd.level_type = mpacd.level_type);
4669:
4670: l_stmt_num := 40;
4671: FORALL l_index IN l_cost_layer_id_tbl.FIRST..l_cost_layer_id_tbl.LAST
4672: INSERT INTO mtl_pac_actual_cost_details mpacd
4673: (COST_GROUP_ID,
4674: TRANSACTION_ID,
4675: PAC_PERIOD_ID,
4676: COST_TYPE_ID,

Line 4727: FROM mtl_pac_actual_cost_details mpacd1

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
4727: FROM mtl_pac_actual_cost_details mpacd1
4728: WHERE mpacd1.transaction_id = l_last_txn_id_tbl (l_index)
4729: AND mpacd1.cost_layer_id = cpicd.cost_layer_id
4730: AND mpacd1.cost_element_id = cpicd.cost_element_id
4731: AND mpacd1.level_type = cpicd.level_type)

Line 5254: FROM mtl_pac_actual_cost_details mpacd

5250: cpicd.item_balance,
5251: cpic.total_layer_quantity,
5252: cpicd.item_cost,
5253: (SELECT sum (nvl (mpacd.variance_amount, 0))
5254: FROM mtl_pac_actual_cost_details mpacd
5255: WHERE mpacd.txn_category = i_txn_category
5256: AND mpacd.inventory_item_id = cppb.inventory_item_id
5257: AND mpacd.pac_period_id = i_pac_period_id
5258: AND mpacd.cost_group_id = i_cost_group_id

Line 5272: FROM MTL_PAC_ACTUAL_COST_DETAILS

5268: WHERE cppb.pac_period_id = i_pac_period_id
5269: AND cppb.cost_group_id = i_cost_group_id
5270: AND cppb.txn_category = i_txn_category
5271: AND i_txn_category = (SELECT max (txn_category)
5272: FROM MTL_PAC_ACTUAL_COST_DETAILS
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

Line 5310: FROM mtl_pac_actual_cost_details mpacd

5306: cpicd.item_balance,
5307: cpic.total_layer_quantity,
5308: cpicd.item_cost,
5309: (SELECT sum (nvl (mpacd.variance_amount, 0))
5310: FROM mtl_pac_actual_cost_details mpacd
5311: WHERE mpacd.txn_category = i_txn_category
5312: AND mpacd.inventory_item_id = cppb.inventory_item_id
5313: AND mpacd.pac_period_id = i_pac_period_id
5314: AND mpacd.cost_group_id = i_cost_group_id

Line 5328: FROM MTL_PAC_ACTUAL_COST_DETAILS

5324: WHERE cppb.pac_period_id = i_pac_period_id
5325: AND cppb.cost_group_id = i_cost_group_id
5326: AND cppb.txn_category = i_txn_category
5327: AND i_txn_category = (SELECT max (txn_category)
5328: FROM MTL_PAC_ACTUAL_COST_DETAILS
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

Line 5370: from mtl_pac_actual_cost_details mpacd

5366: cpicd.item_balance,
5367: cpic.total_layer_quantity,
5368: cpicd.item_cost,
5369: (select sum (nvl (mpacd.variance_amount, 0))
5370: from mtl_pac_actual_cost_details mpacd
5371: where mpacd.txn_category = i_txn_category
5372: and mpacd.inventory_item_id = cppb.inventory_item_id
5373: and mpacd.pac_period_id = i_pac_period_id
5374: and mpacd.cost_group_id = i_cost_group_id

Line 5388: FROM MTL_PAC_ACTUAL_COST_DETAILS

5384: WHERE cppb.pac_period_id = i_pac_period_id
5385: AND cppb.cost_group_id = i_cost_group_id
5386: AND cppb.txn_category = i_txn_category
5387: AND i_txn_category = (SELECT max (txn_category)
5388: FROM MTL_PAC_ACTUAL_COST_DETAILS
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

Line 5511: FROM mtl_pac_actual_cost_details mpacd

5507: cpicd.item_balance,
5508: cpic.total_layer_quantity,
5509: cpicd.item_cost,
5510: (SELECT sum (nvl (mpacd.variance_amount, 0))
5511: FROM mtl_pac_actual_cost_details mpacd
5512: WHERE mpacd.txn_category = cppb.txn_category
5513: AND mpacd.inventory_item_id = cppb.inventory_item_id
5514: AND mpacd.pac_period_id = cppb.pac_period_id
5515: AND mpacd.cost_group_id = cppb.cost_group_id

Line 5530: FROM MTL_PAC_ACTUAL_COST_DETAILS

5526: AND cppb.cost_group_id = i_cost_group_id
5527: AND cppb.txn_category = i_txn_category
5528: AND cppb.inventory_item_id = i_item_id
5529: AND i_txn_category = (SELECT max (txn_category)
5530: FROM MTL_PAC_ACTUAL_COST_DETAILS
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