DBA Data[Home] [Help]

APPS.DPP_ITEMCOST_PVT dependencies on CST_QUANTITY_LAYERS

Line 739: FROM cst_quantity_layers

735: ELSE
736: BEGIN
737: SELECT NVL(item_cost,0)
738: INTO l_prior_cost
739: FROM cst_quantity_layers
740: WHERE organization_id = Item_rec.organization_id
741: AND inventory_item_id = l_item_cost_tbl(i).inventory_item_id
742: AND cost_group_id = item_rec.cost_group_id;
743: EXCEPTION

Line 824: FROM cst_quantity_layers cql,

820: SELECT 1
821: INTO l_incorrect_price_exists
822: FROM dual
823: WHERE EXISTS (SELECT cql.organization_id
824: FROM cst_quantity_layers cql,
825: org_organization_definitions ood
826: WHERE cql.organization_id = ood.organization_id
827:
828: AND cql.organization_id = Item_rec.organization_id