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_VALIDATIONSETS_PUB dependencies on HZ_LOCATIONS

Line 100: payee_party_addr1 HZ_LOCATIONS.address1%TYPE,

96: CE_BANK_ACCOUNTS_V.bank_account_name_alt%TYPE,
97: ext_eft_swift_code IBY_EXT_BANK_ACCOUNTS_INT_V.eft_swift_code%TYPE, -- Payee BIC (added by sodash)
98:
99: payee_party_name HZ_PARTIES.party_name%TYPE,
100: payee_party_addr1 HZ_LOCATIONS.address1%TYPE,
101: payee_party_addr2 HZ_LOCATIONS.address2%TYPE,
102: payee_party_addr3 HZ_LOCATIONS.address3%TYPE,
103: payee_party_city HZ_LOCATIONS.city%TYPE,
104:

Line 101: payee_party_addr2 HZ_LOCATIONS.address2%TYPE,

97: ext_eft_swift_code IBY_EXT_BANK_ACCOUNTS_INT_V.eft_swift_code%TYPE, -- Payee BIC (added by sodash)
98:
99: payee_party_name HZ_PARTIES.party_name%TYPE,
100: payee_party_addr1 HZ_LOCATIONS.address1%TYPE,
101: payee_party_addr2 HZ_LOCATIONS.address2%TYPE,
102: payee_party_addr3 HZ_LOCATIONS.address3%TYPE,
103: payee_party_city HZ_LOCATIONS.city%TYPE,
104:
105: /*

Line 102: payee_party_addr3 HZ_LOCATIONS.address3%TYPE,

98:
99: payee_party_name HZ_PARTIES.party_name%TYPE,
100: payee_party_addr1 HZ_LOCATIONS.address1%TYPE,
101: payee_party_addr2 HZ_LOCATIONS.address2%TYPE,
102: payee_party_addr3 HZ_LOCATIONS.address3%TYPE,
103: payee_party_city HZ_LOCATIONS.city%TYPE,
104:
105: /*
106: * Fix for bug 6713003:

Line 103: payee_party_city HZ_LOCATIONS.city%TYPE,

99: payee_party_name HZ_PARTIES.party_name%TYPE,
100: payee_party_addr1 HZ_LOCATIONS.address1%TYPE,
101: payee_party_addr2 HZ_LOCATIONS.address2%TYPE,
102: payee_party_addr3 HZ_LOCATIONS.address3%TYPE,
103: payee_party_city HZ_LOCATIONS.city%TYPE,
104:
105: /*
106: * Fix for bug 6713003:
107: *

Line 110: * and HZ_LOCATIONS. Therefore, the field sizes

106: * Fix for bug 6713003:
107: *
108: * The payee address fields are picked up from three
109: * possible sources: HR_LOCATIONS, PER_ADDRESSES
110: * and HZ_LOCATIONS. Therefore, the field sizes
111: * should be the maximum of the corresponding column
112: * sizes from these three tables.
113: *
114: * Usually, HZ_LOCATIONS field sizes are sufficient.

Line 114: * Usually, HZ_LOCATIONS field sizes are sufficient.

110: * and HZ_LOCATIONS. Therefore, the field sizes
111: * should be the maximum of the corresponding column
112: * sizes from these three tables.
113: *
114: * Usually, HZ_LOCATIONS field sizes are sufficient.
115: * But for state, county and provice fields, HR_LOCATIONS /
116: * PER_ADDRESSES has larger field sizes.
117: *
118: * Therefore, for these three fields, we use HR_LOCATIONS

Line 125: payee_party_postal HZ_LOCATIONS.postal_code%TYPE,

121: payee_party_state HR_LOCATIONS.region_2%TYPE,
122: payee_party_province HR_LOCATIONS.region_1%TYPE,
123: payee_party_county HR_LOCATIONS.region_1%TYPE,
124:
125: payee_party_postal HZ_LOCATIONS.postal_code%TYPE,
126: payee_party_country HZ_LOCATIONS.country%TYPE,
127:
128: bank_charge_bearer IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
129: payment_reason_code IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,

Line 126: payee_party_country HZ_LOCATIONS.country%TYPE,

122: payee_party_province HR_LOCATIONS.region_1%TYPE,
123: payee_party_county HR_LOCATIONS.region_1%TYPE,
124:
125: payee_party_postal HZ_LOCATIONS.postal_code%TYPE,
126: payee_party_country HZ_LOCATIONS.country%TYPE,
127:
128: bank_charge_bearer IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
129: payment_reason_code IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
130: payment_method_cd IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

Line 514: HZ_LOCATIONS.address1%TYPE,

510: HZ_PARTIES.party_name%TYPE,
511: payee_tax_id
512: HZ_PARTIES.tax_reference%TYPE,
513: payee_add1
514: HZ_LOCATIONS.address1%TYPE,
515: payee_add2
516: HZ_LOCATIONS.address2%TYPE,
517: payee_add3
518: HZ_LOCATIONS.address3%TYPE,

Line 516: HZ_LOCATIONS.address2%TYPE,

512: HZ_PARTIES.tax_reference%TYPE,
513: payee_add1
514: HZ_LOCATIONS.address1%TYPE,
515: payee_add2
516: HZ_LOCATIONS.address2%TYPE,
517: payee_add3
518: HZ_LOCATIONS.address3%TYPE,
519: payee_city
520: HZ_LOCATIONS.city%TYPE,

Line 518: HZ_LOCATIONS.address3%TYPE,

514: HZ_LOCATIONS.address1%TYPE,
515: payee_add2
516: HZ_LOCATIONS.address2%TYPE,
517: payee_add3
518: HZ_LOCATIONS.address3%TYPE,
519: payee_city
520: HZ_LOCATIONS.city%TYPE,
521: payee_county
522: HZ_LOCATIONS.county%TYPE,

Line 520: HZ_LOCATIONS.city%TYPE,

516: HZ_LOCATIONS.address2%TYPE,
517: payee_add3
518: HZ_LOCATIONS.address3%TYPE,
519: payee_city
520: HZ_LOCATIONS.city%TYPE,
521: payee_county
522: HZ_LOCATIONS.county%TYPE,
523: payee_province
524: HZ_LOCATIONS.province%TYPE,

Line 522: HZ_LOCATIONS.county%TYPE,

518: HZ_LOCATIONS.address3%TYPE,
519: payee_city
520: HZ_LOCATIONS.city%TYPE,
521: payee_county
522: HZ_LOCATIONS.county%TYPE,
523: payee_province
524: HZ_LOCATIONS.province%TYPE,
525: payee_state
526: HZ_LOCATIONS.state%TYPE,

Line 524: HZ_LOCATIONS.province%TYPE,

520: HZ_LOCATIONS.city%TYPE,
521: payee_county
522: HZ_LOCATIONS.county%TYPE,
523: payee_province
524: HZ_LOCATIONS.province%TYPE,
525: payee_state
526: HZ_LOCATIONS.state%TYPE,
527: payee_country
528: HZ_LOCATIONS.country%TYPE,

Line 526: HZ_LOCATIONS.state%TYPE,

522: HZ_LOCATIONS.county%TYPE,
523: payee_province
524: HZ_LOCATIONS.province%TYPE,
525: payee_state
526: HZ_LOCATIONS.state%TYPE,
527: payee_country
528: HZ_LOCATIONS.country%TYPE,
529: payee_postcode
530: HZ_LOCATIONS.postal_code%TYPE,

Line 528: HZ_LOCATIONS.country%TYPE,

524: HZ_LOCATIONS.province%TYPE,
525: payee_state
526: HZ_LOCATIONS.state%TYPE,
527: payee_country
528: HZ_LOCATIONS.country%TYPE,
529: payee_postcode
530: HZ_LOCATIONS.postal_code%TYPE,
531:
532: /* PAYEE BANK */

Line 530: HZ_LOCATIONS.postal_code%TYPE,

526: HZ_LOCATIONS.state%TYPE,
527: payee_country
528: HZ_LOCATIONS.country%TYPE,
529: payee_postcode
530: HZ_LOCATIONS.postal_code%TYPE,
531:
532: /* PAYEE BANK */
533: payee_bank_name
534: IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,