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_COSTS

Line 426: UPDATE cst_pac_item_costs cpic

422: -- expense subinventories for asset items.
423:
424: if (i_exp_flag = 1) then
425:
426: UPDATE cst_pac_item_costs cpic
427: SET last_update_date = sysdate,
428: last_updated_by = i_user_id,
429: last_update_login = i_login_id,
430: request_id = i_req_id,

Line 2983: FROM cst_pac_item_costs

2979: nvl(buy_quantity,0)
2980: INTO l_onhand,
2981: l_make_qty,
2982: l_buy_qty
2983: FROM cst_pac_item_costs
2984: WHERE cost_layer_id = i_cost_layer_id;
2985:
2986: IF (l_value_change_flag <> 0)
2987: THEN

Line 3037: UPDATE cst_pac_item_costs cpic

3033: AND mpacd.cost_group_id = i_cost_group_id
3034: AND mpacd.cost_layer_id = i_cost_layer_id;
3035:
3036: l_stmt_num := 70;
3037: UPDATE cst_pac_item_costs cpic
3038: SET (last_updated_by,
3039: last_update_date,
3040: last_update_login,
3041: request_id,

Line 3611: FROM cst_pac_item_costs cpic

3607: l_new_buy_qty_tbl (l_index),
3608: l_new_make_qty_tbl (l_index),
3609: l_new_issue_qty_tbl (l_index),
3610: l_category_qty_tbl (l_index)
3611: FROM cst_pac_item_costs cpic
3612: WHERE cpic.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index);
3613: ELSE
3614: SELECT cpic.total_layer_quantity + CSTPPINV.l_item_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3615: cpic.buy_quantity + CSTPPINV.l_buy_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),

Line 3624: FROM cst_pac_item_costs cpic

3620: l_new_buy_qty_tbl (l_index),
3621: l_new_make_qty_tbl (l_index),
3622: l_new_issue_qty_tbl (l_index),
3623: l_category_qty_tbl (l_index)
3624: FROM cst_pac_item_costs cpic
3625: WHERE cpic.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index);
3626: END IF;
3627: END LOOP;
3628: END IF;

Line 3795: UPDATE cst_pac_item_costs cpic

3791: l_stmt_num := 50;
3792: /* Changing the query as per Bug5045692. Performance Fix */
3793: /* update quantities and balance in CPIC */
3794: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3795: UPDATE cst_pac_item_costs cpic
3796: SET total_layer_quantity = l_new_qty_tbl (l_index),
3797: issue_quantity = l_new_issue_qty_tbl (l_index),
3798: buy_quantity = l_new_buy_qty_tbl(l_index),
3799: make_quantity = l_new_make_qty_tbl (l_index),

Line 4074: FROM cst_pac_item_costs cpic,

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)
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

Line 4150: cst_pac_item_costs cpic

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
4154: FROM mtl_pac_actual_cost_details mpacd1

Line 4213: FROM cst_pac_item_costs cpic

4209: decode (sign (cpic.total_layer_quantity),
4210: 0, 0,
4211: (-1 * sign(cpicd.item_balance)), 0,
4212: cpicd.make_balance)
4213: FROM cst_pac_item_costs cpic
4214: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4215: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4216: FROM cst_pac_item_costs
4217: WHERE inventory_item_id = i_item_id

Line 4216: FROM cst_pac_item_costs

