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.CST_PAC_ITERATION_PROCESS_PVT dependencies on CST_PAC_PERIOD_BALANCES

Line 1277: TYPE t_txn_category_tbl IS TABLE OF CST_PAC_PERIOD_BALANCES.txn_category%TYPE

1273:
1274: l_stmt_num NUMBER;
1275: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
1276: INDEX BY BINARY_INTEGER;
1277: TYPE t_txn_category_tbl IS TABLE OF CST_PAC_PERIOD_BALANCES.txn_category%TYPE
1278: INDEX BY BINARY_INTEGER;
1279: l_last_txn_id_tbl t_txn_id_tbl;
1280: l_txn_category_tbl t_txn_category_tbl;
1281: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;

Line 1470: FROM cst_pac_period_balances cppb

1466: where inventory_item_id = p_inventory_item_id
1467: and pac_period_id = p_pac_period_id
1468: and cost_group_id = p_cost_group_id)
1469: AND EXISTS (SELECT 1
1470: FROM cst_pac_period_balances cppb
1471: WHERE cppb.pac_period_id = p_pac_period_id
1472: AND cppb.cost_group_id = p_cost_group_id
1473: AND cppb.cost_layer_id = cpicd.cost_layer_id
1474: AND cppb.cost_element_id = cpicd.cost_element_id

Line 1550: FROM cst_pac_period_balances cppb

1546: WHERE cpic.pac_period_id = p_pac_period_id
1547: AND cpic.cost_group_id = p_cost_group_id
1548: AND cpic.inventory_item_id = p_inventory_item_id
1549: AND EXISTS (SELECT 1
1550: FROM cst_pac_period_balances cppb
1551: WHERE cppb.pac_period_id = p_pac_period_id
1552: AND cppb.cost_group_id = p_cost_group_id
1553: AND cppb.cost_layer_id = cpic.cost_layer_id
1554: AND cppb.inventory_item_id = p_inventory_item_id)

Line 1629: FROM cst_pac_period_balances cppb

1625: where inventory_item_id = p_inventory_item_id
1626: and pac_period_id = p_pac_period_id
1627: and cost_group_id = p_cost_group_id)
1628: AND EXISTS (SELECT 1
1629: FROM cst_pac_period_balances cppb
1630: WHERE cppb.pac_period_id = p_pac_period_id
1631: AND cppb.cost_group_id = p_cost_group_id
1632: AND cppb.cost_layer_id = cpicd.cost_layer_id
1633: AND cppb.cost_element_id = cpicd.cost_element_id

Line 1710: FROM cst_pac_period_balances cppb

1706: WHERE cpic.pac_period_id = p_pac_period_id
1707: AND cpic.cost_group_id = p_cost_group_id
1708: AND cpic.inventory_item_id = p_inventory_item_id
1709: AND EXISTS (SELECT 1
1710: FROM cst_pac_period_balances cppb
1711: WHERE cppb.pac_period_id = p_pac_period_id
1712: AND cppb.cost_group_id = p_cost_group_id
1713: AND cppb.cost_layer_id = cpic.cost_layer_id
1714: AND cppb.inventory_item_id = p_inventory_item_id)

Line 1854: UPDATE CST_PAC_PERIOD_BALANCES cppb

1850: );
1851:
1852: -- Update cumulative period balances in CPPB for interorg receipts
1853: -- with txn category 8
1854: UPDATE CST_PAC_PERIOD_BALANCES cppb
1855: SET (last_updated_by,
1856: last_update_date,
1857: last_update_login,
1858: request_id,

Line 1915: UPDATE CST_PAC_PERIOD_BALANCES cppb

1911: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
1912: AND cppb.cost_element_id = cpicd1.cost_element_id
1913: AND cppb.level_type = cpicd1.level_type);
1914:
1915: UPDATE CST_PAC_PERIOD_BALANCES cppb
1916: SET txn_category_value =
1917: (SELECT sum (nvl (mpacd.actual_cost, 0) * nvl(mmt.periodic_primary_quantity,0))
1918: FROM mtl_pac_actual_cost_details mpacd,
1919: mtl_material_transactions mmt

Line 3739: FROM cst_pac_period_balances cppb

3735: )
3736: IS
3737: SELECT
3738: nvl(cppb.period_balance,0)
3739: FROM cst_pac_period_balances cppb
3740: WHERE cppb.pac_period_id = c_pac_period_id
3741: AND cppb.cost_group_id = c_cost_group_id
3742: AND cppb.inventory_item_id = c_inventory_item_id
3743: AND cppb.cost_element_id = c_cost_element_id

