APPS.ASO_BI_LINE_FACT_PVT dependencies on ASO_BI_LINE_IDS

Line 33: -- Inserts the quote lines id into ASO_BI_LINE_IDS table

29: COMMIT;
30: END Cleanup_Line_Data;
31:
32:
33: -- Inserts the quote lines id into ASO_BI_LINE_IDS table
34: -- corresponding the quotes that got changed in the given window
35: -- of dates
36: PROCEDURE initLoad_Quote_Line_ids
37: AS

Line 41: INSERT/*+ APPEND PARALLEL(ASO_LINE_IDS)*/ INTO ASO_BI_LINE_IDS ASO_LINE_IDS

37: AS
38:
39: BEGIN
40:
41: INSERT/*+ APPEND PARALLEL(ASO_LINE_IDS)*/ INTO ASO_BI_LINE_IDS ASO_LINE_IDS
42: ( QUOTE_HEADER_ID,
43: QUOTE_NUMBER,
44: MAX_QUOTE_VERSION,
45: QUOTE_CREATION_DATE,

Line 62: 'ASO_BI_LINE_IDS.');

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 ' ||
62: 'ASO_BI_LINE_IDS.');
63: END IF;
64:
65: COMMIT;
66: ASO_BI_UTIL_PVT.Analyze_Table('ASO_BI_LINE_IDS');

Line 66: ASO_BI_UTIL_PVT.Analyze_Table('ASO_BI_LINE_IDS');

62: 'ASO_BI_LINE_IDS.');
63: END IF;
64:
65: COMMIT;
66: ASO_BI_UTIL_PVT.Analyze_Table('ASO_BI_LINE_IDS');
67:
68: END initLoad_Quote_Line_ids;
69:
70:

Line 71: -- Inserts the updated quote line ids into ASO_BI_LINE_IDS table

67:
68: END initLoad_Quote_Line_ids;
69:
70:
71: -- Inserts the updated quote line ids into ASO_BI_LINE_IDS table
72: PROCEDURE Populate_Quote_Line_ids
73: AS
74: l_batch_size Number := 1000;
75: BEGIN

Line 82: BIS_COLLECTION_UTILITIES.Debug('Started populating ASO_BI_LINE_IDS table');

78: l_batch_size:= bis_common_parameters.get_batch_size(
79: BIS_COMMON_PARAMETERS.MEDIUM);
80:
81: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN
82: BIS_COLLECTION_UTILITIES.Debug('Started populating ASO_BI_LINE_IDS table');
83: END IF;
84:
85: INSERT INTO ASO_BI_LINE_IDS
86: ( QUOTE_HEADER_ID,

Line 85: INSERT INTO ASO_BI_LINE_IDS

81: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN
82: BIS_COLLECTION_UTILITIES.Debug('Started populating ASO_BI_LINE_IDS table');
83: END IF;
84:
85: INSERT INTO ASO_BI_LINE_IDS
86: ( QUOTE_HEADER_ID,
87: QUOTE_NUMBER,
88: MAX_QUOTE_VERSION,
89: QUOTE_CREATION_DATE,

Line 123: FROM ASO_BI_LINE_IDS ;

119: worker_number,
120: status
121: )
122: SELECT DISTINCT batch_id, 0, 'UNASSIGNED'
123: FROM ASO_BI_LINE_IDS ;
124: COMMIT;
125:
126: IF (BIS_COLLECTION_UTILITIES.g_debug) THEN
127: BIS_COLLECTION_UTILITIES.Debug('Inserted '||SQL%ROWCOUNT||' jobs into '||

Line 244: aso_bi_line_ids linid,

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,
245: aso_bi_currency_rates rate,
246: hz_cust_accounts hzcst,
247: OE_ORDER_HEADERS_ALL ORD
248: WHERE qlin.quote_header_id = qhd.quote_header_id

Line 378: aso_bi_line_ids linid,

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,
379: aso_bi_currency_rates rate,
380: hz_cust_accounts hzcst,
381: OE_ORDER_HEADERS_ALL ORD
382: WHERE qlin.quote_header_id = qhd.quote_header_id