DBA Data[Home] [Help]

APPS.FII_AP_INV_SUM_INIT dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 1000: AP_System_Parameters_All ASP

996: SELECT /*+ parallel(ASP) parallel(AI) use_hash(AI) */
997: Distinct ASP.Base_Currency_code Curr_Code,
998: TRUNC(AI.Invoice_Date) Trx_Date
999: FROM AP_Invoices_All AI,
1000: AP_System_Parameters_All ASP
1001: WHERE AI.Org_ID = ASP.Org_ID
1002: AND AI.Invoice_Type_Lookup_Code <> 'EXPENSE REPORT'
1003: AND AI.Invoice_Amount <> 0
1004: AND TRUNC(AI.Creation_Date) >= g_start_date

Line 1051: AP_System_Parameters_All ASP,

1047: DECODE(AI.Exchange_Rate_Type, 'User', AI.Exchange_Rate, 1)
1048: Exchange_Rate,
1049: NVL(FC.Minimum_Accountable_Unit, 0.01) Functional_MAU
1050: FROM AP_Invoices_All AI,
1051: AP_System_Parameters_All ASP,
1052: FND_Currencies FC
1053: WHERE AI.Org_ID = ASP.Org_ID
1054: AND AI.Invoice_Type_Lookup_Code <> 'EXPENSE REPORT'
1055: AND AI.Invoice_Amount <> 0

Line 1400: FROM AP_System_Parameters_All ASP,

1396: sysdate Creation_Date,
1397: g_fii_user_id Last_Updated_By,
1398: sysdate Last_Update_Date,
1399: g_fii_login_id Last_Update_Login
1400: FROM AP_System_Parameters_All ASP,
1401: AP_Invoices_All AI,
1402: AP_Invoice_Distributions_All AID,
1403: AP_Invoice_Lines_All AIL
1404: WHERE AI.Invoice_ID = AIL.Invoice_ID (+)