APPS.ASO_BI_APPR_FACT_PVT dependencies on ASO_BI_APR_F

Line 17: INSERT /*+ APPEND PARALLEL(FACT) */ INTO ASO_BI_APR_F FACT

13: l_user_id := FND_GLOBAL.user_id;
14: l_login_id := FND_GLOBAL.login_id;
15: --insert statement
16:
17: INSERT /*+ APPEND PARALLEL(FACT) */ INTO ASO_BI_APR_F FACT
18: (
19: QUOTE_NUMBER,
20: QUOTE_VERSION,
21: QUOTE_HEADER_ID,

Line 101: DELETE FROM ASO_BI_APR_F FACT

97: l_user_id := FND_GLOBAL.user_id;
98: l_login_id := FND_GLOBAL.login_id;
99:
100: --Delete the modified approvals
101: DELETE FROM ASO_BI_APR_F FACT
102: WHERE FACT.Quote_header_id IN (SELECT Quote_header_id FROM ASO_BI_QUOTE_IDS);
103:
104: --insert statement
105: INSERT INTO ASO_BI_APR_F

Line 105: INSERT INTO ASO_BI_APR_F

101: DELETE FROM ASO_BI_APR_F FACT
102: WHERE FACT.Quote_header_id IN (SELECT Quote_header_id FROM ASO_BI_QUOTE_IDS);
103:
104: --insert statement
105: INSERT INTO ASO_BI_APR_F
106: (
107: QUOTE_NUMBER,
108: QUOTE_VERSION,
109: QUOTE_HEADER_ID,

Line 172: --Delete the duplicate version of all quotes in ASO_BI_APR_F, retaining the latest version.

168: APR.Object_approval_id,APR.Approval_instance_id,APR.Approval_status,
169: TRUNC(APR.Start_date),APR.End_date,TRUNC(NVL(APR.end_date, QOT.Quote_expiration_date));
170:
171: -- Added to fix bug 5413781
172: --Delete the duplicate version of all quotes in ASO_BI_APR_F, retaining the latest version.
173: delete from ASO_BI_APR_F a
174: where a.quote_version < (select MAX(quote_version)
175: from ASO_BI_APR_F b
176: where a.quote_number = b.quote_number);

Line 173: delete from ASO_BI_APR_F a

169: TRUNC(APR.Start_date),APR.End_date,TRUNC(NVL(APR.end_date, QOT.Quote_expiration_date));
170:
171: -- Added to fix bug 5413781
172: --Delete the duplicate version of all quotes in ASO_BI_APR_F, retaining the latest version.
173: delete from ASO_BI_APR_F a
174: where a.quote_version < (select MAX(quote_version)
175: from ASO_BI_APR_F b
176: where a.quote_number = b.quote_number);
177:

Line 175: from ASO_BI_APR_F b

171: -- Added to fix bug 5413781
172: --Delete the duplicate version of all quotes in ASO_BI_APR_F, retaining the latest version.
173: delete from ASO_BI_APR_F a
174: where a.quote_version < (select MAX(quote_version)
175: from ASO_BI_APR_F b
176: where a.quote_number = b.quote_number);
177:
178: BIS_COLLECTION_UTILITIES.Debug('Done populating the Approvals fact Table:'||'Rowcount:'|| SQL%ROWCOUNT);
179:

Line 244: ASO_BI_APR_F APRF,

240: SYSDATE,
241: l_user_id,
242: l_login_id
243: FROM
244: ASO_BI_APR_F APRF,
245: ASO_APR_RULES RUL
246: WHERE
247: APRF.object_approval_id = RUL.object_approval_id;
248:

Line 318: ASO_BI_APR_F APRF,

314: SYSDATE,
315: l_user_id,
316: l_login_id
317: FROM
318: ASO_BI_APR_F APRF,
319: ASO_APR_RULES RUL,
320: ASO_BI_QUOTE_IDS QID
321: WHERE
322: APRF.Object_approval_id = RUL.Object_approval_id