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 3627: MERGE INTO CST_PAC_PERIOD_BALANCES cppb

3623: END IF;
3624:
3625: l_stmt_num := 20;
3626: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3627: MERGE INTO CST_PAC_PERIOD_BALANCES cppb
3628: USING (SELECT i_pac_period_id pac_period_id,
3629: i_cost_group_id cost_group_id,
3630: CSTPPINV.l_item_id_tbl(l_index) item_id,
3631: CSTPPINV.l_cost_layer_id_tbl(l_index) cost_layer_id,

Line 3931: FROM cst_pac_period_balances cppb

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

Line 3983: FROM cst_pac_period_balances cppb

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

Line 4011: FROM cst_pac_period_balances cppb

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

Line 4190: FROM cst_pac_period_balances cppb

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
4190: FROM cst_pac_period_balances cppb
4191: WHERE cppb.pac_period_id = i_pac_period_id
4192: AND cppb.cost_group_id = i_cost_group_id
4193: AND cppb.cost_layer_id = cpicd.cost_layer_id
4194: AND cppb.cost_element_id = cpicd.cost_element_id

Line 4269: FROM cst_pac_period_balances cppb

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
4268: AND EXISTS (SELECT 1
4269: FROM cst_pac_period_balances cppb
4270: WHERE cppb.pac_period_id = i_pac_period_id
4271: AND cppb.cost_group_id = i_cost_group_id
4272: AND cppb.cost_layer_id = cpic.cost_layer_id)
4273: AND NOT EXISTS (SELECT 1

Line 4343: FROM cst_pac_period_balances cppb

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
4343: FROM cst_pac_period_balances cppb
4344: WHERE cppb.pac_period_id = i_pac_period_id
4345: AND cppb.cost_group_id = i_cost_group_id
4346: AND cppb.cost_layer_id = cpicd.cost_layer_id
4347: AND cppb.cost_element_id = cpicd.cost_element_id

Line 4423: FROM cst_pac_period_balances cppb

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
4422: AND EXISTS (SELECT 1
4423: FROM cst_pac_period_balances cppb
4424: WHERE cppb.pac_period_id = i_pac_period_id
4425: AND cppb.cost_group_id = i_cost_group_id
4426: AND cppb.cost_layer_id = cpic.cost_layer_id)
4427: AND EXISTS (SELECT 1

Line 4539: FROM cst_pac_period_balances cppb

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

Line 4589: FROM cst_pac_period_balances cppb

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

Line 4616: FROM cst_pac_period_balances cppb

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

Line 4793: FROM cst_pac_period_balances cppb

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
4794: WHERE cppb.pac_period_id = i_pac_period_id
4795: AND cppb.cost_group_id = i_cost_group_id
4796: AND cppb.cost_layer_id = cpicd.cost_layer_id
4797: AND cppb.cost_element_id = cpicd.cost_element_id

Line 4872: FROM cst_pac_period_balances cppb

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
4872: FROM cst_pac_period_balances cppb
4873: WHERE cppb.pac_period_id = i_pac_period_id
4874: AND cppb.cost_group_id = i_cost_group_id
4875: AND cppb.cost_layer_id = cpic.cost_layer_id)
4876: AND NOT EXISTS (SELECT 1

Line 4945: FROM cst_pac_period_balances cppb

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
4946: WHERE cppb.pac_period_id = i_pac_period_id
4947: AND cppb.cost_group_id = i_cost_group_id
4948: AND cppb.cost_layer_id = cpicd.cost_layer_id
4949: AND cppb.cost_element_id = cpicd.cost_element_id

Line 5025: FROM cst_pac_period_balances cppb

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
5025: FROM cst_pac_period_balances cppb
5026: WHERE cppb.pac_period_id = i_pac_period_id
5027: AND cppb.cost_group_id = i_cost_group_id
5028: AND cppb.cost_layer_id = cpic.cost_layer_id)
5029: AND EXISTS (SELECT 1

Line 5231: UPDATE CST_PAC_PERIOD_BALANCES cppb

5227: -- items without completion. So we need to update cppb for all items irrespective
5228: -- of whether they have completions or not.
5229:
5230: l_stmt_num := 10;
5231: UPDATE CST_PAC_PERIOD_BALANCES cppb
5232: SET (last_updated_by,
5233: last_update_date,
5234: last_update_login,
5235: request_id,

Line 5287: UPDATE CST_PAC_PERIOD_BALANCES cppb

5283:
5284: -- Items without completion
5285:
5286: l_stmt_num := 20;
5287: UPDATE CST_PAC_PERIOD_BALANCES cppb
5288: SET (last_updated_by,
5289: last_update_date,
5290: last_update_login,
5291: request_id,

Line 5347: UPDATE CST_PAC_PERIOD_BALANCES cppb

5343:
5344: -- Items with completion
5345:
5346: l_stmt_num := 30;
5347: UPDATE CST_PAC_PERIOD_BALANCES cppb
5348: SET (last_updated_by,
5349: last_update_date,
5350: last_update_login,
5351: request_id,

Line 5488: UPDATE CST_PAC_PERIOD_BALANCES cppb

5484: END IF;
5485: /* --- end of auto log --- */
5486:
5487: l_stmt_num := 10;
5488: UPDATE CST_PAC_PERIOD_BALANCES cppb
5489: SET (last_updated_by,
5490: last_update_date,
5491: last_update_login,
5492: request_id,

Line 5618: INSERT INTO cst_pac_period_balances (

5614: END IF;
5615: /* --- end of auto log --- */
5616:
5617: l_stmt_num := 10;
5618: INSERT INTO cst_pac_period_balances (
5619: pac_period_id,
5620: cost_group_id,
5621: inventory_item_id,
5622: cost_layer_id,

Line 5675: from cst_pac_period_balances cppb1

5671: AND cpql.cost_layer_id = cpic.cost_layer_id
5672: -- Insert ending balance records in CPPB only for asset items, i.e. only for items
5673: -- which already have atleast one record in CPPB
5674: AND exists (select 1
5675: from cst_pac_period_balances cppb1
5676: where cppb1.inventory_item_id = cpic.inventory_item_id
5677: and cppb1.cost_group_id = cpic.cost_group_id
5678: and cppb1.pac_period_id = cpic.pac_period_id));
5679: