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.

[Home] [Help]

APPS.AP_CHECKS_PKG dependencies on HZ_LOCATIONS

Line 137: l_Address_Line1 hz_locations.address1%type;

133: current_calling_sequence VARCHAR2(2000);
134: debug_info VARCHAR2(100);
135:
136: /* Added for bug#12393780 Start */
137: l_Address_Line1 hz_locations.address1%type;
138: l_Address_Line2 hz_locations.address2%type;
139: l_Address_Line3 hz_locations.address3%type;
140: l_Address_Line4 hz_locations.address4%type;
141: l_Address_Style fnd_territories.address_style%type;

Line 138: l_Address_Line2 hz_locations.address2%type;

134: debug_info VARCHAR2(100);
135:
136: /* Added for bug#12393780 Start */
137: l_Address_Line1 hz_locations.address1%type;
138: l_Address_Line2 hz_locations.address2%type;
139: l_Address_Line3 hz_locations.address3%type;
140: l_Address_Line4 hz_locations.address4%type;
141: l_Address_Style fnd_territories.address_style%type;
142: l_City hz_locations.city%type;

Line 139: l_Address_Line3 hz_locations.address3%type;

135:
136: /* Added for bug#12393780 Start */
137: l_Address_Line1 hz_locations.address1%type;
138: l_Address_Line2 hz_locations.address2%type;
139: l_Address_Line3 hz_locations.address3%type;
140: l_Address_Line4 hz_locations.address4%type;
141: l_Address_Style fnd_territories.address_style%type;
142: l_City hz_locations.city%type;
143: l_County hz_locations.county%type;

Line 140: l_Address_Line4 hz_locations.address4%type;

136: /* Added for bug#12393780 Start */
137: l_Address_Line1 hz_locations.address1%type;
138: l_Address_Line2 hz_locations.address2%type;
139: l_Address_Line3 hz_locations.address3%type;
140: l_Address_Line4 hz_locations.address4%type;
141: l_Address_Style fnd_territories.address_style%type;
142: l_City hz_locations.city%type;
143: l_County hz_locations.county%type;
144: l_State hz_locations.state%type;

Line 142: l_City hz_locations.city%type;

138: l_Address_Line2 hz_locations.address2%type;
139: l_Address_Line3 hz_locations.address3%type;
140: l_Address_Line4 hz_locations.address4%type;
141: l_Address_Style fnd_territories.address_style%type;
142: l_City hz_locations.city%type;
143: l_County hz_locations.county%type;
144: l_State hz_locations.state%type;
145: l_Province hz_locations.province%type;
146: l_Zip hz_locations.postal_code%type;

Line 143: l_County hz_locations.county%type;

139: l_Address_Line3 hz_locations.address3%type;
140: l_Address_Line4 hz_locations.address4%type;
141: l_Address_Style fnd_territories.address_style%type;
142: l_City hz_locations.city%type;
143: l_County hz_locations.county%type;
144: l_State hz_locations.state%type;
145: l_Province hz_locations.province%type;
146: l_Zip hz_locations.postal_code%type;
147: l_Country hz_locations.country%type;

Line 144: l_State hz_locations.state%type;

140: l_Address_Line4 hz_locations.address4%type;
141: l_Address_Style fnd_territories.address_style%type;
142: l_City hz_locations.city%type;
143: l_County hz_locations.county%type;
144: l_State hz_locations.state%type;
145: l_Province hz_locations.province%type;
146: l_Zip hz_locations.postal_code%type;
147: l_Country hz_locations.country%type;
148: /* Added for bug#12393780 End */

Line 145: l_Province hz_locations.province%type;

141: l_Address_Style fnd_territories.address_style%type;
142: l_City hz_locations.city%type;
143: l_County hz_locations.county%type;
144: l_State hz_locations.state%type;
145: l_Province hz_locations.province%type;
146: l_Zip hz_locations.postal_code%type;
147: l_Country hz_locations.country%type;
148: /* Added for bug#12393780 End */
149:

Line 146: l_Zip hz_locations.postal_code%type;

142: l_City hz_locations.city%type;
143: l_County hz_locations.county%type;
144: l_State hz_locations.state%type;
145: l_Province hz_locations.province%type;
146: l_Zip hz_locations.postal_code%type;
147: l_Country hz_locations.country%type;
148: /* Added for bug#12393780 End */
149:
150: BEGIN

Line 147: l_Country hz_locations.country%type;

143: l_County hz_locations.county%type;
144: l_State hz_locations.state%type;
145: l_Province hz_locations.province%type;
146: l_Zip hz_locations.postal_code%type;
147: l_Country hz_locations.country%type;
148: /* Added for bug#12393780 End */
149:
150: BEGIN
151:

Line 186: hz_locations hzl ,

182: , l_Province
183: , l_Zip
184: , l_Country
185: FROM ap_supplier_sites a,
186: hz_locations hzl ,
187: fnd_territories_tl ft,
188: FND_TERRITORIES B
189: WHERE a.pay_site_flag = 'Y'
190: AND a.vendor_id = X_Remit_To_Supplier_Id