DBA Data[Home] [Help]

APPS.ASO_OPP_QTE_PUB dependencies on AS_LEAD_LINES_ALL

Line 165: -- AS_LEAD_LINES_ALL

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,

Line 174: FROM as_lead_lines_all

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: