APPS.CSTPPINV dependencies on CST_PAC_ITEM_COSTS

Line 1770: FROM CST_PAC_ITEM_COSTS CPIC

1766: BEGIN
1767: /* Get PACP cost from CPICD */
1768: SELECT NVL(CPIC.item_cost,0)
1769: INTO l_pacp_pwac_cost
1770: FROM CST_PAC_ITEM_COSTS CPIC
1771: WHERE CPIC.INVENTORY_ITEM_ID = i_item_id
1772: AND CPIC.COST_GROUP_ID = i_cost_source_cost_group
1773: AND CPIC.PAC_PERIOD_ID = i_pac_period_id;
1774:

Line 1820: FROM CST_PAC_ITEM_COSTS CPIC,

1816: i_prog_appl_id,
1817: i_prog_id,
1818: sysdate,
1819: i_login_id
1820: FROM CST_PAC_ITEM_COSTS CPIC,
1821: CST_PAC_ITEM_COST_DETAILS CPICD
1822: WHERE CPICD.COST_LAYER_ID = CPIC.COST_LAYER_ID
1823: AND CPIC.INVENTORY_ITEM_ID = i_item_id
1824: AND CPIC.COST_GROUP_ID = i_cost_source_cost_group

Line 1926: FROM cst_pac_item_costs cpic

1922: if, for example, it was created after the close of the
1923: prior period. */
1924: SELECT count(*)
1925: INTO l_prev_period_pwac_cnt
1926: FROM cst_pac_item_costs cpic
1927: WHERE CPIC.INVENTORY_ITEM_ID = i_item_id
1928: AND CPIC.COST_GROUP_ID = i_cost_source_cost_group
1929: AND CPIC.PAC_PERIOD_ID = l_prev_period_id;
1930:

Line 1975: FROM CST_PAC_ITEM_COSTS CPIC,

1971: i_prog_appl_id,
1972: i_prog_id,
1973: sysdate,
1974: i_login_id
1975: FROM CST_PAC_ITEM_COSTS CPIC,
1976: CST_PAC_ITEM_COST_DETAILS CPICD
1977: WHERE CPICD.COST_LAYER_ID = CPIC.COST_LAYER_ID
1978: AND CPIC.INVENTORY_ITEM_ID = i_item_id
1979: AND CPIC.COST_GROUP_ID = i_cost_source_cost_group

Line 1987: FROM CST_PAC_ITEM_COSTS CPIC

1983:
1984: /* Get prior period PWAC Cost */
1985: SELECT nvl(CPIC.item_cost,0)
1986: INTO l_prev_period_pwac_cost
1987: FROM CST_PAC_ITEM_COSTS CPIC
1988: WHERE CPIC.INVENTORY_ITEM_ID = i_item_id
1989: AND CPIC.COST_GROUP_ID = i_cost_source_cost_group
1990: AND CPIC.PAC_PERIOD_ID = l_prev_period_id;
1991:

Line 2442: l_cost_layer_id CST_PAC_ITEM_COSTS.COST_LAYER_ID%TYPE;

2438: l_parent_organization_id NUMBER := -1;
2439: l_um_rate NUMBER := 1;
2440: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;
2441: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
2442: l_cost_layer_id CST_PAC_ITEM_COSTS.COST_LAYER_ID%TYPE;
2443: l_quantity_layer_id CST_PAC_QUANTITY_LAYERS.COST_LAYER_ID%TYPE;
2444: l_converted_txn_qty NUMBER;
2445: l_stmt_num NUMBER;
2446: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;