161: WHERE lead_id = p_lead_id;
162:
163: l_lead_rec c_lead%ROWTYPE;
164:
165: -- AS_LEAD_LINES_ALL
166: CURSOR C_lead_line (p_lead_id NUMBER) IS
167: SELECT lead_line_id,
168: inventory_item_id,
169: organization_id,
170: uom_code,
171: NVL(quantity, 1) quantity,
172: offer_id,
173: forecast_date
174: FROM as_lead_lines_all
175: WHERE lead_id = p_lead_id
176: AND inventory_item_id IS NOT NULL
177: AND organization_id IS NOT NULL;
178: