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.IBE_WORKFLOW_PVT dependencies on HZ_LOCATIONS

Line 175: hz_locations shipaddr,

171: oh.transactional_curr_code
172: from oe_order_headers_all oh,
173: hz_parties sold_to_party,
174: hz_cust_accounts sold_to_account,
175: hz_locations shipaddr,
176: hz_party_sites shp_party_site,
177: hz_cust_acct_sites_all shp_acct_site,
178: hz_cust_site_uses_all shp_site_use,
179: hz_locations invaddr,

Line 179: hz_locations invaddr,

175: hz_locations shipaddr,
176: hz_party_sites shp_party_site,
177: hz_cust_acct_sites_all shp_acct_site,
178: hz_cust_site_uses_all shp_site_use,
179: hz_locations invaddr,
180: hz_party_sites inv_party_site,
181: hz_cust_acct_sites_all inv_acct_site,
182: hz_cust_site_uses_all inv_site_use
183: where oh.header_id=c_order_id

Line 6607: l_ship_address hz_locations.address1%TYPE;

6603: l_contact_name VARCHAR2(400);
6604: l_contact_number VARCHAR2(70);
6605: l_contact_email hz_contact_points.email_address%TYPE;
6606: l_contact_fax VARCHAR2(70);
6607: l_ship_address hz_locations.address1%TYPE;
6608: l_bill_address hz_locations.address1%TYPE;
6609: l_document VARCHAR2(32000) := '';
6610: l_temp_str VARCHAR2(2000):='';
6611: l_order_id NUMBER;

Line 6608: l_bill_address hz_locations.address1%TYPE;

6604: l_contact_number VARCHAR2(70);
6605: l_contact_email hz_contact_points.email_address%TYPE;
6606: l_contact_fax VARCHAR2(70);
6607: l_ship_address hz_locations.address1%TYPE;
6608: l_bill_address hz_locations.address1%TYPE;
6609: l_document VARCHAR2(32000) := '';
6610: l_temp_str VARCHAR2(2000):='';
6611: l_order_id NUMBER;
6612:

Line 8632: l_bill_to_address hz_locations.address1%TYPE;

8628: l_bill_to_party_name hz_parties.party_name%TYPE;
8629: l_bill_to_name VARCHAR2(400);
8630: l_bill_to_number VARCHAR2(70);
8631: l_bill_to_fax VARCHAR2(70);
8632: l_bill_to_address hz_locations.address1%TYPE;
8633: l_bill_to_city hz_locations.city%TYPE;
8634: l_bill_to_state hz_locations.state%TYPE;
8635: l_bill_to_zip hz_locations.postal_code%TYPE;
8636: l_bill_to_country hz_locations.country%TYPE;

Line 8633: l_bill_to_city hz_locations.city%TYPE;

8629: l_bill_to_name VARCHAR2(400);
8630: l_bill_to_number VARCHAR2(70);
8631: l_bill_to_fax VARCHAR2(70);
8632: l_bill_to_address hz_locations.address1%TYPE;
8633: l_bill_to_city hz_locations.city%TYPE;
8634: l_bill_to_state hz_locations.state%TYPE;
8635: l_bill_to_zip hz_locations.postal_code%TYPE;
8636: l_bill_to_country hz_locations.country%TYPE;
8637: l_ship_to_site_id aso_shipments.ship_to_party_site_id%TYPE;

Line 8634: l_bill_to_state hz_locations.state%TYPE;

8630: l_bill_to_number VARCHAR2(70);
8631: l_bill_to_fax VARCHAR2(70);
8632: l_bill_to_address hz_locations.address1%TYPE;
8633: l_bill_to_city hz_locations.city%TYPE;
8634: l_bill_to_state hz_locations.state%TYPE;
8635: l_bill_to_zip hz_locations.postal_code%TYPE;
8636: l_bill_to_country hz_locations.country%TYPE;
8637: l_ship_to_site_id aso_shipments.ship_to_party_site_id%TYPE;
8638: l_ship_to_party_id aso_shipments.ship_to_party_id%TYPE;

Line 8635: l_bill_to_zip hz_locations.postal_code%TYPE;

8631: l_bill_to_fax VARCHAR2(70);
8632: l_bill_to_address hz_locations.address1%TYPE;
8633: l_bill_to_city hz_locations.city%TYPE;
8634: l_bill_to_state hz_locations.state%TYPE;
8635: l_bill_to_zip hz_locations.postal_code%TYPE;
8636: l_bill_to_country hz_locations.country%TYPE;
8637: l_ship_to_site_id aso_shipments.ship_to_party_site_id%TYPE;
8638: l_ship_to_party_id aso_shipments.ship_to_party_id%TYPE;
8639: l_ship_to_cust_account_id aso_shipments.ship_to_cust_account_id%TYPE;

Line 8636: l_bill_to_country hz_locations.country%TYPE;

8632: l_bill_to_address hz_locations.address1%TYPE;
8633: l_bill_to_city hz_locations.city%TYPE;
8634: l_bill_to_state hz_locations.state%TYPE;
8635: l_bill_to_zip hz_locations.postal_code%TYPE;
8636: l_bill_to_country hz_locations.country%TYPE;
8637: l_ship_to_site_id aso_shipments.ship_to_party_site_id%TYPE;
8638: l_ship_to_party_id aso_shipments.ship_to_party_id%TYPE;
8639: l_ship_to_cust_account_id aso_shipments.ship_to_cust_account_id%TYPE;
8640: l_ship_method_code aso_shipments.ship_method_code%TYPE;

Line 8648: l_ship_to_address hz_locations.address1%TYPE;

8644: l_ship_to_party_name hz_parties.party_name%TYPE;
8645: l_ship_to_name VARCHAR2(400);
8646: l_ship_to_number VARCHAR2(70);
8647: l_ship_to_fax VARCHAR2(70);
8648: l_ship_to_address hz_locations.address1%TYPE;
8649: l_ship_to_city hz_locations.city%TYPE;
8650: l_ship_to_state hz_locations.state%TYPE;
8651: l_ship_to_zip hz_locations.postal_code%TYPE;
8652: l_ship_to_country hz_locations.country%TYPE;

Line 8649: l_ship_to_city hz_locations.city%TYPE;

8645: l_ship_to_name VARCHAR2(400);
8646: l_ship_to_number VARCHAR2(70);
8647: l_ship_to_fax VARCHAR2(70);
8648: l_ship_to_address hz_locations.address1%TYPE;
8649: l_ship_to_city hz_locations.city%TYPE;
8650: l_ship_to_state hz_locations.state%TYPE;
8651: l_ship_to_zip hz_locations.postal_code%TYPE;
8652: l_ship_to_country hz_locations.country%TYPE;
8653: l_document VARCHAR2(32000) := '';

Line 8650: l_ship_to_state hz_locations.state%TYPE;

8646: l_ship_to_number VARCHAR2(70);
8647: l_ship_to_fax VARCHAR2(70);
8648: l_ship_to_address hz_locations.address1%TYPE;
8649: l_ship_to_city hz_locations.city%TYPE;
8650: l_ship_to_state hz_locations.state%TYPE;
8651: l_ship_to_zip hz_locations.postal_code%TYPE;
8652: l_ship_to_country hz_locations.country%TYPE;
8653: l_document VARCHAR2(32000) := '';
8654: l_temp_str VARCHAR2(2000):='';

Line 8651: l_ship_to_zip hz_locations.postal_code%TYPE;

8647: l_ship_to_fax VARCHAR2(70);
8648: l_ship_to_address hz_locations.address1%TYPE;
8649: l_ship_to_city hz_locations.city%TYPE;
8650: l_ship_to_state hz_locations.state%TYPE;
8651: l_ship_to_zip hz_locations.postal_code%TYPE;
8652: l_ship_to_country hz_locations.country%TYPE;
8653: l_document VARCHAR2(32000) := '';
8654: l_temp_str VARCHAR2(2000):='';
8655:

Line 8652: l_ship_to_country hz_locations.country%TYPE;

8648: l_ship_to_address hz_locations.address1%TYPE;
8649: l_ship_to_city hz_locations.city%TYPE;
8650: l_ship_to_state hz_locations.state%TYPE;
8651: l_ship_to_zip hz_locations.postal_code%TYPE;
8652: l_ship_to_country hz_locations.country%TYPE;
8653: l_document VARCHAR2(32000) := '';
8654: l_temp_str VARCHAR2(2000):='';
8655:
8656: Cursor c_hz_locations(p_loc_site_id NUMBER) IS

Line 8656: Cursor c_hz_locations(p_loc_site_id NUMBER) IS

8652: l_ship_to_country hz_locations.country%TYPE;
8653: l_document VARCHAR2(32000) := '';
8654: l_temp_str VARCHAR2(2000):='';
8655:
8656: Cursor c_hz_locations(p_loc_site_id NUMBER) IS
8657: SELECT rtrim(address1) || ' ' || rtrim(address2) || ' ' || rtrim(address3) || ' ' || rtrim(address4) loc_address,
8658: rtrim(city) loc_city,
8659: rtrim(state)||'/' || rtrim(province) loc_state,
8660: rtrim(postal_code) loc_zip,

Line 8662: FROM hz_locations

8658: rtrim(city) loc_city,
8659: rtrim(state)||'/' || rtrim(province) loc_state,
8660: rtrim(postal_code) loc_zip,
8661: rtrim(country) loc_country
8662: FROM hz_locations
8663: WHERE location_id = ( SELECT location_id
8664: FROM hz_party_sites
8665: WHERE party_site_id = p_loc_site_id);
8666: Cursor c_aso_shipments(p_quote_id NUMBER) IS

Line 8836: FOR c_hz_locations_rec IN c_hz_locations(g_quote_header_rec.invoice_to_party_site_id) LOOP

8832: l_bill_to_country := null;
8833:
8834: /* Bill to Location id using invoice_to_party_site_id */
8835:
8836: FOR c_hz_locations_rec IN c_hz_locations(g_quote_header_rec.invoice_to_party_site_id) LOOP
8837: l_bill_to_address := c_hz_locations_rec.loc_address;
8838: l_bill_to_city := c_hz_locations_rec.loc_city;
8839: l_bill_to_state := c_hz_locations_rec.loc_state;
8840: l_bill_to_zip := c_hz_locations_rec.loc_zip;

Line 8837: l_bill_to_address := c_hz_locations_rec.loc_address;

8833:
8834: /* Bill to Location id using invoice_to_party_site_id */
8835:
8836: FOR c_hz_locations_rec IN c_hz_locations(g_quote_header_rec.invoice_to_party_site_id) LOOP
8837: l_bill_to_address := c_hz_locations_rec.loc_address;
8838: l_bill_to_city := c_hz_locations_rec.loc_city;
8839: l_bill_to_state := c_hz_locations_rec.loc_state;
8840: l_bill_to_zip := c_hz_locations_rec.loc_zip;
8841: l_bill_to_country := c_hz_locations_rec.loc_country;

Line 8838: l_bill_to_city := c_hz_locations_rec.loc_city;

8834: /* Bill to Location id using invoice_to_party_site_id */
8835:
8836: FOR c_hz_locations_rec IN c_hz_locations(g_quote_header_rec.invoice_to_party_site_id) LOOP
8837: l_bill_to_address := c_hz_locations_rec.loc_address;
8838: l_bill_to_city := c_hz_locations_rec.loc_city;
8839: l_bill_to_state := c_hz_locations_rec.loc_state;
8840: l_bill_to_zip := c_hz_locations_rec.loc_zip;
8841: l_bill_to_country := c_hz_locations_rec.loc_country;
8842:

Line 8839: l_bill_to_state := c_hz_locations_rec.loc_state;

8835:
8836: FOR c_hz_locations_rec IN c_hz_locations(g_quote_header_rec.invoice_to_party_site_id) LOOP
8837: l_bill_to_address := c_hz_locations_rec.loc_address;
8838: l_bill_to_city := c_hz_locations_rec.loc_city;
8839: l_bill_to_state := c_hz_locations_rec.loc_state;
8840: l_bill_to_zip := c_hz_locations_rec.loc_zip;
8841: l_bill_to_country := c_hz_locations_rec.loc_country;
8842:
8843: END LOOP;

Line 8840: l_bill_to_zip := c_hz_locations_rec.loc_zip;

8836: FOR c_hz_locations_rec IN c_hz_locations(g_quote_header_rec.invoice_to_party_site_id) LOOP
8837: l_bill_to_address := c_hz_locations_rec.loc_address;
8838: l_bill_to_city := c_hz_locations_rec.loc_city;
8839: l_bill_to_state := c_hz_locations_rec.loc_state;
8840: l_bill_to_zip := c_hz_locations_rec.loc_zip;
8841: l_bill_to_country := c_hz_locations_rec.loc_country;
8842:
8843: END LOOP;
8844:

Line 8841: l_bill_to_country := c_hz_locations_rec.loc_country;

8837: l_bill_to_address := c_hz_locations_rec.loc_address;
8838: l_bill_to_city := c_hz_locations_rec.loc_city;
8839: l_bill_to_state := c_hz_locations_rec.loc_state;
8840: l_bill_to_zip := c_hz_locations_rec.loc_zip;
8841: l_bill_to_country := c_hz_locations_rec.loc_country;
8842:
8843: END LOOP;
8844:
8845: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 8926: FOR c_hz_locations_rec IN c_hz_locations(l_ship_to_site_id) LOOP

8922: l_ship_to_state := null;
8923: l_ship_to_zip := null;
8924: l_ship_to_country := null;
8925:
8926: FOR c_hz_locations_rec IN c_hz_locations(l_ship_to_site_id) LOOP
8927:
8928: l_ship_to_address := c_hz_locations_rec.loc_address;
8929: l_ship_to_city := c_hz_locations_rec.loc_city;
8930: l_ship_to_state := c_hz_locations_rec.loc_state;

Line 8928: l_ship_to_address := c_hz_locations_rec.loc_address;

8924: l_ship_to_country := null;
8925:
8926: FOR c_hz_locations_rec IN c_hz_locations(l_ship_to_site_id) LOOP
8927:
8928: l_ship_to_address := c_hz_locations_rec.loc_address;
8929: l_ship_to_city := c_hz_locations_rec.loc_city;
8930: l_ship_to_state := c_hz_locations_rec.loc_state;
8931: l_ship_to_zip := c_hz_locations_rec.loc_zip;
8932: l_ship_to_country := c_hz_locations_rec.loc_country;

Line 8929: l_ship_to_city := c_hz_locations_rec.loc_city;

8925:
8926: FOR c_hz_locations_rec IN c_hz_locations(l_ship_to_site_id) LOOP
8927:
8928: l_ship_to_address := c_hz_locations_rec.loc_address;
8929: l_ship_to_city := c_hz_locations_rec.loc_city;
8930: l_ship_to_state := c_hz_locations_rec.loc_state;
8931: l_ship_to_zip := c_hz_locations_rec.loc_zip;
8932: l_ship_to_country := c_hz_locations_rec.loc_country;
8933:

Line 8930: l_ship_to_state := c_hz_locations_rec.loc_state;

8926: FOR c_hz_locations_rec IN c_hz_locations(l_ship_to_site_id) LOOP
8927:
8928: l_ship_to_address := c_hz_locations_rec.loc_address;
8929: l_ship_to_city := c_hz_locations_rec.loc_city;
8930: l_ship_to_state := c_hz_locations_rec.loc_state;
8931: l_ship_to_zip := c_hz_locations_rec.loc_zip;
8932: l_ship_to_country := c_hz_locations_rec.loc_country;
8933:
8934: END LOOP;

Line 8931: l_ship_to_zip := c_hz_locations_rec.loc_zip;

8927:
8928: l_ship_to_address := c_hz_locations_rec.loc_address;
8929: l_ship_to_city := c_hz_locations_rec.loc_city;
8930: l_ship_to_state := c_hz_locations_rec.loc_state;
8931: l_ship_to_zip := c_hz_locations_rec.loc_zip;
8932: l_ship_to_country := c_hz_locations_rec.loc_country;
8933:
8934: END LOOP;
8935:

Line 8932: l_ship_to_country := c_hz_locations_rec.loc_country;

8928: l_ship_to_address := c_hz_locations_rec.loc_address;
8929: l_ship_to_city := c_hz_locations_rec.loc_city;
8930: l_ship_to_state := c_hz_locations_rec.loc_state;
8931: l_ship_to_zip := c_hz_locations_rec.loc_zip;
8932: l_ship_to_country := c_hz_locations_rec.loc_country;
8933:
8934: END LOOP;
8935:
8936: