APPS.CSTPPINV dependencies on CST_PAC_ITEM_COSTS

Line 1728: FROM CST_PAC_ITEM_COSTS CPIC

1724: BEGIN
1725: /* Get PACP cost from CPICD */
1726: SELECT NVL(CPIC.item_cost,0)
1727: INTO l_pacp_pwac_cost
1728: FROM CST_PAC_ITEM_COSTS CPIC
1729: WHERE CPIC.INVENTORY_ITEM_ID = i_item_id
1730: AND CPIC.COST_GROUP_ID = i_cost_source_cost_group
1731: AND CPIC.PAC_PERIOD_ID = i_pac_period_id;
1732:

Line 1778: FROM CST_PAC_ITEM_COSTS CPIC,

1774: i_prog_appl_id,
1775: i_prog_id,
1776: sysdate,
1777: i_login_id
1778: FROM CST_PAC_ITEM_COSTS CPIC,
1779: CST_PAC_ITEM_COST_DETAILS CPICD
1780: WHERE CPICD.COST_LAYER_ID = CPIC.COST_LAYER_ID
1781: AND CPIC.INVENTORY_ITEM_ID = i_item_id
1782: AND CPIC.COST_GROUP_ID = i_cost_source_cost_group

Line 1884: FROM cst_pac_item_costs cpic

1880: if, for example, it was created after the close of the
1881: prior period. */
1882: SELECT count(*)
1883: INTO l_prev_period_pwac_cnt
1884: FROM cst_pac_item_costs cpic
1885: WHERE CPIC.INVENTORY_ITEM_ID = i_item_id
1886: AND CPIC.COST_GROUP_ID = i_cost_source_cost_group
1887: AND CPIC.PAC_PERIOD_ID = l_prev_period_id;
1888:

Line 1933: FROM CST_PAC_ITEM_COSTS CPIC,

1929: i_prog_appl_id,
1930: i_prog_id,
1931: sysdate,
1932: i_login_id
1933: FROM CST_PAC_ITEM_COSTS CPIC,
1934: CST_PAC_ITEM_COST_DETAILS CPICD
1935: WHERE CPICD.COST_LAYER_ID = CPIC.COST_LAYER_ID
1936: AND CPIC.INVENTORY_ITEM_ID = i_item_id
1937: AND CPIC.COST_GROUP_ID = i_cost_source_cost_group

Line 1945: FROM CST_PAC_ITEM_COSTS CPIC

1941:
1942: /* Get prior period PWAC Cost */
1943: SELECT nvl(CPIC.item_cost,0)
1944: INTO l_prev_period_pwac_cost
1945: FROM CST_PAC_ITEM_COSTS CPIC
1946: WHERE CPIC.INVENTORY_ITEM_ID = i_item_id
1947: AND CPIC.COST_GROUP_ID = i_cost_source_cost_group
1948: AND CPIC.PAC_PERIOD_ID = l_prev_period_id;
1949:

Line 2400: l_cost_layer_id CST_PAC_ITEM_COSTS.COST_LAYER_ID%TYPE;

2396: l_parent_organization_id NUMBER := -1;
2397: l_um_rate NUMBER := 1;
2398: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;
2399: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
2400: l_cost_layer_id CST_PAC_ITEM_COSTS.COST_LAYER_ID%TYPE;
2401: l_quantity_layer_id CST_PAC_QUANTITY_LAYERS.COST_LAYER_ID%TYPE;
2402: l_converted_txn_qty NUMBER;
2403: l_stmt_num NUMBER;
2404: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;