Line 3746: FROM cst_pac_period_balances cppb1

3742: AND cppb.inventory_item_id = c_inventory_item_id
3743: AND cppb.cost_element_id = c_cost_element_id
3744: AND cppb.level_type = c_level_type
3745: AND cppb.txn_category = (Select MAX(cppb1.txn_category)
3746: FROM cst_pac_period_balances cppb1
3747: WHERE cppb.pac_period_id = cppb1.pac_period_id
3748: AND cppb.cost_group_id = cppb1.cost_group_id
3749: AND cppb.inventory_item_id = cppb1.inventory_item_id
3750: AND cppb.cost_element_id = cppb1.cost_element_id

Line 3766: FROM cst_pac_period_balances cppb

3762: )
3763: IS
3764: SELECT
3765: nvl(cppb.period_quantity,0)
3766: FROM cst_pac_period_balances cppb
3767: WHERE cppb.pac_period_id = c_pac_period_id
3768: AND cppb.cost_group_id = c_cost_group_id
3769: AND cppb.inventory_item_id = c_inventory_item_id
3770: AND cppb.txn_category = (Select MAX(cppb1.txn_category)

Line 3771: FROM cst_pac_period_balances cppb1

3767: WHERE cppb.pac_period_id = c_pac_period_id
3768: AND cppb.cost_group_id = c_cost_group_id
3769: AND cppb.inventory_item_id = c_inventory_item_id
3770: AND cppb.txn_category = (Select MAX(cppb1.txn_category)
3771: FROM cst_pac_period_balances cppb1
3772: WHERE cppb.pac_period_id = cppb1.pac_period_id
3773: AND cppb.cost_group_id = cppb1.cost_group_id
3774: AND cppb.inventory_item_id = cppb1.inventory_item_id
3775: AND txn_category < 8)

Line 5750: FROM cst_pac_period_balances cppb1

5746: SELECT NVL(cppb1.period_balance,0) - NVL(cppb2.period_balance,0) pcu_value_balance
5747: ,cppb1.cost_group_id cost_group_id
5748: ,cppb1.cost_element_id cost_element_id
5749: ,cppb1.level_type level_type
5750: FROM cst_pac_period_balances cppb1
5751: ,cst_pac_period_balances cppb2
5752: where cppb1.pac_period_id = cppb2.pac_period_id
5753: and cppb1.cost_group_id = cppb2.cost_group_id
5754: and cppb1.inventory_item_id = cppb2.inventory_item_id

Line 5751: ,cst_pac_period_balances cppb2

5747: ,cppb1.cost_group_id cost_group_id
5748: ,cppb1.cost_element_id cost_element_id
5749: ,cppb1.level_type level_type
5750: FROM cst_pac_period_balances cppb1
5751: ,cst_pac_period_balances cppb2
5752: where cppb1.pac_period_id = cppb2.pac_period_id
5753: and cppb1.cost_group_id = cppb2.cost_group_id
5754: and cppb1.inventory_item_id = cppb2.inventory_item_id
5755: and cppb1.cost_element_id = cppb2.cost_element_id

Line 5775: FROM CST_PAC_PERIOD_BALANCES

5771: ,c_inventory_item_id NUMBER
5772: )
5773: IS
5774: SELECT count(*)
5775: FROM CST_PAC_PERIOD_BALANCES
5776: WHERE pac_period_id = c_pac_period_id
5777: AND cost_group_id = c_cost_group_id
5778: AND inventory_item_id = c_inventory_item_id
5779: AND txn_category = 8.5;