DBA Data[Home] [Help]

APPS.ASO_BI_LINE_FACT_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 56: FROM ASO_QUOTE_LINES_ALL qlin,

52: qid.max_quote_version,
53: qid.quote_creation_date,
54: qlin.quote_line_id,
55: NULL
56: FROM ASO_QUOTE_LINES_ALL qlin,
57: ASO_BI_QUOTE_IDS qid
58: WHERE qid.quote_header_id = qlin.quote_header_id;
59:
60: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN

Line 99: FROM ASO_QUOTE_LINES_ALL qlin,

95: qid.max_quote_version,
96: qid.quote_creation_date,
97: qlin.quote_line_id,
98: CEIL(ROWNUM/l_batch_size)
99: FROM ASO_QUOTE_LINES_ALL qlin,
100: ASO_BI_QUOTE_IDS qid
101: WHERE qid.quote_header_id = qlin.quote_header_id;
102:
103: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN

Line 240: FROM aso_quote_lines_all qlin,

236: qhd.marketing_source_code_id,
237: TRUNC(ord.creation_date),
238: qdtl.config_item_id,
239: qlin.Charge_periodicity_code
240: FROM aso_quote_lines_all qlin,
241: aso_quote_headers_all qhd,
242: aso_shipments qshp,
243: aso_quote_line_details qdtl,
244: aso_bi_line_ids linid,

Line 374: FROM aso_quote_lines_all qlin,

370: qhd.marketing_source_code_id,
371: TRUNC(ord.creation_date),
372: qdtl.config_item_id,
373: qlin.Charge_periodicity_code
374: FROM aso_quote_lines_all qlin,
375: aso_quote_headers_all qhd,
376: aso_shipments qshp,
377: aso_quote_line_details qdtl,
378: aso_bi_line_ids linid,