DBA Data[Home] [Help]

APPS.FII_AP_INV_SUM_INC dependencies on IBY_SYS_PMT_PROFILES_B

Line 1497: IBY_SYS_PMT_PROFILES_B IBY_SYS_PROF_B, --IBY CHANGE

1493: BULK COLLECT INTO FII_AP_Inv_Pay_MS
1494: FROM FII_AP_Invoice_IDS ID,
1495: AP_Invoice_Payments_ALL AIP,
1496: AP_Checks_ALL AC,
1497: IBY_SYS_PMT_PROFILES_B IBY_SYS_PROF_B, --IBY CHANGE
1498: IBY_ACCT_PMT_PROFILES_B IBY_ACCT_PROF_B--IBY CHANGE
1499: WHERE ID.Invoice_ID = AIP.Invoice_ID
1500: AND AIP.Check_ID = AC.Check_ID
1501: AND AC.Payment_Profile_ID = IBY_ACCT_PROF_B.Payment_Profile_ID(+)--IBY CHANGE

Line 1586: IBY_SYS_PMT_PROFILES_B IBY_SYS_PROF_B,--IBY CHANGE

1582: AP_Invoice_Payments_All AIP
1583: WHERE TEMP1.Prepay_Invoice_ID = AIP.Invoice_ID
1584: GROUP BY TEMP1.Invoice_ID, TEMP1.Creation_Date, TEMP1.Prepay_Invoice_ID, TEMP1.Amount) TEMP2,
1585: AP_Checks_All AC,
1586: IBY_SYS_PMT_PROFILES_B IBY_SYS_PROF_B,--IBY CHANGE
1587: IBY_ACCT_PMT_PROFILES_B IBY_ACCT_PROF_B--IBY CHANGE
1588: WHERE TEMP2.Check_ID = AC.Check_ID
1589: AND AC.Payment_Profile_ID = IBY_ACCT_PROF_B.Payment_Profile_ID(+)--IBY CHANGE
1590: AND IBY_ACCT_PROF_B.system_profile_code= IBY_SYS_PROF_B.system_profile_code(+)--IBY CHANGE