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_PERIOD_BALANCES

Line 3109: MERGE INTO CST_PAC_PERIOD_BALANCES cppb

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
3110: USING (SELECT i_pac_period_id pac_period_id,
3111: i_cost_group_id cost_group_id,
3112: i_item_id item_id,
3113: i_cost_layer_id cost_layer_id,

Line 3632: MERGE INTO CST_PAC_PERIOD_BALANCES cppb

3628: END IF;
3629:
3630: l_stmt_num := 20;
3631: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3632: MERGE INTO CST_PAC_PERIOD_BALANCES cppb
3633: USING (SELECT i_pac_period_id pac_period_id,
3634: i_cost_group_id cost_group_id,
3635: CSTPPINV.l_item_id_tbl(l_index) item_id,
3636: CSTPPINV.l_cost_layer_id_tbl(l_index) cost_layer_id,

Line 3962: FROM cst_pac_period_balances cppb

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
3965: AND cppb.cost_layer_id = mpacd.cost_layer_id)
3966: AND mpacd1.inventory_item_id = mpacd.inventory_item_id

Line 4014: FROM cst_pac_period_balances cppb

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
4017: AND cppb.cost_layer_id = mpacd.cost_layer_id)
4018: AND mpacd1.txn_category = l_max_txn_category

Line 4042: FROM cst_pac_period_balances cppb

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
4045: AND cppb.cost_layer_id = mpacd.cost_layer_id)
4046: AND mpacd1.inventory_item_id = mpacd.inventory_item_id

Line 4221: FROM cst_pac_period_balances cppb

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
4221: FROM cst_pac_period_balances cppb
4222: WHERE cppb.pac_period_id = i_pac_period_id
4223: AND cppb.cost_group_id = i_cost_group_id
4224: AND cppb.cost_layer_id = cpicd.cost_layer_id
4225: AND cppb.cost_element_id = cpicd.cost_element_id

Line 4300: FROM cst_pac_period_balances cppb

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
4299: AND EXISTS (SELECT 1
4300: FROM cst_pac_period_balances cppb
4301: WHERE cppb.pac_period_id = i_pac_period_id
4302: AND cppb.cost_group_id = i_cost_group_id
4303: AND cppb.cost_layer_id = cpic.cost_layer_id)
4304: AND NOT EXISTS (SELECT 1

Line 4374: FROM cst_pac_period_balances cppb

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
4374: FROM cst_pac_period_balances cppb
4375: WHERE cppb.pac_period_id = i_pac_period_id
4376: AND cppb.cost_group_id = i_cost_group_id
4377: AND cppb.cost_layer_id = cpicd.cost_layer_id
4378: AND cppb.cost_element_id = cpicd.cost_element_id

Line 4454: FROM cst_pac_period_balances cppb

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
4453: AND EXISTS (SELECT 1
4454: FROM cst_pac_period_balances cppb
4455: WHERE cppb.pac_period_id = i_pac_period_id
4456: AND cppb.cost_group_id = i_cost_group_id
4457: AND cppb.cost_layer_id = cpic.cost_layer_id)
4458: AND EXISTS (SELECT 1

Line 4570: FROM cst_pac_period_balances cppb

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
4573: AND cppb.cost_layer_id = mpacd.cost_layer_id)
4574: AND mpacd1.inventory_item_id = mpacd.inventory_item_id

Line 4620: FROM cst_pac_period_balances cppb

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
4623: AND cppb.cost_layer_id = mpacd.cost_layer_id)
4624: AND mpacd1.txn_category = l_max_txn_category

Line 4647: FROM cst_pac_period_balances cppb

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
4650: AND cppb.cost_layer_id = mpacd.cost_layer_id)
4651: AND mpacd1.inventory_item_id = mpacd.inventory_item_id

Line 4824: FROM cst_pac_period_balances cppb

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
4825: WHERE cppb.pac_period_id = i_pac_period_id
4826: AND cppb.cost_group_id = i_cost_group_id
4827: AND cppb.cost_layer_id = cpicd.cost_layer_id
4828: AND cppb.cost_element_id = cpicd.cost_element_id

Line 4903: FROM cst_pac_period_balances cppb

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
4903: FROM cst_pac_period_balances cppb
4904: WHERE cppb.pac_period_id = i_pac_period_id
4905: AND cppb.cost_group_id = i_cost_group_id
4906: AND cppb.cost_layer_id = cpic.cost_layer_id)
4907: AND NOT EXISTS (SELECT 1

Line 4976: FROM cst_pac_period_balances cppb

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
4977: WHERE cppb.pac_period_id = i_pac_period_id
4978: AND cppb.cost_group_id = i_cost_group_id
4979: AND cppb.cost_layer_id = cpicd.cost_layer_id
4980: AND cppb.cost_element_id = cpicd.cost_element_id

Line 5056: FROM cst_pac_period_balances cppb

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
5056: FROM cst_pac_period_balances cppb
5057: WHERE cppb.pac_period_id = i_pac_period_id
5058: AND cppb.cost_group_id = i_cost_group_id
5059: AND cppb.cost_layer_id = cpic.cost_layer_id)
5060: AND EXISTS (SELECT 1

Line 5262: UPDATE CST_PAC_PERIOD_BALANCES cppb

5258: -- items without completion. So we need to update cppb for all items irrespective
5259: -- of whether they have completions or not.
5260:
5261: l_stmt_num := 10;
5262: UPDATE CST_PAC_PERIOD_BALANCES cppb
5263: SET (last_updated_by,
5264: last_update_date,
5265: last_update_login,
5266: request_id,

Line 5321: UPDATE CST_PAC_PERIOD_BALANCES cppb

5317:
5318: -- Items without completion
5319:
5320: l_stmt_num := 20;
5321: UPDATE CST_PAC_PERIOD_BALANCES cppb
5322: SET (last_updated_by,
5323: last_update_date,
5324: last_update_login,
5325: request_id,

Line 5384: UPDATE CST_PAC_PERIOD_BALANCES cppb

5380:
5381: -- Items with completion
5382:
5383: l_stmt_num := 30;
5384: UPDATE CST_PAC_PERIOD_BALANCES cppb
5385: SET (last_updated_by,
5386: last_update_date,
5387: last_update_login,
5388: request_id,

Line 5529: UPDATE CST_PAC_PERIOD_BALANCES cppb

5525: END IF;
5526: /* --- end of auto log --- */
5527:
5528: l_stmt_num := 10;
5529: UPDATE CST_PAC_PERIOD_BALANCES cppb
5530: SET (last_updated_by,
5531: last_update_date,
5532: last_update_login,
5533: request_id,

Line 5659: INSERT INTO cst_pac_period_balances (

5655: END IF;
5656: /* --- end of auto log --- */
5657:
5658: l_stmt_num := 10;
5659: INSERT INTO cst_pac_period_balances (
5660: pac_period_id,
5661: cost_group_id,
5662: inventory_item_id,
5663: cost_layer_id,

Line 5716: from cst_pac_period_balances cppb1

5712: AND cpql.cost_layer_id = cpic.cost_layer_id
5713: -- Insert ending balance records in CPPB only for asset items, i.e. only for items
5714: -- which already have atleast one record in CPPB
5715: AND exists (select 1
5716: from cst_pac_period_balances cppb1
5717: where cppb1.inventory_item_id = cpic.inventory_item_id
5718: and cppb1.cost_group_id = cpic.cost_group_id
5719: and cppb1.pac_period_id = cpic.pac_period_id));
5720: