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.PN_EXP_TO_CAD_ITF dependencies on PN_ADDRESSES

Line 81: -- 15-JUL-05 hareesha o Bug 4284035 - Replaced pn_addresses with _ALL table.

77: -----------------------------------------------------------------------------
78: -- FOR loading Locations Info into the Interface Table ( FOR CAFM )
79: -- ( Run AS a Conc Process )
80: -- ( PN_LOCATIONS --> PN_LOCATIONS_ITF )
81: -- 15-JUL-05 hareesha o Bug 4284035 - Replaced pn_addresses with _ALL table.
82: -- 29-SEP-05 Hareesha o ATG mandated changes for SQL literals using dbms_sql.
83: -----------------------------------------------------------------------------
84: PROCEDURE exp_loc_to_cad_itf (
85: p_batch_name IN VARCHAR2 ,

Line 127: v_address_line1 PN_ADDRESSES.ADDRESS_LINE1%TYPE;

123: v_lease_or_owned PN_LOCATIONS.LEASE_OR_OWNED%TYPE;
124: v_building PN_LOCATIONS.BUILDING%TYPE;
125: v_floor PN_LOCATIONS.FLOOR%TYPE;
126: v_office PN_LOCATIONS.OFFICE%TYPE;
127: v_address_line1 PN_ADDRESSES.ADDRESS_LINE1%TYPE;
128: v_address_line2 PN_ADDRESSES.ADDRESS_LINE2%TYPE;
129: v_address_line3 PN_ADDRESSES.ADDRESS_LINE3%TYPE;
130: v_address_line4 PN_ADDRESSES.ADDRESS_LINE4%TYPE;
131: v_county PN_ADDRESSES.COUNTY%TYPE;

Line 128: v_address_line2 PN_ADDRESSES.ADDRESS_LINE2%TYPE;

124: v_building PN_LOCATIONS.BUILDING%TYPE;
125: v_floor PN_LOCATIONS.FLOOR%TYPE;
126: v_office PN_LOCATIONS.OFFICE%TYPE;
127: v_address_line1 PN_ADDRESSES.ADDRESS_LINE1%TYPE;
128: v_address_line2 PN_ADDRESSES.ADDRESS_LINE2%TYPE;
129: v_address_line3 PN_ADDRESSES.ADDRESS_LINE3%TYPE;
130: v_address_line4 PN_ADDRESSES.ADDRESS_LINE4%TYPE;
131: v_county PN_ADDRESSES.COUNTY%TYPE;
132: v_city PN_ADDRESSES.CITY%TYPE;

Line 129: v_address_line3 PN_ADDRESSES.ADDRESS_LINE3%TYPE;

125: v_floor PN_LOCATIONS.FLOOR%TYPE;
126: v_office PN_LOCATIONS.OFFICE%TYPE;
127: v_address_line1 PN_ADDRESSES.ADDRESS_LINE1%TYPE;
128: v_address_line2 PN_ADDRESSES.ADDRESS_LINE2%TYPE;
129: v_address_line3 PN_ADDRESSES.ADDRESS_LINE3%TYPE;
130: v_address_line4 PN_ADDRESSES.ADDRESS_LINE4%TYPE;
131: v_county PN_ADDRESSES.COUNTY%TYPE;
132: v_city PN_ADDRESSES.CITY%TYPE;
133: v_state PN_ADDRESSES.STATE%TYPE;

Line 130: v_address_line4 PN_ADDRESSES.ADDRESS_LINE4%TYPE;

126: v_office PN_LOCATIONS.OFFICE%TYPE;
127: v_address_line1 PN_ADDRESSES.ADDRESS_LINE1%TYPE;
128: v_address_line2 PN_ADDRESSES.ADDRESS_LINE2%TYPE;
129: v_address_line3 PN_ADDRESSES.ADDRESS_LINE3%TYPE;
130: v_address_line4 PN_ADDRESSES.ADDRESS_LINE4%TYPE;
131: v_county PN_ADDRESSES.COUNTY%TYPE;
132: v_city PN_ADDRESSES.CITY%TYPE;
133: v_state PN_ADDRESSES.STATE%TYPE;
134: v_province PN_ADDRESSES.PROVINCE%TYPE;

Line 131: v_county PN_ADDRESSES.COUNTY%TYPE;

127: v_address_line1 PN_ADDRESSES.ADDRESS_LINE1%TYPE;
128: v_address_line2 PN_ADDRESSES.ADDRESS_LINE2%TYPE;
129: v_address_line3 PN_ADDRESSES.ADDRESS_LINE3%TYPE;
130: v_address_line4 PN_ADDRESSES.ADDRESS_LINE4%TYPE;
131: v_county PN_ADDRESSES.COUNTY%TYPE;
132: v_city PN_ADDRESSES.CITY%TYPE;
133: v_state PN_ADDRESSES.STATE%TYPE;
134: v_province PN_ADDRESSES.PROVINCE%TYPE;
135: v_zip_code PN_ADDRESSES.ZIP_CODE%TYPE;

Line 132: v_city PN_ADDRESSES.CITY%TYPE;

128: v_address_line2 PN_ADDRESSES.ADDRESS_LINE2%TYPE;
129: v_address_line3 PN_ADDRESSES.ADDRESS_LINE3%TYPE;
130: v_address_line4 PN_ADDRESSES.ADDRESS_LINE4%TYPE;
131: v_county PN_ADDRESSES.COUNTY%TYPE;
132: v_city PN_ADDRESSES.CITY%TYPE;
133: v_state PN_ADDRESSES.STATE%TYPE;
134: v_province PN_ADDRESSES.PROVINCE%TYPE;
135: v_zip_code PN_ADDRESSES.ZIP_CODE%TYPE;
136: v_country PN_ADDRESSES.COUNTRY%TYPE;

Line 133: v_state PN_ADDRESSES.STATE%TYPE;

129: v_address_line3 PN_ADDRESSES.ADDRESS_LINE3%TYPE;
130: v_address_line4 PN_ADDRESSES.ADDRESS_LINE4%TYPE;
131: v_county PN_ADDRESSES.COUNTY%TYPE;
132: v_city PN_ADDRESSES.CITY%TYPE;
133: v_state PN_ADDRESSES.STATE%TYPE;
134: v_province PN_ADDRESSES.PROVINCE%TYPE;
135: v_zip_code PN_ADDRESSES.ZIP_CODE%TYPE;
136: v_country PN_ADDRESSES.COUNTRY%TYPE;
137: v_address_style PN_ADDRESSES.ADDRESS_STYLE%TYPE;

Line 134: v_province PN_ADDRESSES.PROVINCE%TYPE;

130: v_address_line4 PN_ADDRESSES.ADDRESS_LINE4%TYPE;
131: v_county PN_ADDRESSES.COUNTY%TYPE;
132: v_city PN_ADDRESSES.CITY%TYPE;
133: v_state PN_ADDRESSES.STATE%TYPE;
134: v_province PN_ADDRESSES.PROVINCE%TYPE;
135: v_zip_code PN_ADDRESSES.ZIP_CODE%TYPE;
136: v_country PN_ADDRESSES.COUNTRY%TYPE;
137: v_address_style PN_ADDRESSES.ADDRESS_STYLE%TYPE;
138: v_max_capacity PN_LOCATIONS.MAX_CAPACITY%TYPE;

Line 135: v_zip_code PN_ADDRESSES.ZIP_CODE%TYPE;

131: v_county PN_ADDRESSES.COUNTY%TYPE;
132: v_city PN_ADDRESSES.CITY%TYPE;
133: v_state PN_ADDRESSES.STATE%TYPE;
134: v_province PN_ADDRESSES.PROVINCE%TYPE;
135: v_zip_code PN_ADDRESSES.ZIP_CODE%TYPE;
136: v_country PN_ADDRESSES.COUNTRY%TYPE;
137: v_address_style PN_ADDRESSES.ADDRESS_STYLE%TYPE;
138: v_max_capacity PN_LOCATIONS.MAX_CAPACITY%TYPE;
139: v_rentable_area PN_LOCATIONS.RENTABLE_AREA%TYPE;

Line 136: v_country PN_ADDRESSES.COUNTRY%TYPE;

132: v_city PN_ADDRESSES.CITY%TYPE;
133: v_state PN_ADDRESSES.STATE%TYPE;
134: v_province PN_ADDRESSES.PROVINCE%TYPE;
135: v_zip_code PN_ADDRESSES.ZIP_CODE%TYPE;
136: v_country PN_ADDRESSES.COUNTRY%TYPE;
137: v_address_style PN_ADDRESSES.ADDRESS_STYLE%TYPE;
138: v_max_capacity PN_LOCATIONS.MAX_CAPACITY%TYPE;
139: v_rentable_area PN_LOCATIONS.RENTABLE_AREA%TYPE;
140: v_optimum_capacity PN_LOCATIONS.OPTIMUM_CAPACITY%TYPE;

Line 137: v_address_style PN_ADDRESSES.ADDRESS_STYLE%TYPE;

133: v_state PN_ADDRESSES.STATE%TYPE;
134: v_province PN_ADDRESSES.PROVINCE%TYPE;
135: v_zip_code PN_ADDRESSES.ZIP_CODE%TYPE;
136: v_country PN_ADDRESSES.COUNTRY%TYPE;
137: v_address_style PN_ADDRESSES.ADDRESS_STYLE%TYPE;
138: v_max_capacity PN_LOCATIONS.MAX_CAPACITY%TYPE;
139: v_rentable_area PN_LOCATIONS.RENTABLE_AREA%TYPE;
140: v_optimum_capacity PN_LOCATIONS.OPTIMUM_CAPACITY%TYPE;
141: v_usable_area PN_LOCATIONS.USABLE_AREA%TYPE;

Line 280: PN_ADDRESSES_ALL A

276: L.ACTIVE_END_DATE,
277: L.STANDARD_TYPE_LOOKUP_CODE ---BUG#5359173
278: FROM
279: PN_LOCATIONS L,
280: PN_ADDRESSES_ALL A
281: WHERE
282: L.ADDRESS_ID = A.ADDRESS_ID (+)
283: AND L.LAST_UPDATE_DATE >= TRUNC(:date_from )
284: AND L.LAST_UPDATE_DATE <= TRUNC(:date_to) ';