APPS.IBE_WORKFLOW_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 251: FROM Aso_quote_lines_all

247: Organization_id,
248: Quantity,
249: Line_quote_price,
250: currency_code
251: FROM Aso_quote_lines_all
252: WHERE quote_header_id = p_quote_id
253: ORDER BY line_number;
254: g_quote_line_rec c_quote_detail%ROWTYPE;
255:

Line 7097: FROM Aso_quote_lines_all q,

7093: sum(t.tax_amount) tax_amount,
7094: qld.config_instance_name,
7095: tran.name action,
7096: qld.config_delta
7097: FROM Aso_quote_lines_all q,
7098: mtl_system_items_vl m,
7099: aso_tax_details t,
7100: mtl_units_of_measure u,
7101: Aso_quote_line_details qld,

Line 7152: Aso_quote_lines_all q,

7148: FROM aso_line_relationships
7149: START WITH quote_line_id = p_parent_line_id
7150: CONNECT BY quote_line_id =
7151: PRIOR related_quote_line_id ) ALR,
7152: Aso_quote_lines_all q,
7153: mtl_system_items_vl m,
7154: aso_tax_details t,
7155: mtl_units_of_measure u,
7156: Aso_quote_line_details qld,

Line 9202: from aso_quote_lines_all ql,mtl_units_of_measure_tl uom

9198: l_reccharge VARCHAR2(1);
9199:
9200: Cursor c_reccur_quote_footer(c_quote_id NUMBER) IS
9201: select uom.unit_of_measure_tl charge_periodicity_desc,nvl(sum(ql.line_quote_price*ql.quantity),'0.00') rec_subtotal
9202: from aso_quote_lines_all ql,mtl_units_of_measure_tl uom
9203: where ql.quote_header_id = c_quote_id
9204: and ql.charge_periodicity_code is not null
9205: and uom.uom_code(+) = ql.charge_periodicity_code
9206: and uom.language(+) = userenv('lang')

Line 9214: from aso_quote_lines_all ql,aso_quote_headers_all qh

9210: Cursor c_macd_quote_footer(c_quote_id NUMBER) IS
9211: 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,
9212: nvl(sum(ql.line_paynow_subtotal + ql.line_paynow_charges + ql.line_paynow_tax),'0.00')paynow_order_total,
9213: qh.total_quote_price quote_total,qh.currency_code
9214: from aso_quote_lines_all ql,aso_quote_headers_all qh
9215: where qh.quote_header_id = c_quote_id
9216: and ql.quote_header_id = qh.quote_header_id
9217: group by ql.quote_header_id,qh.total_quote_price,qh.currency_code;
9218: g_macd_quote_rec c_macd_quote_footer%ROWTYPE;