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 3206: from mtl_pac_actual_cost_details mpacd

3202: l_stmt_num := 90;
3203:
3204: FOR x in
3205: (select actual_cost, cost_element_id, level_type
3206: from mtl_pac_actual_cost_details mpacd
3207: where mpacd.cost_layer_id = i_cost_layer_id
3208: and mpacd.cost_group_id = i_cost_group_id
3209: and mpacd.transaction_id = i_txn_id)
3210: LOOP

Line 3501: mtl_pac_actual_cost_details

3497: sum(actual_cost),
3498: sum(new_cost),
3499: sum(prior_cost)
3500: FROM
3501: mtl_pac_actual_cost_details
3502: WHERE pac_period_id = i_pac_period_id
3503: and cost_group_id = i_cost_group_id
3504: and transaction_id = i_txn_id)
3505: WHERE pac_period_id = i_pac_period_id

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

3907: o_err_msg OUT NOCOPY VARCHAR2)
3908: IS
3909: l_stmt_num NUMBER;
3910: l_max_txn_category NUMBER;
3911: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
3912: INDEX BY BINARY_INTEGER;
3913: TYPE t_txn_category_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.txn_category%TYPE
3914: INDEX BY BINARY_INTEGER;
3915: l_last_txn_id_tbl t_txn_id_tbl;

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

3909: l_stmt_num NUMBER;
3910: l_max_txn_category NUMBER;
3911: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
3912: INDEX BY BINARY_INTEGER;
3913: TYPE t_txn_category_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.txn_category%TYPE
3914: INDEX BY BINARY_INTEGER;
3915: l_last_txn_id_tbl t_txn_id_tbl;
3916: l_txn_category_tbl t_txn_category_tbl;
3917: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;

Line 3958: FROM mtl_pac_actual_cost_details mpacd

3954: l_stmt_num := 10;
3955: SELECT distinct cost_layer_id, mpacd.transaction_id, mpacd.txn_category
3956: BULK COLLECT
3957: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
3958: FROM mtl_pac_actual_cost_details mpacd
3959: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
3960: FROM mtl_pac_actual_cost_details mpacd1
3961: WHERE mpacd1.txn_category = (SELECT max(txn_category)
3962: FROM cst_pac_period_balances cppb

Line 3960: FROM mtl_pac_actual_cost_details mpacd1

3956: BULK COLLECT
3957: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
3958: FROM mtl_pac_actual_cost_details mpacd
3959: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
3960: FROM mtl_pac_actual_cost_details mpacd1
3961: WHERE mpacd1.txn_category = (SELECT max(txn_category)
3962: FROM cst_pac_period_balances cppb
3963: WHERE cppb.pac_period_id = i_pac_period_id
3964: AND cppb.cost_group_id = i_cost_group_id

Line 3986: FROM mtl_pac_actual_cost_details mpacd

3982: -- completions till this point in time.
3983:
3984: SELECT max(txn_category)
3985: INTO l_max_txn_category
3986: FROM mtl_pac_actual_cost_details mpacd
3987: WHERE mpacd.pac_period_id = i_pac_period_id
3988: AND mpacd.cost_group_id = i_cost_group_id
3989: AND mpacd.inventory_item_id = i_item_id
3990: AND EXISTS (SELECT 1

Line 4010: FROM mtl_pac_actual_cost_details mpacd

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

Line 4012: FROM mtl_pac_actual_cost_details mpacd1

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

Line 4038: FROM mtl_pac_actual_cost_details mpacd

4034: l_stmt_num := 30;
4035: SELECT distinct cost_layer_id, mpacd.transaction_id, mpacd.txn_category
4036: BULK COLLECT
4037: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
4038: FROM mtl_pac_actual_cost_details mpacd
4039: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
4040: FROM mtl_pac_actual_cost_details mpacd1
4041: WHERE mpacd1.txn_category = (SELECT max(txn_category)
4042: FROM cst_pac_period_balances cppb

Line 4040: FROM mtl_pac_actual_cost_details mpacd1

4036: BULK COLLECT
4037: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
4038: FROM mtl_pac_actual_cost_details mpacd
4039: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
4040: FROM mtl_pac_actual_cost_details mpacd1
4041: WHERE mpacd1.txn_category = (SELECT max(txn_category)
4042: FROM cst_pac_period_balances cppb
4043: WHERE cppb.pac_period_id = i_pac_period_id
4044: AND cppb.cost_group_id = i_cost_group_id

Line 4069: UPDATE mtl_pac_actual_cost_details mpacd

4065: ****************************************************************************/
4066:
4067: l_stmt_num := 35;
4068: FORALL l_index IN l_cost_layer_id_tbl.FIRST..l_cost_layer_id_tbl.LAST
4069: UPDATE mtl_pac_actual_cost_details mpacd
4070: SET variance_amount = (SELECT decode (sign(cpic.total_layer_quantity),
4071: 0, cpicd.item_balance,
4072: (-1 * sign(cpicd.item_balance)), cpicd.item_balance,
4073: 0)

Line 4099: INSERT INTO mtl_pac_actual_cost_details mpacd

4095: AND cpicd.level_type = mpacd.level_type);
4096:
4097: l_stmt_num := 40;
4098: FORALL l_index IN l_cost_layer_id_tbl.FIRST..l_cost_layer_id_tbl.LAST
4099: INSERT INTO mtl_pac_actual_cost_details mpacd
4100: (COST_GROUP_ID,
4101: TRANSACTION_ID,
4102: PAC_PERIOD_ID,
4103: COST_TYPE_ID,

Line 4154: FROM mtl_pac_actual_cost_details mpacd1

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
4154: FROM mtl_pac_actual_cost_details mpacd1
4155: WHERE mpacd1.transaction_id = l_last_txn_id_tbl (l_index)
4156: AND mpacd1.cost_layer_id = cpicd.cost_layer_id
4157: AND mpacd1.cost_element_id = cpicd.cost_element_id
4158: AND mpacd1.level_type = cpicd.level_type)

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

4516: o_err_msg OUT NOCOPY VARCHAR2)
4517: IS
4518: l_stmt_num NUMBER;
4519: l_max_txn_category NUMBER;
4520: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
4521: INDEX BY BINARY_INTEGER;
4522: TYPE t_txn_category_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.txn_category%TYPE
4523: INDEX BY BINARY_INTEGER;
4524: l_last_txn_id_tbl t_txn_id_tbl;

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

4518: l_stmt_num NUMBER;
4519: l_max_txn_category NUMBER;
4520: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
4521: INDEX BY BINARY_INTEGER;
4522: TYPE t_txn_category_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.txn_category%TYPE
4523: INDEX BY BINARY_INTEGER;
4524: l_last_txn_id_tbl t_txn_id_tbl;
4525: l_txn_category_tbl t_txn_category_tbl;
4526: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;

Line 4566: FROM mtl_pac_actual_cost_details mpacd

4562: l_stmt_num := 10;
4563: SELECT distinct cost_layer_id, mpacd.transaction_id, mpacd.txn_category
4564: BULK COLLECT
4565: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
4566: FROM mtl_pac_actual_cost_details mpacd
4567: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
4568: FROM mtl_pac_actual_cost_details mpacd1
4569: WHERE mpacd1.txn_category = (SELECT max(txn_category)
4570: FROM cst_pac_period_balances cppb

Line 4568: FROM mtl_pac_actual_cost_details mpacd1

4564: BULK COLLECT
4565: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
4566: FROM mtl_pac_actual_cost_details mpacd
4567: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
4568: FROM mtl_pac_actual_cost_details mpacd1
4569: WHERE mpacd1.txn_category = (SELECT max(txn_category)
4570: FROM cst_pac_period_balances cppb
4571: WHERE cppb.pac_period_id = i_pac_period_id
4572: AND cppb.cost_group_id = i_cost_group_id

Line 4593: FROM mtl_pac_actual_cost_details mpacd

4589: -- completions till this point in time.
4590:
4591: SELECT max(mpacd.txn_category)
4592: INTO l_max_txn_category
4593: FROM mtl_pac_actual_cost_details mpacd
4594: WHERE mpacd.pac_period_id = i_pac_period_id
4595: AND mpacd.cost_group_id = i_cost_group_id
4596: AND EXISTS (SELECT 1
4597: FROM cst_pac_low_level_codes cpllc

Line 4616: FROM mtl_pac_actual_cost_details mpacd

4612: l_stmt_num := 25;
4613: SELECT distinct cost_layer_id, mpacd.transaction_id, mpacd.txn_category
4614: BULK COLLECT
4615: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
4616: FROM mtl_pac_actual_cost_details mpacd
4617: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
4618: FROM mtl_pac_actual_cost_details mpacd1
4619: WHERE mpacd1.txn_category = (SELECT max(txn_category)
4620: FROM cst_pac_period_balances cppb

Line 4618: FROM mtl_pac_actual_cost_details mpacd1

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

Line 4643: FROM mtl_pac_actual_cost_details mpacd

4639: l_stmt_num := 30;
4640: SELECT distinct cost_layer_id, mpacd.transaction_id, mpacd.txn_category
4641: BULK COLLECT
4642: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
4643: FROM mtl_pac_actual_cost_details mpacd
4644: WHERE mpacd.transaction_id = (SELECT max(transaction_id)
4645: FROM mtl_pac_actual_cost_details mpacd1
4646: WHERE mpacd1.txn_category = (SELECT max(txn_category)
4647: FROM cst_pac_period_balances cppb

Line 4645: FROM mtl_pac_actual_cost_details mpacd1

4641: BULK COLLECT
4642: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl, l_txn_category_tbl
4643: FROM mtl_pac_actual_cost_details mpacd
4644: WHERE mpacd.transaction_id = (SELECT max(transaction_id)
4645: FROM mtl_pac_actual_cost_details mpacd1
4646: WHERE mpacd1.txn_category = (SELECT max(txn_category)
4647: FROM cst_pac_period_balances cppb
4648: WHERE cppb.pac_period_id = i_pac_period_id
4649: AND cppb.cost_group_id = i_cost_group_id

Line 4673: UPDATE mtl_pac_actual_cost_details mpacd

4669: ****************************************************************************/
4670:
4671: l_stmt_num := 35;
4672: FORALL l_index IN l_cost_layer_id_tbl.FIRST..l_cost_layer_id_tbl.LAST
4673: UPDATE mtl_pac_actual_cost_details mpacd
4674: SET variance_amount = (SELECT decode (sign(cpic.total_layer_quantity),
4675: 0, cpicd.item_balance,
4676: (-1 * sign(cpicd.item_balance)), cpicd.item_balance,
4677: 0)

Line 4703: INSERT INTO mtl_pac_actual_cost_details mpacd

4699: AND cpicd.level_type = mpacd.level_type);
4700:
4701: l_stmt_num := 40;
4702: FORALL l_index IN l_cost_layer_id_tbl.FIRST..l_cost_layer_id_tbl.LAST
4703: INSERT INTO mtl_pac_actual_cost_details mpacd
4704: (COST_GROUP_ID,
4705: TRANSACTION_ID,
4706: PAC_PERIOD_ID,
4707: COST_TYPE_ID,

Line 4758: FROM mtl_pac_actual_cost_details mpacd1

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
4758: FROM mtl_pac_actual_cost_details mpacd1
4759: WHERE mpacd1.transaction_id = l_last_txn_id_tbl (l_index)
4760: AND mpacd1.cost_layer_id = cpicd.cost_layer_id
4761: AND mpacd1.cost_element_id = cpicd.cost_element_id
4762: AND mpacd1.level_type = cpicd.level_type)

Line 5284: (SELECT /+ INDEX(MPACD MTL_PAC_ACTUAL_COST_DETAILS_N1)/

5280: sysdate,
5281: cpicd.item_balance,
5282: cpic.total_layer_quantity,
5283: cpicd.item_cost,
5284: (SELECT /*+ INDEX(MPACD MTL_PAC_ACTUAL_COST_DETAILS_N1)*/
5285: sum (nvl (mpacd.variance_amount, 0))
5286: FROM mtl_pac_actual_cost_details mpacd
5287: WHERE mpacd.txn_category = i_txn_category
5288: AND mpacd.inventory_item_id = cppb.inventory_item_id

Line 5286: FROM mtl_pac_actual_cost_details mpacd

5282: cpic.total_layer_quantity,
5283: cpicd.item_cost,
5284: (SELECT /*+ INDEX(MPACD MTL_PAC_ACTUAL_COST_DETAILS_N1)*/
5285: sum (nvl (mpacd.variance_amount, 0))
5286: FROM mtl_pac_actual_cost_details mpacd
5287: WHERE mpacd.txn_category = i_txn_category
5288: AND mpacd.inventory_item_id = cppb.inventory_item_id
5289: AND mpacd.pac_period_id = i_pac_period_id
5290: AND mpacd.cost_group_id = i_cost_group_id

Line 5303: AND i_txn_category = (SELECT /+ INDEX(MPACD1 MTL_PAC_ACTUAL_COST_DETAILS_N1)/

5299: AND cppb.level_type = cpicd.level_type)
5300: WHERE cppb.pac_period_id = i_pac_period_id
5301: AND cppb.cost_group_id = i_cost_group_id
5302: AND cppb.txn_category = i_txn_category
5303: AND i_txn_category = (SELECT /*+ INDEX(MPACD1 MTL_PAC_ACTUAL_COST_DETAILS_N1)*/
5304: max (txn_category)
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

Line 5305: FROM MTL_PAC_ACTUAL_COST_DETAILS MPACD1

5301: AND cppb.cost_group_id = i_cost_group_id
5302: AND cppb.txn_category = i_txn_category
5303: AND i_txn_category = (SELECT /*+ INDEX(MPACD1 MTL_PAC_ACTUAL_COST_DETAILS_N1)*/
5304: max (txn_category)
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)*/

Line 5343: (SELECT /+ INDEX(MPACD MTL_PAC_ACTUAL_COST_DETAILS_N1)/

5339: sysdate,
5340: cpicd.item_balance,
5341: cpic.total_layer_quantity,
5342: cpicd.item_cost,
5343: (SELECT /*+ INDEX(MPACD MTL_PAC_ACTUAL_COST_DETAILS_N1)*/
5344: sum (nvl (mpacd.variance_amount, 0))
5345: FROM mtl_pac_actual_cost_details mpacd
5346: WHERE mpacd.txn_category = i_txn_category
5347: AND mpacd.inventory_item_id = cppb.inventory_item_id

Line 5345: FROM mtl_pac_actual_cost_details mpacd

5341: cpic.total_layer_quantity,
5342: cpicd.item_cost,
5343: (SELECT /*+ INDEX(MPACD MTL_PAC_ACTUAL_COST_DETAILS_N1)*/
5344: sum (nvl (mpacd.variance_amount, 0))
5345: FROM mtl_pac_actual_cost_details mpacd
5346: WHERE mpacd.txn_category = i_txn_category
5347: AND mpacd.inventory_item_id = cppb.inventory_item_id
5348: AND mpacd.pac_period_id = i_pac_period_id
5349: AND mpacd.cost_group_id = i_cost_group_id

Line 5362: AND i_txn_category = (SELECT /+ INDEX(MPACD1 MTL_PAC_ACTUAL_COST_DETAILS_N1)/

5358: AND cppb.level_type = cpicd.level_type)
5359: WHERE cppb.pac_period_id = i_pac_period_id
5360: AND cppb.cost_group_id = i_cost_group_id
5361: AND cppb.txn_category = i_txn_category
5362: AND i_txn_category = (SELECT /*+ INDEX(MPACD1 MTL_PAC_ACTUAL_COST_DETAILS_N1)*/
5363: max (txn_category)
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

Line 5364: FROM MTL_PAC_ACTUAL_COST_DETAILS MPACD1

5360: AND cppb.cost_group_id = i_cost_group_id
5361: AND cppb.txn_category = i_txn_category
5362: AND i_txn_category = (SELECT /*+ INDEX(MPACD1 MTL_PAC_ACTUAL_COST_DETAILS_N1)*/
5363: max (txn_category)
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)*/

Line 5407: (select /+ INDEX(MPACD MTL_PAC_ACTUAL_COST_DETAILS_N1)/

5403: sysdate,
5404: cpicd.item_balance,
5405: cpic.total_layer_quantity,
5406: cpicd.item_cost,
5407: (select /*+ INDEX(MPACD MTL_PAC_ACTUAL_COST_DETAILS_N1)*/
5408: sum (nvl (mpacd.variance_amount, 0))
5409: from mtl_pac_actual_cost_details mpacd
5410: where mpacd.txn_category = i_txn_category
5411: and mpacd.inventory_item_id = cppb.inventory_item_id

Line 5409: from mtl_pac_actual_cost_details mpacd

5405: cpic.total_layer_quantity,
5406: cpicd.item_cost,
5407: (select /*+ INDEX(MPACD MTL_PAC_ACTUAL_COST_DETAILS_N1)*/
5408: sum (nvl (mpacd.variance_amount, 0))
5409: from mtl_pac_actual_cost_details mpacd
5410: where mpacd.txn_category = i_txn_category
5411: and mpacd.inventory_item_id = cppb.inventory_item_id
5412: and mpacd.pac_period_id = i_pac_period_id
5413: and mpacd.cost_group_id = i_cost_group_id

Line 5426: AND i_txn_category = (SELECT /+ INDEX(MPACD1 MTL_PAC_ACTUAL_COST_DETAILS_N1)/

5422: AND cppb.level_type = cpicd.level_type)
5423: WHERE cppb.pac_period_id = i_pac_period_id
5424: AND cppb.cost_group_id = i_cost_group_id
5425: AND cppb.txn_category = i_txn_category
5426: AND i_txn_category = (SELECT /*+ INDEX(MPACD1 MTL_PAC_ACTUAL_COST_DETAILS_N1)*/
5427: max (txn_category)
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

Line 5428: FROM MTL_PAC_ACTUAL_COST_DETAILS MPACD1

5424: AND cppb.cost_group_id = i_cost_group_id
5425: AND cppb.txn_category = i_txn_category
5426: AND i_txn_category = (SELECT /*+ INDEX(MPACD1 MTL_PAC_ACTUAL_COST_DETAILS_N1)*/
5427: max (txn_category)
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)*/

Line 5552: FROM mtl_pac_actual_cost_details mpacd

5548: cpicd.item_balance,
5549: cpic.total_layer_quantity,
5550: cpicd.item_cost,
5551: (SELECT sum (nvl (mpacd.variance_amount, 0))
5552: FROM mtl_pac_actual_cost_details mpacd
5553: WHERE mpacd.txn_category = cppb.txn_category
5554: AND mpacd.inventory_item_id = cppb.inventory_item_id
5555: AND mpacd.pac_period_id = cppb.pac_period_id
5556: AND mpacd.cost_group_id = cppb.cost_group_id

Line 5571: FROM MTL_PAC_ACTUAL_COST_DETAILS

5567: AND cppb.cost_group_id = i_cost_group_id
5568: AND cppb.txn_category = i_txn_category
5569: AND cppb.inventory_item_id = i_item_id
5570: AND i_txn_category = (SELECT max (txn_category)
5571: FROM MTL_PAC_ACTUAL_COST_DETAILS
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