4212: cpicd.make_balance)
4213: FROM cst_pac_item_costs cpic
4214: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4215: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4216: FROM cst_pac_item_costs
4217: WHERE inventory_item_id = i_item_id
4218: AND cost_group_id = i_cost_group_id
4219: AND pac_period_id = i_pac_period_id)
4220: AND EXISTS (SELECT 1

Line 4235: UPDATE cst_pac_item_costs cpic

4231: AND cpllc.cost_group_id = i_cost_group_id
4232: AND cpllc.inventory_item_id = i_item_id);
4233:
4234: l_stmt_num := 60;
4235: UPDATE cst_pac_item_costs cpic
4236: SET (last_updated_by,
4237: last_update_date,
4238: last_update_login,
4239: request_id,

Line 4294: FROM cst_pac_item_costs_v v

4290: item_buy_cost,
4291: item_make_cost,
4292: unburdened_cost,
4293: burden_cost
4294: FROM cst_pac_item_costs_v v
4295: WHERE v.cost_layer_id = cpic.cost_layer_id)
4296: WHERE cpic.inventory_item_id = i_item_id
4297: AND cpic.cost_group_id = i_cost_group_id
4298: AND cpic.pac_period_id = i_pac_period_id

Line 4366: FROM cst_pac_item_costs cpic

4362: decode (sign (cpic.total_layer_quantity),
4363: 0, 0,
4364: (-1 * sign(cpicd.item_balance)), 0,
4365: cpicd.make_balance)
4366: FROM cst_pac_item_costs cpic
4367: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4368: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4369: FROM cst_pac_item_costs
4370: WHERE inventory_item_id = i_item_id

Line 4369: FROM cst_pac_item_costs

4365: cpicd.make_balance)
4366: FROM cst_pac_item_costs cpic
4367: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4368: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4369: FROM cst_pac_item_costs
4370: WHERE inventory_item_id = i_item_id
4371: AND cost_group_id = i_cost_group_id
4372: AND pac_period_id = i_pac_period_id)
4373: AND EXISTS (SELECT 1

Line 4389: UPDATE cst_pac_item_costs cpic

4385: AND cpllc.cost_group_id = i_cost_group_id
4386: AND cpllc.inventory_item_id = i_item_id);
4387:
4388: l_stmt_num := 80;
4389: UPDATE cst_pac_item_costs cpic
4390: SET (last_updated_by,
4391: last_update_date,
4392: last_update_login,
4393: request_id,

Line 4448: FROM cst_pac_item_costs_v v

4444: item_buy_cost,
4445: item_make_cost,
4446: unburdened_cost,
4447: burden_cost
4448: FROM cst_pac_item_costs_v v
4449: WHERE v.cost_layer_id = cpic.cost_layer_id)
4450: WHERE cpic.inventory_item_id = i_item_id
4451: AND cpic.cost_group_id = i_cost_group_id
4452: AND cpic.pac_period_id = i_pac_period_id

Line 4678: FROM cst_pac_item_costs cpic,

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)
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

Line 4754: cst_pac_item_costs cpic

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
4758: FROM mtl_pac_actual_cost_details mpacd1

Line 4817: FROM cst_pac_item_costs cpic

4813: decode (sign (cpic.total_layer_quantity),
4814: 0, 0,
4815: (-1 * sign(cpicd.item_balance)), 0,
4816: cpicd.make_balance)
4817: FROM cst_pac_item_costs cpic
4818: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4819: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4820: FROM cst_pac_item_costs
4821: WHERE pac_period_id = i_pac_period_id

Line 4820: FROM cst_pac_item_costs

4816: cpicd.make_balance)
4817: FROM cst_pac_item_costs cpic
4818: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4819: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4820: FROM cst_pac_item_costs
4821: WHERE pac_period_id = i_pac_period_id
4822: AND cost_group_id = i_cost_group_id)
4823: AND EXISTS (SELECT 1
4824: FROM cst_pac_period_balances cppb

Line 4832: cst_pac_item_costs cpic1

4828: AND cppb.cost_element_id = cpicd.cost_element_id
4829: AND cppb.level_type = cpicd.level_type)
4830: AND NOT EXISTS (SELECT 1
4831: FROM cst_pac_low_level_codes cpllc,
4832: cst_pac_item_costs cpic1
4833: WHERE cpllc.inventory_item_id = cpic1.inventory_item_id
4834: AND cpic1.cost_layer_id = cpicd.cost_layer_id
4835: AND cpllc.pac_period_id = i_pac_period_id
4836: AND cpllc.cost_group_id = i_cost_group_id);

