APPS.IBE_WORKFLOW_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 261: FROM Aso_quote_lines_all

257: Organization_id,
258: Quantity,
259: Line_quote_price,
260: currency_code
261: FROM Aso_quote_lines_all
262: WHERE quote_header_id = p_quote_id
263: ORDER BY line_number;
264: g_quote_line_rec c_quote_detail%ROWTYPE;
265:

Line 7192: FROM Aso_quote_lines_all q,

7188: sum(t.tax_amount) tax_amount,
7189: qld.config_instance_name,
7190: tran.name action,
7191: qld.config_delta
7192: FROM Aso_quote_lines_all q,
7193: mtl_system_items_vl m,
7194: aso_tax_details t,
7195: mtl_units_of_measure u,
7196: Aso_quote_line_details qld,

Line 7247: Aso_quote_lines_all q,

7243: FROM aso_line_relationships
7244: START WITH quote_line_id = p_parent_line_id
7245: CONNECT BY quote_line_id =
7246: PRIOR related_quote_line_id ) ALR,
7247: Aso_quote_lines_all q,
7248: mtl_system_items_vl m,
7249: aso_tax_details t,
7250: mtl_units_of_measure u,
7251: Aso_quote_line_details qld,

Line 9297: from aso_quote_lines_all ql,mtl_units_of_measure_tl uom

9293: l_reccharge VARCHAR2(1);
9294:
9295: Cursor c_reccur_quote_footer(c_quote_id NUMBER) IS
9296: select uom.unit_of_measure_tl charge_periodicity_desc,nvl(sum(ql.line_quote_price*ql.quantity),'0.00') rec_subtotal
9297: from aso_quote_lines_all ql,mtl_units_of_measure_tl uom
9298: where ql.quote_header_id = c_quote_id
9299: and ql.charge_periodicity_code is not null
9300: and uom.uom_code(+) = ql.charge_periodicity_code
9301: and uom.language(+) = userenv('lang')

Line 9309: from aso_quote_lines_all ql,aso_quote_headers_all qh

9305: Cursor c_macd_quote_footer(c_quote_id NUMBER) IS
9306: select nvl(sum(ql.line_paynow_subtotal),'0.00')paynow_lines_total,nvl(sum(ql.line_paynow_charges),'0.00')paynow_charges_total,nvl(sum(ql.line_paynow_tax),'0.00')paynow_taxes_total,
9307: nvl(sum(ql.line_paynow_subtotal + ql.line_paynow_charges + ql.line_paynow_tax),'0.00')paynow_order_total,
9308: qh.total_quote_price quote_total,qh.currency_code
9309: from aso_quote_lines_all ql,aso_quote_headers_all qh
9310: where qh.quote_header_id = c_quote_id
9311: and ql.quote_header_id = qh.quote_header_id
9312: group by ql.quote_header_id,qh.total_quote_price,qh.currency_code;
9313: g_macd_quote_rec c_macd_quote_footer%ROWTYPE;