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 3606: FROM cst_pac_item_costs cpic

3602: l_new_buy_qty_tbl (l_index),
3603: l_new_make_qty_tbl (l_index),
3604: l_new_issue_qty_tbl (l_index),
3605: l_category_qty_tbl (l_index)
3606: FROM cst_pac_item_costs cpic
3607: WHERE cpic.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index);
3608: ELSE
3609: SELECT cpic.total_layer_quantity + CSTPPINV.l_item_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3610: cpic.buy_quantity + CSTPPINV.l_buy_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),

Line 3619: FROM cst_pac_item_costs cpic

3615: l_new_buy_qty_tbl (l_index),
3616: l_new_make_qty_tbl (l_index),
3617: l_new_issue_qty_tbl (l_index),
3618: l_category_qty_tbl (l_index)
3619: FROM cst_pac_item_costs cpic
3620: WHERE cpic.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index);
3621: END IF;
3622: END LOOP;
3623: END IF;

Line 3764: UPDATE cst_pac_item_costs cpic

3760: l_stmt_num := 50;
3761: /* Changing the query as per Bug5045692. Performance Fix */
3762: /* update quantities and balance in CPIC */
3763: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3764: UPDATE cst_pac_item_costs cpic
3765: SET total_layer_quantity = l_new_qty_tbl (l_index),
3766: issue_quantity = l_new_issue_qty_tbl (l_index),
3767: buy_quantity = l_new_buy_qty_tbl(l_index),
3768: make_quantity = l_new_make_qty_tbl (l_index),

Line 4043: FROM cst_pac_item_costs cpic,

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

Line 4119: cst_pac_item_costs cpic

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

Line 4182: FROM cst_pac_item_costs cpic

4178: decode (sign (cpic.total_layer_quantity),
4179: 0, 0,
4180: (-1 * sign(cpicd.item_balance)), 0,
4181: cpicd.make_balance)
4182: FROM cst_pac_item_costs cpic
4183: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4184: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4185: FROM cst_pac_item_costs
4186: WHERE inventory_item_id = i_item_id

Line 4185: FROM cst_pac_item_costs

4181: cpicd.make_balance)
4182: FROM cst_pac_item_costs cpic
4183: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4184: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4185: FROM cst_pac_item_costs
4186: WHERE inventory_item_id = i_item_id
4187: AND cost_group_id = i_cost_group_id
4188: AND pac_period_id = i_pac_period_id)
4189: AND EXISTS (SELECT 1

Line 4204: UPDATE cst_pac_item_costs cpic

4200: AND cpllc.cost_group_id = i_cost_group_id
4201: AND cpllc.inventory_item_id = i_item_id);
4202:
4203: l_stmt_num := 60;
4204: UPDATE cst_pac_item_costs cpic
4205: SET (last_updated_by,
4206: last_update_date,
4207: last_update_login,
4208: request_id,

Line 4263: FROM cst_pac_item_costs_v v

4259: item_buy_cost,
4260: item_make_cost,
4261: unburdened_cost,
4262: burden_cost
4263: FROM cst_pac_item_costs_v v
4264: WHERE v.cost_layer_id = cpic.cost_layer_id)
4265: WHERE cpic.inventory_item_id = i_item_id
4266: AND cpic.cost_group_id = i_cost_group_id
4267: AND cpic.pac_period_id = i_pac_period_id

Line 4335: FROM cst_pac_item_costs cpic

4331: decode (sign (cpic.total_layer_quantity),
4332: 0, 0,
4333: (-1 * sign(cpicd.item_balance)), 0,
4334: cpicd.make_balance)
4335: FROM cst_pac_item_costs cpic
4336: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4337: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4338: FROM cst_pac_item_costs
4339: WHERE inventory_item_id = i_item_id

Line 4338: FROM cst_pac_item_costs

4334: cpicd.make_balance)
4335: FROM cst_pac_item_costs cpic
4336: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4337: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4338: FROM cst_pac_item_costs
4339: WHERE inventory_item_id = i_item_id
4340: AND cost_group_id = i_cost_group_id
4341: AND pac_period_id = i_pac_period_id)
4342: AND EXISTS (SELECT 1

Line 4358: UPDATE cst_pac_item_costs cpic

4354: AND cpllc.cost_group_id = i_cost_group_id
4355: AND cpllc.inventory_item_id = i_item_id);
4356:
4357: l_stmt_num := 80;
4358: UPDATE cst_pac_item_costs cpic
4359: SET (last_updated_by,
4360: last_update_date,
4361: last_update_login,
4362: request_id,

Line 4417: FROM cst_pac_item_costs_v v

4413: item_buy_cost,
4414: item_make_cost,
4415: unburdened_cost,
4416: burden_cost
4417: FROM cst_pac_item_costs_v v
4418: WHERE v.cost_layer_id = cpic.cost_layer_id)
4419: WHERE cpic.inventory_item_id = i_item_id
4420: AND cpic.cost_group_id = i_cost_group_id
4421: AND cpic.pac_period_id = i_pac_period_id

Line 4647: FROM cst_pac_item_costs cpic,

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

Line 4723: cst_pac_item_costs cpic

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

Line 4786: FROM cst_pac_item_costs cpic

4782: decode (sign (cpic.total_layer_quantity),
4783: 0, 0,
4784: (-1 * sign(cpicd.item_balance)), 0,
4785: cpicd.make_balance)
4786: FROM cst_pac_item_costs cpic
4787: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4788: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4789: FROM cst_pac_item_costs
4790: WHERE pac_period_id = i_pac_period_id

Line 4789: FROM cst_pac_item_costs

4785: cpicd.make_balance)
4786: FROM cst_pac_item_costs cpic
4787: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4788: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4789: FROM cst_pac_item_costs
4790: WHERE pac_period_id = i_pac_period_id
4791: AND cost_group_id = i_cost_group_id)
4792: AND EXISTS (SELECT 1
4793: FROM cst_pac_period_balances cppb

Line 4801: cst_pac_item_costs cpic1

4797: AND cppb.cost_element_id = cpicd.cost_element_id
4798: AND cppb.level_type = cpicd.level_type)
4799: AND NOT EXISTS (SELECT 1
4800: FROM cst_pac_low_level_codes cpllc,
4801: cst_pac_item_costs cpic1
4802: WHERE cpllc.inventory_item_id = cpic1.inventory_item_id
4803: AND cpic1.cost_layer_id = cpicd.cost_layer_id
4804: AND cpllc.pac_period_id = i_pac_period_id
4805: AND cpllc.cost_group_id = i_cost_group_id);

Line 4808: UPDATE cst_pac_item_costs cpic

4804: AND cpllc.pac_period_id = i_pac_period_id
4805: AND cpllc.cost_group_id = i_cost_group_id);
4806:
4807: l_stmt_num := 60;
4808: UPDATE cst_pac_item_costs cpic
4809: SET (last_updated_by,
4810: last_update_date,
4811: last_update_login,
4812: request_id,

Line 4867: FROM cst_pac_item_costs_v v

4863: item_buy_cost,
4864: item_make_cost,
4865: unburdened_cost,
4866: burden_cost
4867: FROM cst_pac_item_costs_v v
4868: WHERE v.cost_layer_id = cpic.cost_layer_id)
4869: WHERE cpic.cost_group_id = i_cost_group_id
4870: AND cpic.pac_period_id = i_pac_period_id
4871: AND EXISTS (SELECT 1

Line 4938: FROM cst_pac_item_costs cpic

4934: decode (sign (cpic.total_layer_quantity),
4935: 0, 0,
4936: (-1 * sign(cpicd.item_balance)), 0,
4937: cpicd.make_balance)
4938: FROM cst_pac_item_costs cpic
4939: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4940: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4941: FROM cst_pac_item_costs
4942: WHERE pac_period_id = i_pac_period_id

Line 4941: FROM cst_pac_item_costs

4937: cpicd.make_balance)
4938: FROM cst_pac_item_costs cpic
4939: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
4940: WHERE cpicd.cost_layer_id IN ( SELECT cost_layer_id
4941: FROM cst_pac_item_costs
4942: WHERE pac_period_id = i_pac_period_id
4943: AND cost_group_id = i_cost_group_id)
4944: AND EXISTS (SELECT 1
4945: FROM cst_pac_period_balances cppb

Line 4953: cst_pac_item_costs cpic1

4949: AND cppb.cost_element_id = cpicd.cost_element_id
4950: AND cppb.level_type = cpicd.level_type)
4951: AND EXISTS (SELECT 1
4952: FROM cst_pac_low_level_codes cpllc,
4953: cst_pac_item_costs cpic1
4954: WHERE cpllc.low_level_code = i_low_level_code
4955: AND cpllc.pac_period_id = i_pac_period_id
4956: AND cpllc.cost_group_id = i_cost_group_id
4957: AND cpllc.inventory_item_id = cpic1.inventory_item_id

Line 4961: UPDATE cst_pac_item_costs cpic

4957: AND cpllc.inventory_item_id = cpic1.inventory_item_id
4958: AND cpic1.cost_layer_id = cpicd.cost_layer_id);
4959:
4960: l_stmt_num := 80;
4961: UPDATE cst_pac_item_costs cpic
4962: SET (last_updated_by,
4963: last_update_date,
4964: last_update_login,
4965: request_id,

Line 5020: FROM cst_pac_item_costs_v v

5016: item_buy_cost,
5017: item_make_cost,
5018: unburdened_cost,
5019: burden_cost
5020: FROM cst_pac_item_costs_v v
5021: WHERE v.cost_layer_id = cpic.cost_layer_id)
5022: WHERE cpic.cost_group_id = i_cost_group_id
5023: AND cpic.pac_period_id = i_pac_period_id
5024: AND EXISTS (SELECT 1

Line 5263: cst_pac_item_costs cpic

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

Line 5319: cst_pac_item_costs cpic

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

Line 5379: cst_pac_item_costs cpic

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

Line 5520: cst_pac_item_costs cpic

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

Line 5665: FROM cst_pac_item_costs cpic,

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