eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_DISBURSEMENT_COMP_PUB dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 22: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,

18: APL_TYPE_PMT_CURRENCY CONSTANT VARCHAR2(100) := 'CURRENCY_CODE';
19: APL_TYPE_INT_BANK_ACCT CONSTANT VARCHAR2(100) := 'INTERNAL_BANK_ACCOUNT';
20:
21: TYPE t_payee_bankacct_rec_type IS RECORD(
22: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
23: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
24: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
25: Payee_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
26: Payee_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,

Line 23: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,

19: APL_TYPE_INT_BANK_ACCT CONSTANT VARCHAR2(100) := 'INTERNAL_BANK_ACCOUNT';
20:
21: TYPE t_payee_bankacct_rec_type IS RECORD(
22: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
23: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
24: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
25: Payee_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
26: Payee_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
27: Payment_Currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

Line 24: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,

20:
21: TYPE t_payee_bankacct_rec_type IS RECORD(
22: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
23: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
24: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
25: Payee_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
26: Payee_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
27: Payment_Currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
28: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,

Line 25: Payee_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,

21: TYPE t_payee_bankacct_rec_type IS RECORD(
22: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
23: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
24: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
25: Payee_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
26: Payee_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
27: Payment_Currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
28: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
29: Payee_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,

Line 26: Payee_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,

22: Payee_Party_Id IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
23: Payee_Party_Site_Id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
24: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
25: Payee_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
26: Payee_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
27: Payment_Currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
28: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
29: Payee_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
30: Payee_BankAccount_Id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE,

Line 28: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,

24: Supplier_Site_Id IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
25: Payee_Org_Id IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
26: Payee_Org_Type IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
27: Payment_Currency IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
28: Payment_Function IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
29: Payee_BankAccount_Name IBY_EXT_BANK_ACCOUNTS_V.bank_account_name%TYPE,
30: Payee_BankAccount_Id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE,
31: Payee_BankAccount_Num IBY_EXT_BANK_ACCOUNTS_V.bank_account_number%TYPE,
32: Currency_Code IBY_EXT_BANK_ACCOUNTS_V.CURRENCY_CODE%TYPE,

Line 287: IBY_EXTERNAL_PAYEES_ALL ibypayee

283: b.payment_factor_flag,
284: b.eft_swift_code
285: FROM IBY_PMT_INSTR_USES_ALL ibyu,
286: IBY_EXT_BANK_ACCOUNTS_V b,
287: IBY_EXTERNAL_PAYEES_ALL ibypayee
288: WHERE ibyu.instrument_id = b.ext_bank_account_id
289: AND ibyu.instrument_type = 'BANKACCOUNT'
290: AND (b.currency_code = p_payment_currency OR b.currency_code is null)
291: AND ibyu.ext_pmt_party_id = ibypayee.ext_payee_id

Line 640: IBY_EXTERNAL_PAYEES_ALL payee

636: AND (am.INACTIVE_DATE is null OR am.INACTIVE_DATE >= trunc(sysdate))
637: AND am.PAYMENT_METHOD_CODE = m.PAYMENT_METHOD_CODE
638: AND NOT EXISTS (select 1
639: from IBY_EXT_PARTY_PMT_MTHDS ppm,
640: IBY_EXTERNAL_PAYEES_ALL payee
641: where ppm.PAYMENT_FLOW = 'DISBURSEMENTS'
642: and ppm.PAYMENT_METHOD_CODE = am.PAYMENT_METHOD_CODE
643: and ppm.PAYMENT_FUNCTION = p_payment_function
644: and ppm.INACTIVE_DATE < trunc(sysdate)

Line 658: IBY_EXTERNAL_PAYEES_ALL payee,

654: m.SUPPORT_BILLS_PAYABLE_FLAG,
655: m.MATURITY_DATE_OFFSET_DAYS,
656: m.DESCRIPTION
657: FROM IBY_EXT_PARTY_PMT_MTHDS ppm,
658: IBY_EXTERNAL_PAYEES_ALL payee,
659: IBY_PAYMENT_METHODS_VL m
660: WHERE ppm.PAYMENT_FLOW = 'DISBURSEMENTS'
661: AND ppm.PAYMENT_FUNCTION = p_payment_function
662: AND (m.INACTIVE_DATE is null OR m.INACTIVE_DATE >= trunc(sysdate))

Line 681: IBY_EXTERNAL_PAYEES_ALL payee

677: FROM IBY_PAYMENT_METHODS_VL pmthds
678: WHERE (pmthds.inactive_date is NULL OR pmthds.inactive_date >= trunc(sysdate))
679: AND NOT EXISTS (select 1
680: from IBY_EXT_PARTY_PMT_MTHDS ppm,
681: IBY_EXTERNAL_PAYEES_ALL payee
682: where ppm.PAYMENT_FLOW = 'DISBURSEMENTS'
683: and PAYMENT_METHOD_CODE = pmthds.PAYMENT_METHOD_CODE
684: and ppm.PAYMENT_FUNCTION = p_payment_function
685: and ppm.INACTIVE_DATE < trunc(sysdate)

Line 1881: l_payee1 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

1877:
1878: l_pay_alone VARCHAR2(1);
1879: l_payment_reason_comments VARCHAR2(240);
1880:
1881: l_payee1 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1882: l_payee2 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1883: l_payee3 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1884: l_payee4 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1885:

Line 1882: l_payee2 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

1878: l_pay_alone VARCHAR2(1);
1879: l_payment_reason_comments VARCHAR2(240);
1880:
1881: l_payee1 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1882: l_payee2 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1883: l_payee3 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1884: l_payee4 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1885:
1886: l_key VARCHAR2(2000);

Line 1883: l_payee3 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

1879: l_payment_reason_comments VARCHAR2(240);
1880:
1881: l_payee1 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1882: l_payee2 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1883: l_payee3 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1884: l_payee4 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1885:
1886: l_key VARCHAR2(2000);
1887:

Line 1884: l_payee4 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

1880:
1881: l_payee1 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1882: l_payee2 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1883: l_payee3 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1884: l_payee4 IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
1885:
1886: l_key VARCHAR2(2000);
1887:
1888:

Line 1939: FROM IBY_EXTERNAL_PAYEES_ALL payee,

1935: payee.exclusive_payment_flag,
1936: payee.settlement_priority,
1937: d.territory_code delivery_channel_country,
1938: r.territory_code payment_reason_country
1939: FROM IBY_EXTERNAL_PAYEES_ALL payee,
1940: IBY_EXT_PARTY_PMT_MTHDS pm,
1941: IBY_PAYMENT_METHODS_VL m,
1942: IBY_FORMATS_VL f,
1943: IBY_DELIVERY_CHANNELS_VL d,

Line 2019: IBY_EXTERNAL_PAYEES_ALL payee,

2015: payee.settlement_priority,
2016: d.territory_code delivery_channel_country,
2017: r.territory_code payment_reason_country
2018: FROM
2019: IBY_EXTERNAL_PAYEES_ALL payee,
2020: IBY_FORMATS_VL f,
2021: IBY_DELIVERY_CHANNELS_VL d,
2022: IBY_PAYMENT_REASONS_VL r
2023: WHERE

Line 2068: IBY_EXTERNAL_PAYEES_ALL payee,

2064: m.payment_method_name,
2065: m.support_bills_payable_flag,
2066: m.maturity_date_offset_days
2067: FROM
2068: IBY_EXTERNAL_PAYEES_ALL payee,
2069: IBY_EXT_PARTY_PMT_MTHDS pm,
2070: IBY_PAYMENT_METHODS_VL m
2071: WHERE
2072: payee.ext_payee_id IN (

Line 2141: IBY_EXTERNAL_PAYEES_ALL ibypayee

2137: b.payment_factor_flag,
2138: b.eft_swift_code
2139: FROM IBY_PMT_INSTR_USES_ALL ibyu,
2140: IBY_EXT_BANK_ACCOUNTS_V b,
2141: IBY_EXTERNAL_PAYEES_ALL ibypayee
2142: WHERE ibyu.instrument_id = b.ext_bank_account_id
2143: AND ibyu.instrument_type = 'BANKACCOUNT'
2144: AND (b.currency_code = p_payment_currency
2145: OR b.currency_code is null)

Line 2665: IBY_EXTERNAL_PAYEES_ALL ibypayee

2661: b.payment_factor_flag,
2662: b.eft_swift_code
2663: FROM IBY_PMT_INSTR_USES_ALL ibyu,
2664: IBY_EXT_BANK_ACCOUNTS_V b,
2665: IBY_EXTERNAL_PAYEES_ALL ibypayee
2666: WHERE ibyu.instrument_id = b.ext_bank_account_id
2667: AND ibyu.instrument_type = 'BANKACCOUNT'
2668: AND (b.currency_code = p_payment_currency
2669: OR b.currency_code is null)

Line 3572: IBY_EXTERNAL_PAYEES_ALL ibypayee

3568: b.payment_factor_flag,
3569: b.eft_swift_code
3570: FROM IBY_PMT_INSTR_USES_ALL ibyu,
3571: IBY_EXT_BANK_ACCOUNTS_V b,
3572: IBY_EXTERNAL_PAYEES_ALL ibypayee
3573: WHERE ibyu.instrument_id = b.ext_bank_account_id
3574: AND ibyu.instrument_type = 'BANKACCOUNT'
3575: AND (b.currency_code = p_payment_currency OR b.currency_code is null)
3576: AND ibyu.ext_pmt_party_id = ibypayee.ext_payee_id