[Home] [Help]
11638: * Beneficiary name should be the same as the payee party name
11639: * except when beneficiary party is not null.
11640: *
11641: * If beneficiary party is not null, the beneficiary name
11642: * should be the hz_parties.party_name corresponding to the
11643: * beneficiary_party.
11644: */
11645: DECODE (pmt.beneficiary_party,
11646: NULL,
11647: payee.party_name,
11648: (SELECT
11649: benef_party.party_name
11650: FROM
11651: HZ_PARTIES benef_party
11652: WHERE
11653: benef_party.party_id=pmt.beneficiary_party
11654: )
11655: ), -- beneficiary name
11700: * For this reason, we cannot assume that tax payer id for
11701: * all non-employees will be stored in AP_SUPPLIERS.
11702: *
11703: * However, we know that all third parties / suppliers will
11704: * have a row in HZ_PARTIES. Therefore, pick up the taxpayer
11705: * id from HZ_PARTIES as this always works.
11706: */
11707: /*
11708: * Fix for bug 5501968:
11701: * all non-employees will be stored in AP_SUPPLIERS.
11702: *
11703: * However, we know that all third parties / suppliers will
11704: * have a row in HZ_PARTIES. Therefore, pick up the taxpayer
11705: * id from HZ_PARTIES as this always works.
11706: */
11707: /*
11708: * Fix for bug 5501968:
11709: *
11816: invpayee.party_name,
11817: (SELECT
11818: benef_party.party_name
11819: FROM
11820: HZ_PARTIES benef_party
11821: WHERE
11822: benef_party.party_id=pmt.inv_beneficiary_party
11823: )
11824: ) inv_beneficiary_name,
11851: IBY_PAYMENT_PROFILES prof,
11852:
11853: /* Payer */
11854: XLE_FIRSTPARTY_INFORMATION_V payer,
11855: HZ_PARTIES payer_party,
11856:
11857: /* Payer bank */
11858: CE_BANK_ACCOUNTS iba,
11859: CE_BANK_BRANCHES_V iba_bnk_branch,
11859: CE_BANK_BRANCHES_V iba_bnk_branch,
11860: HZ_PARTY_SITES iba_branch_party_site,
11861:
11862: /* Payee */
11863: HZ_PARTIES payee,
11864: HZ_PARTIES invpayee,
11865:
11866: /* Vendor related */
11867: AP_SUPPLIERS vendor,
11860: HZ_PARTY_SITES iba_branch_party_site,
11861:
11862: /* Payee */
11863: HZ_PARTIES payee,
11864: HZ_PARTIES invpayee,
11865:
11866: /* Vendor related */
11867: AP_SUPPLIERS vendor,
11868: AP_SUPPLIER_SITES_ALL vendor_site,
12682: /* Org related */
12683: AND pmt.org_id = org.organization_id
12684:
12685: /* RFC related */
12686: AND rfc_ca.owner_table_name(+) = 'HZ_PARTIES'
12687: AND rfc_ca.class_category(+) = 'RFC_IDENTIFIER'
12688: AND rfc_ca.owner_table_id(+) = iba.bank_branch_id
12689: ;
12690:
12782: * Beneficiary name should be the same as the payee party name
12783: * except when beneficiary party is not null.
12784: *
12785: * If beneficiary party is not null, the beneficiary name
12786: * should be the hz_parties.party_name corresponding to the
12787: * beneficiary_party.
12788: */
12789: DECODE (pmt.beneficiary_party,
12790: NULL,
12791: payee.party_name,
12792: (SELECT
12793: benef_party.party_name
12794: FROM
12795: HZ_PARTIES benef_party
12796: WHERE
12797: benef_party.party_id=pmt.beneficiary_party
12798: )
12799: ), -- beneficiary name
12844: * For this reason, we cannot assume that tax payer id for
12845: * all non-employees will be stored in AP_SUPPLIERS.
12846: *
12847: * However, we know that all third parties / suppliers will
12848: * have a row in HZ_PARTIES. Therefore, pick up the taxpayer
12849: * id from HZ_PARTIES as this always works.
12850: */
12851: /*
12852: * Fix for bug 5501968:
12845: * all non-employees will be stored in AP_SUPPLIERS.
12846: *
12847: * However, we know that all third parties / suppliers will
12848: * have a row in HZ_PARTIES. Therefore, pick up the taxpayer
12849: * id from HZ_PARTIES as this always works.
12850: */
12851: /*
12852: * Fix for bug 5501968:
12853: *
12960: invpayee.party_name,
12961: (SELECT
12962: benef_party.party_name
12963: FROM
12964: HZ_PARTIES benef_party
12965: WHERE
12966: benef_party.party_id=pmt.inv_beneficiary_party
12967: )
12968: ) inv_beneficiary_name,
12994: IBY_PAYMENT_PROFILES prof,
12995:
12996: /* Payer */
12997: XLE_FIRSTPARTY_INFORMATION_V payer,
12998: HZ_PARTIES payer_party,
12999:
13000: /* Payer bank */
13001: CE_BANK_ACCOUNTS iba,
13002: CE_BANK_BRANCHES_V iba_bnk_branch,
13002: CE_BANK_BRANCHES_V iba_bnk_branch,
13003: HZ_PARTY_SITES iba_branch_party_site,
13004:
13005: /* Payee */
13006: HZ_PARTIES payee,
13007: HZ_PARTIES invpayee,
13008:
13009: /* Vendor related */
13010: AP_SUPPLIERS vendor,
13003: HZ_PARTY_SITES iba_branch_party_site,
13004:
13005: /* Payee */
13006: HZ_PARTIES payee,
13007: HZ_PARTIES invpayee,
13008:
13009: /* Vendor related */
13010: AP_SUPPLIERS vendor,
13011: AP_SUPPLIER_SITES_ALL vendor_site,
13828: /* Org related */
13829: AND pmt.org_id = le.legal_entity_id
13830:
13831: /* RFC related */
13832: AND rfc_ca.owner_table_name(+) = 'HZ_PARTIES'
13833: AND rfc_ca.class_category(+) = 'RFC_IDENTIFIER'
13834: AND rfc_ca.owner_table_id(+) = iba.bank_branch_id
13835: ;
13836: