APPS.ASO_BI_QUOTE_FACT_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 42: from aso_quote_headers_all qhd

38: first_value(qhd.total_adjusted_amount)
39: over(partition by qhd.quote_number
40: order by quote_version asc rows unbounded preceding)
41: as total_adjusted_amount_first
42: from aso_quote_headers_all qhd
43: where qhd.last_update_date
44: between p_from_date and p_to_date
45: and nvl(qhd.quote_type,'q')<>'t') qv
46: where qv.quote_version = qv.max_quote_version ;

Line 103: from aso_quote_headers_all qhd

99: first_value(qhd.total_adjusted_amount)
100: over(partition by qhd.quote_number
101: order by quote_version asc rows unbounded preceding)
102: as total_adjusted_amount_first
103: from aso_quote_headers_all qhd
104: WHERE QHD.last_update_date
105: BETWEEN p_from_date AND p_to_date
106: AND NVL(QHD.QUOTE_TYPE,'Q')<>'T') QV
107: WHERE QV.quote_version = QV.max_quote_version ;

Line 172: FROM ASO_QUOTE_HEADERS_ALL QHD,

168: THEN -1 ELSE
169: count(LIN.quote_line_id) END)
170: THEN 'Y' ELSE 'N' END FROM ASO_QUOTE_LINES_ALL LIN
171: WHERE LIN.quote_header_id = QHD.quote_header_id) recurring_charge_flag
172: FROM ASO_QUOTE_HEADERS_ALL QHD,
173: OE_ORDER_HEADERS_ALL ORD,
174: ASO_BI_QUOTE_IDS QID,
175: ASO_QUOTE_RELATED_OBJECTS QROBJ,
176: ASO_BI_CURRENCY_RATES RATE

Line 349: ASO_QUOTE_HEADERS_ALL QHD,

345: count(LIN.quote_line_id) END)
346: THEN 'Y' ELSE 'N' END FROM ASO_QUOTE_LINES_ALL LIN
347: WHERE LIN.quote_header_id = QHD.quote_header_id) recurring_charge_flag
348: FROM
349: ASO_QUOTE_HEADERS_ALL QHD,
350: OE_ORDER_HEADERS_ALL ORD,
351: ASO_BI_QUOTE_IDS QID,
352: ASO_QUOTE_RELATED_OBJECTS QROBJ,
353: ASO_BI_CURRENCY_RATES RATE