APPS.DPP_ITEMCOST_PVT dependencies on CST_ITEM_COSTS

Line 210: SELECT DISTINCT organization_id from cst_item_costs

206: AND NVL(cod.disable_date,p_trunc_sysdate + 1) > p_trunc_sysdate;
207:
208: CURSOR Organization_cur(p_cost_type_id IN NUMBER,p_request_id IN NUMBER)
209: IS
210: SELECT DISTINCT organization_id from cst_item_costs
211: WHERE cost_type_id = p_cost_type_id
212: AND request_id = p_request_id;
213:
214: BEGIN

Line 727: FROM cst_item_costs ctc

723: IF Item_rec.primary_cost_method = 1 THEN
724: BEGIN
725: SELECT NVL(ctc.item_cost,0) prior_cost
726: INTO l_prior_cost
727: FROM cst_item_costs ctc
728: WHERE ctc.organization_id = Item_rec.organization_id
729: AND ctc.inventory_item_id = l_item_cost_tbl(i).inventory_item_id
730: AND ctc.cost_type_id = 1;
731: EXCEPTION

Line 802: FROM cst_item_costs cis,

798: SELECT 1
799: INTO l_incorrect_price_exists
800: FROM dual
801: WHERE EXISTS (SELECT cis.organization_id
802: FROM cst_item_costs cis,
803: org_organization_definitions ood
804: WHERE cis.organization_id = ood.organization_id
805: AND cis.organization_id = Item_rec.organization_id
806: AND ood.operating_unit = l_txn_hdr_rec.org_id