DBA Data[Home] [Help]

APPS.ASO_BI_QUOTE_FACT_PVT dependencies on ASO_BI_QUOTE_HDRS_ALL

Line 268: -- Initial Load of ASO_BI_QUOTE_HDRS_ALL

264: ASO_BI_UTIL_PVT.Analyze_Table('ASO_BI_QUOTE_HDRS_STG');
265:
266: End Populate_Qot_Fact_Stg;
267:
268: -- Initial Load of ASO_BI_QUOTE_HDRS_ALL
269: Procedure InitiLoad_QotHdr
270: As
271: l_user_id number;
272: l_login_id number;

Line 284: INSERT/*+ APPEND PARALLEL(QOTHDR)*/ INTO ASO_BI_QUOTE_HDRS_ALL QOTHDR

280: l_user_id := FND_GLOBAL.user_id;
281: l_login_id := FND_GLOBAL.login_id;
282: l_global_prim_currency := BIS_COMMON_PARAMETERS.Get_Currency_code ;
283:
284: INSERT/*+ APPEND PARALLEL(QOTHDR)*/ INTO ASO_BI_QUOTE_HDRS_ALL QOTHDR
285: (quote_number,
286: quote_version,
287: quote_header_id,
288: quote_name,

Line 387: 'MERGE INTO ASO_BI_QUOTE_HDRS_ALL QOTHDR

383: l_user_id := FND_GLOBAL.user_id;
384: l_login_id := FND_GLOBAL.login_id;
385:
386: EXECUTE IMMEDIATE
387: 'MERGE INTO ASO_BI_QUOTE_HDRS_ALL QOTHDR
388: USING(SELECT quote_number,
389: quote_version,
390: quote_header_id,
391: quote_name,