APPS.DPP_ITEMCOST_PVT dependencies on CST_ITEM_COSTS

Line 209: SELECT DISTINCT organization_id from cst_item_costs

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

Line 731: FROM cst_item_costs ctc

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

Line 806: FROM cst_item_costs cis,

802: SELECT 1
803: INTO l_incorrect_price_exists
804: FROM dual
805: WHERE EXISTS (SELECT cis.organization_id
806: FROM cst_item_costs cis,
807: org_organization_definitions ood
808: WHERE cis.organization_id = ood.organization_id
809: AND cis.organization_id = Item_rec.organization_id
810: AND ood.operating_unit = l_txn_hdr_rec.org_id