Line 4839: UPDATE cst_pac_item_costs cpic

4835: AND cpllc.pac_period_id = i_pac_period_id
4836: AND cpllc.cost_group_id = i_cost_group_id);
4837:
4838: l_stmt_num := 60;
4839: UPDATE cst_pac_item_costs cpic
4840: SET (last_updated_by,
4841: last_update_date,
4842: last_update_login,
4843: request_id,

Line 4898: FROM cst_pac_item_costs_v v

4894: item_buy_cost,
4895: item_make_cost,
4896: unburdened_cost,
4897: burden_cost
4898: FROM cst_pac_item_costs_v v
4899: WHERE v.cost_layer_id = cpic.cost_layer_id)
4900: WHERE cpic.cost_group_id = i_cost_group_id
4901: AND cpic.pac_period_id = i_pac_period_id
4902: AND EXISTS (SELECT 1

Line 4969: FROM cst_pac_item_costs cpic

4965: decode (sign (cpic.total_layer_quantity),
4966: 0, 0,
4967: (-1 * sign(cpicd.item_balance)), 0,
4968: cpicd.make_balance)
4969: FROM cst_pac_item_costs cpic
4970: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4971: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4972: FROM cst_pac_item_costs
4973: WHERE pac_period_id = i_pac_period_id

Line 4972: FROM cst_pac_item_costs

4968: cpicd.make_balance)
4969: FROM cst_pac_item_costs cpic
4970: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4971: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4972: FROM cst_pac_item_costs
4973: WHERE pac_period_id = i_pac_period_id
4974: AND cost_group_id = i_cost_group_id)
4975: AND EXISTS (SELECT 1
4976: FROM cst_pac_period_balances cppb

Line 4984: cst_pac_item_costs cpic1

4980: AND cppb.cost_element_id = cpicd.cost_element_id
4981: AND cppb.level_type = cpicd.level_type)
4982: AND EXISTS (SELECT 1
4983: FROM cst_pac_low_level_codes cpllc,
4984: cst_pac_item_costs cpic1
4985: WHERE cpllc.low_level_code = i_low_level_code
4986: AND cpllc.pac_period_id = i_pac_period_id
4987: AND cpllc.cost_group_id = i_cost_group_id
4988: AND cpllc.inventory_item_id = cpic1.inventory_item_id

Line 4992: UPDATE cst_pac_item_costs cpic

4988: AND cpllc.inventory_item_id = cpic1.inventory_item_id
4989: AND cpic1.cost_layer_id = cpicd.cost_layer_id);
4990:
4991: l_stmt_num := 80;
4992: UPDATE cst_pac_item_costs cpic
4993: SET (last_updated_by,
4994: last_update_date,
4995: last_update_login,
4996: request_id,

Line 5051: FROM cst_pac_item_costs_v v

5047: item_buy_cost,
5048: item_make_cost,
5049: unburdened_cost,
5050: burden_cost
5051: FROM cst_pac_item_costs_v v
5052: WHERE v.cost_layer_id = cpic.cost_layer_id)
5053: WHERE cpic.cost_group_id = i_cost_group_id
5054: AND cpic.pac_period_id = i_pac_period_id
5055: AND EXISTS (SELECT 1

Line 5295: cst_pac_item_costs cpic

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
5299: AND cppb.level_type = cpicd.level_type)

Line 5354: cst_pac_item_costs cpic

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
5358: AND cppb.level_type = cpicd.level_type)

Line 5418: cst_pac_item_costs cpic

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
5422: AND cppb.level_type = cpicd.level_type)

Line 5561: cst_pac_item_costs cpic

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
5565: AND cppb.level_type = cpicd.level_type)

Line 5706: FROM cst_pac_item_costs cpic,

5702: i_request_id,
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