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 107: payee_party_addr1 HZ_LOCATIONS.address1%TYPE,

103: CE_BANK_ACCOUNTS_V.bank_account_name_alt%TYPE,
104: ext_eft_swift_code IBY_EXT_BANK_ACCOUNTS_INT_V.eft_swift_code%TYPE, -- Payee BIC (added by sodash)
105:
106: payee_party_name HZ_PARTIES.party_name%TYPE,
107: payee_party_addr1 HZ_LOCATIONS.address1%TYPE,
108: payee_party_addr2 HZ_LOCATIONS.address2%TYPE,
109: payee_party_addr3 HZ_LOCATIONS.address3%TYPE,
110: payee_party_city HZ_LOCATIONS.city%TYPE,
111:

Line 108: payee_party_addr2 HZ_LOCATIONS.address2%TYPE,

104: ext_eft_swift_code IBY_EXT_BANK_ACCOUNTS_INT_V.eft_swift_code%TYPE, -- Payee BIC (added by sodash)
105:
106: payee_party_name HZ_PARTIES.party_name%TYPE,
107: payee_party_addr1 HZ_LOCATIONS.address1%TYPE,
108: payee_party_addr2 HZ_LOCATIONS.address2%TYPE,
109: payee_party_addr3 HZ_LOCATIONS.address3%TYPE,
110: payee_party_city HZ_LOCATIONS.city%TYPE,
111:
112: /*

Line 109: payee_party_addr3 HZ_LOCATIONS.address3%TYPE,

105:
106: payee_party_name HZ_PARTIES.party_name%TYPE,
107: payee_party_addr1 HZ_LOCATIONS.address1%TYPE,
108: payee_party_addr2 HZ_LOCATIONS.address2%TYPE,
109: payee_party_addr3 HZ_LOCATIONS.address3%TYPE,
110: payee_party_city HZ_LOCATIONS.city%TYPE,
111:
112: /*
113: * Fix for bug 6713003:

Line 110: payee_party_city HZ_LOCATIONS.city%TYPE,

106: payee_party_name HZ_PARTIES.party_name%TYPE,
107: payee_party_addr1 HZ_LOCATIONS.address1%TYPE,
108: payee_party_addr2 HZ_LOCATIONS.address2%TYPE,
109: payee_party_addr3 HZ_LOCATIONS.address3%TYPE,
110: payee_party_city HZ_LOCATIONS.city%TYPE,
111:
112: /*
113: * Fix for bug 6713003:
114: *

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

113: * Fix for bug 6713003:
114: *
115: * The payee address fields are picked up from three
116: * possible sources: HR_LOCATIONS, PER_ADDRESSES
117: * and HZ_LOCATIONS. Therefore, the field sizes
118: * should be the maximum of the corresponding column
119: * sizes from these three tables.
120: *
121: * Usually, HZ_LOCATIONS field sizes are sufficient.

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

117: * and HZ_LOCATIONS. Therefore, the field sizes
118: * should be the maximum of the corresponding column
119: * sizes from these three tables.
120: *
121: * Usually, HZ_LOCATIONS field sizes are sufficient.
122: * But for state, county and provice fields, HR_LOCATIONS /
123: * PER_ADDRESSES has larger field sizes.
124: *
125: * Therefore, for these three fields, we use HR_LOCATIONS

Line 132: payee_party_postal HZ_LOCATIONS.postal_code%TYPE,

128: payee_party_state HR_LOCATIONS.region_2%TYPE,
129: payee_party_province HR_LOCATIONS.region_1%TYPE,
130: payee_party_county HR_LOCATIONS.region_1%TYPE,
131:
132: payee_party_postal HZ_LOCATIONS.postal_code%TYPE,
133: payee_party_country HZ_LOCATIONS.country%TYPE,
134:
135: bank_charge_bearer IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
136: payment_reason_code IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,

Line 133: payee_party_country HZ_LOCATIONS.country%TYPE,

129: payee_party_province HR_LOCATIONS.region_1%TYPE,
130: payee_party_county HR_LOCATIONS.region_1%TYPE,
131:
132: payee_party_postal HZ_LOCATIONS.postal_code%TYPE,
133: payee_party_country HZ_LOCATIONS.country%TYPE,
134:
135: bank_charge_bearer IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
136: payment_reason_code IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
137: payment_method_cd IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

Line 549: HZ_LOCATIONS.address1%TYPE,

545: HZ_PARTIES.party_name%TYPE,
546: payee_tax_id
547: HZ_PARTIES.tax_reference%TYPE,
548: payee_add1
549: HZ_LOCATIONS.address1%TYPE,
550: payee_add2
551: HZ_LOCATIONS.address2%TYPE,
552: payee_add3
553: HZ_LOCATIONS.address3%TYPE,

Line 551: HZ_LOCATIONS.address2%TYPE,

547: HZ_PARTIES.tax_reference%TYPE,
548: payee_add1
549: HZ_LOCATIONS.address1%TYPE,
550: payee_add2
551: HZ_LOCATIONS.address2%TYPE,
552: payee_add3
553: HZ_LOCATIONS.address3%TYPE,
554: payee_city
555: HZ_LOCATIONS.city%TYPE,

Line 553: HZ_LOCATIONS.address3%TYPE,

549: HZ_LOCATIONS.address1%TYPE,
550: payee_add2
551: HZ_LOCATIONS.address2%TYPE,
552: payee_add3
553: HZ_LOCATIONS.address3%TYPE,
554: payee_city
555: HZ_LOCATIONS.city%TYPE,
556: payee_county
557: HZ_LOCATIONS.county%TYPE,

Line 555: HZ_LOCATIONS.city%TYPE,

551: HZ_LOCATIONS.address2%TYPE,
552: payee_add3
553: HZ_LOCATIONS.address3%TYPE,
554: payee_city
555: HZ_LOCATIONS.city%TYPE,
556: payee_county
557: HZ_LOCATIONS.county%TYPE,
558: payee_province
559: HZ_LOCATIONS.province%TYPE,

Line 557: HZ_LOCATIONS.county%TYPE,

553: HZ_LOCATIONS.address3%TYPE,
554: payee_city
555: HZ_LOCATIONS.city%TYPE,
556: payee_county
557: HZ_LOCATIONS.county%TYPE,
558: payee_province
559: HZ_LOCATIONS.province%TYPE,
560: payee_state
561: HZ_LOCATIONS.state%TYPE,

Line 559: HZ_LOCATIONS.province%TYPE,

555: HZ_LOCATIONS.city%TYPE,
556: payee_county
557: HZ_LOCATIONS.county%TYPE,
558: payee_province
559: HZ_LOCATIONS.province%TYPE,
560: payee_state
561: HZ_LOCATIONS.state%TYPE,
562: payee_country
563: HZ_LOCATIONS.country%TYPE,

Line 561: HZ_LOCATIONS.state%TYPE,

557: HZ_LOCATIONS.county%TYPE,
558: payee_province
559: HZ_LOCATIONS.province%TYPE,
560: payee_state
561: HZ_LOCATIONS.state%TYPE,
562: payee_country
563: HZ_LOCATIONS.country%TYPE,
564: payee_postcode
565: HZ_LOCATIONS.postal_code%TYPE,

Line 563: HZ_LOCATIONS.country%TYPE,

559: HZ_LOCATIONS.province%TYPE,
560: payee_state
561: HZ_LOCATIONS.state%TYPE,
562: payee_country
563: HZ_LOCATIONS.country%TYPE,
564: payee_postcode
565: HZ_LOCATIONS.postal_code%TYPE,
566:
567: /* PAYEE BANK */

Line 565: HZ_LOCATIONS.postal_code%TYPE,

561: HZ_LOCATIONS.state%TYPE,
562: payee_country
563: HZ_LOCATIONS.country%TYPE,
564: payee_postcode
565: HZ_LOCATIONS.postal_code%TYPE,
566:
567: /* PAYEE BANK */
568: payee_bank_name
569: IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,