APPS.ASO_BI_LINE_FACT_PVT dependencies on ASO_BI_QUOTE_IDS

Line 21: FROM ASO_BI_QUOTE_IDS

17:
18: DELETE FROM ASO_BI_QUOTE_LINES_ALL qlin
19: WHERE qlin.quote_number IN (
20: SELECT quote_number
21: FROM ASO_BI_QUOTE_IDS
22: );
23:
24: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN
25: BIS_COLLECTION_UTILITIES.Debug('Deleted the updated rows from '||

Line 57: ASO_BI_QUOTE_IDS qid

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
61: BIS_COLLECTION_UTILITIES.Debug('Inserted '||SQL%ROWCOUNT||' rows in ' ||

Line 100: ASO_BI_QUOTE_IDS qid

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
104: BIS_COLLECTION_UTILITIES.Debug('Inserted '||SQL%ROWCOUNT||' rows in ' ||

Line 105: 'ASO_BI_QUOTE_IDS.');

101: WHERE qid.quote_header_id = qlin.quote_header_id;
102:
103: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN
104: BIS_COLLECTION_UTILITIES.Debug('Inserted '||SQL%ROWCOUNT||' rows in ' ||
105: 'ASO_BI_QUOTE_IDS.');
106: END IF;
107:
108: COMMIT;
109: END Populate_Quote_Line_ids;