[Home] [Help]
1888: /*
1889: * Fix for bug 5997016:
1890: *
1891: * The payee address cannot be always assumed to be stored in
1892: * HZ_LOCATIONS table (TCA).
1893: *
1894: * For employee type payees, the address is stored in
1895: * per_addresses (HR).
1896: *
1895: * per_addresses (HR).
1896: *
1897: * The 'address source' column on the document payable identifies
1898: * the source of the address information -
1899: * TCA = address is stored in HZ_LOCATIONS
1900: * HR = address is stored in PER_ADDRESSES
1901: *
1902: * Therefore, we need to dynamically pick up the payee address
1903: * fields from the correct table. The SELECT statement below is
2432: PER_ADDRESSES per_addr,
2433: PER_ALL_ASSIGNMENTS_F per_assgn,
2434:
2435: /* Supplier address related */
2436: HZ_LOCATIONS payee_loc
2437: WHERE
2438: doc.document_payable_id = p_doc_id
2439: AND doc.employee_person_id = per_addr.person_id(+)
2440: AND per_addr.primary_flag(+) = 'Y'
2585: * simple and quick that targets the basic errors on the
2586: * document.
2587: *
2588: * We will continue to pick up the payee address from
2589: * HZ_LOCATIONS. In the case of employee type payees
2590: * the payee address fields will be null. This is
2591: * fine. The offline validation will catch these
2592: * errors anyway.
2593: */
2609: FROM
2610: IBY_DOCS_PAYABLE_GT docs,
2611: IBY_PP_FIRST_PARTY_V payer,
2612: HZ_PARTIES payee,
2613: HZ_LOCATIONS payee_loc,
2614: CE_BANK_ACCOUNTS iba,
2615: CE_BANK_BRANCHES_V iba_bnk_branch,
2616: IBY_EXT_BANK_ACCOUNTS_INT_V eba,
2617: CE_BANK_BRANCHES_V eba_bank_branch
2974: CE_BANK_ACCOUNTS iba,
2975: CE_BANK_BRANCHES_V iba_bnk_branch,
2976: /* Payee */
2977: HZ_PARTIES payee,
2978: HZ_LOCATIONS payee_loc,
2979: /* Payee bank */
2980: IBY_EXT_BANK_ACCOUNTS_V eba
2981: WHERE
2982: /* document related */