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 165: hz_locations shipaddr,

161: oh.transactional_curr_code
162: from oe_order_headers_all oh,
163: hz_parties sold_to_party,
164: hz_cust_accounts sold_to_account,
165: hz_locations shipaddr,
166: hz_party_sites shp_party_site,
167: hz_cust_acct_sites_all shp_acct_site,
168: hz_cust_site_uses_all shp_site_use,
169: hz_locations invaddr,

Line 169: hz_locations invaddr,

165: hz_locations shipaddr,
166: hz_party_sites shp_party_site,
167: hz_cust_acct_sites_all shp_acct_site,
168: hz_cust_site_uses_all shp_site_use,
169: hz_locations invaddr,
170: hz_party_sites inv_party_site,
171: hz_cust_acct_sites_all inv_acct_site,
172: hz_cust_site_uses_all inv_site_use
173: where oh.header_id=c_order_id

Line 6512: l_ship_address hz_locations.address1%TYPE;

6508: l_contact_name VARCHAR2(400);
6509: l_contact_number VARCHAR2(70);
6510: l_contact_email hz_contact_points.email_address%TYPE;
6511: l_contact_fax VARCHAR2(70);
6512: l_ship_address hz_locations.address1%TYPE;
6513: l_bill_address hz_locations.address1%TYPE;
6514: l_document VARCHAR2(32000) := '';
6515: l_temp_str VARCHAR2(2000):='';
6516: l_order_id NUMBER;

Line 6513: l_bill_address hz_locations.address1%TYPE;

6509: l_contact_number VARCHAR2(70);
6510: l_contact_email hz_contact_points.email_address%TYPE;
6511: l_contact_fax VARCHAR2(70);
6512: l_ship_address hz_locations.address1%TYPE;
6513: l_bill_address hz_locations.address1%TYPE;
6514: l_document VARCHAR2(32000) := '';
6515: l_temp_str VARCHAR2(2000):='';
6516: l_order_id NUMBER;
6517:

Line 8537: l_bill_to_address hz_locations.address1%TYPE;

8533: l_bill_to_party_name hz_parties.party_name%TYPE;
8534: l_bill_to_name VARCHAR2(400);
8535: l_bill_to_number VARCHAR2(70);
8536: l_bill_to_fax VARCHAR2(70);
8537: l_bill_to_address hz_locations.address1%TYPE;
8538: l_bill_to_city hz_locations.city%TYPE;
8539: l_bill_to_state hz_locations.state%TYPE;
8540: l_bill_to_zip hz_locations.postal_code%TYPE;
8541: l_bill_to_country hz_locations.country%TYPE;

Line 8538: l_bill_to_city hz_locations.city%TYPE;

8534: l_bill_to_name VARCHAR2(400);
8535: l_bill_to_number VARCHAR2(70);
8536: l_bill_to_fax VARCHAR2(70);
8537: l_bill_to_address hz_locations.address1%TYPE;
8538: l_bill_to_city hz_locations.city%TYPE;
8539: l_bill_to_state hz_locations.state%TYPE;
8540: l_bill_to_zip hz_locations.postal_code%TYPE;
8541: l_bill_to_country hz_locations.country%TYPE;
8542: l_ship_to_site_id aso_shipments.ship_to_party_site_id%TYPE;

Line 8539: l_bill_to_state hz_locations.state%TYPE;

8535: l_bill_to_number VARCHAR2(70);
8536: l_bill_to_fax VARCHAR2(70);
8537: l_bill_to_address hz_locations.address1%TYPE;
8538: l_bill_to_city hz_locations.city%TYPE;
8539: l_bill_to_state hz_locations.state%TYPE;
8540: l_bill_to_zip hz_locations.postal_code%TYPE;
8541: l_bill_to_country hz_locations.country%TYPE;
8542: l_ship_to_site_id aso_shipments.ship_to_party_site_id%TYPE;
8543: l_ship_to_party_id aso_shipments.ship_to_party_id%TYPE;

Line 8540: l_bill_to_zip hz_locations.postal_code%TYPE;

8536: l_bill_to_fax VARCHAR2(70);
8537: l_bill_to_address hz_locations.address1%TYPE;
8538: l_bill_to_city hz_locations.city%TYPE;
8539: l_bill_to_state hz_locations.state%TYPE;
8540: l_bill_to_zip hz_locations.postal_code%TYPE;
8541: l_bill_to_country hz_locations.country%TYPE;
8542: l_ship_to_site_id aso_shipments.ship_to_party_site_id%TYPE;
8543: l_ship_to_party_id aso_shipments.ship_to_party_id%TYPE;
8544: l_ship_to_cust_account_id aso_shipments.ship_to_cust_account_id%TYPE;

Line 8541: l_bill_to_country hz_locations.country%TYPE;

8537: l_bill_to_address hz_locations.address1%TYPE;
8538: l_bill_to_city hz_locations.city%TYPE;
8539: l_bill_to_state hz_locations.state%TYPE;
8540: l_bill_to_zip hz_locations.postal_code%TYPE;
8541: l_bill_to_country hz_locations.country%TYPE;
8542: l_ship_to_site_id aso_shipments.ship_to_party_site_id%TYPE;
8543: l_ship_to_party_id aso_shipments.ship_to_party_id%TYPE;
8544: l_ship_to_cust_account_id aso_shipments.ship_to_cust_account_id%TYPE;
8545: l_ship_method_code aso_shipments.ship_method_code%TYPE;

Line 8553: l_ship_to_address hz_locations.address1%TYPE;

8549: l_ship_to_party_name hz_parties.party_name%TYPE;
8550: l_ship_to_name VARCHAR2(400);
8551: l_ship_to_number VARCHAR2(70);
8552: l_ship_to_fax VARCHAR2(70);
8553: l_ship_to_address hz_locations.address1%TYPE;
8554: l_ship_to_city hz_locations.city%TYPE;
8555: l_ship_to_state hz_locations.state%TYPE;
8556: l_ship_to_zip hz_locations.postal_code%TYPE;
8557: l_ship_to_country hz_locations.country%TYPE;

Line 8554: l_ship_to_city hz_locations.city%TYPE;

8550: l_ship_to_name VARCHAR2(400);
8551: l_ship_to_number VARCHAR2(70);
8552: l_ship_to_fax VARCHAR2(70);
8553: l_ship_to_address hz_locations.address1%TYPE;
8554: l_ship_to_city hz_locations.city%TYPE;
8555: l_ship_to_state hz_locations.state%TYPE;
8556: l_ship_to_zip hz_locations.postal_code%TYPE;
8557: l_ship_to_country hz_locations.country%TYPE;
8558: l_document VARCHAR2(32000) := '';

Line 8555: l_ship_to_state hz_locations.state%TYPE;

8551: l_ship_to_number VARCHAR2(70);
8552: l_ship_to_fax VARCHAR2(70);
8553: l_ship_to_address hz_locations.address1%TYPE;
8554: l_ship_to_city hz_locations.city%TYPE;
8555: l_ship_to_state hz_locations.state%TYPE;
8556: l_ship_to_zip hz_locations.postal_code%TYPE;
8557: l_ship_to_country hz_locations.country%TYPE;
8558: l_document VARCHAR2(32000) := '';
8559: l_temp_str VARCHAR2(2000):='';

Line 8556: l_ship_to_zip hz_locations.postal_code%TYPE;

8552: l_ship_to_fax VARCHAR2(70);
8553: l_ship_to_address hz_locations.address1%TYPE;
8554: l_ship_to_city hz_locations.city%TYPE;
8555: l_ship_to_state hz_locations.state%TYPE;
8556: l_ship_to_zip hz_locations.postal_code%TYPE;
8557: l_ship_to_country hz_locations.country%TYPE;
8558: l_document VARCHAR2(32000) := '';
8559: l_temp_str VARCHAR2(2000):='';
8560:

Line 8557: l_ship_to_country hz_locations.country%TYPE;

8553: l_ship_to_address hz_locations.address1%TYPE;
8554: l_ship_to_city hz_locations.city%TYPE;
8555: l_ship_to_state hz_locations.state%TYPE;
8556: l_ship_to_zip hz_locations.postal_code%TYPE;
8557: l_ship_to_country hz_locations.country%TYPE;
8558: l_document VARCHAR2(32000) := '';
8559: l_temp_str VARCHAR2(2000):='';
8560:
8561: Cursor c_hz_locations(p_loc_site_id NUMBER) IS

Line 8561: Cursor c_hz_locations(p_loc_site_id NUMBER) IS

8557: l_ship_to_country hz_locations.country%TYPE;
8558: l_document VARCHAR2(32000) := '';
8559: l_temp_str VARCHAR2(2000):='';
8560:
8561: Cursor c_hz_locations(p_loc_site_id NUMBER) IS
8562: SELECT rtrim(address1) || ' ' || rtrim(address2) || ' ' || rtrim(address3) || ' ' || rtrim(address4) loc_address,
8563: rtrim(city) loc_city,
8564: rtrim(state)||'/' || rtrim(province) loc_state,
8565: rtrim(postal_code) loc_zip,

Line 8567: FROM hz_locations

8563: rtrim(city) loc_city,
8564: rtrim(state)||'/' || rtrim(province) loc_state,
8565: rtrim(postal_code) loc_zip,
8566: rtrim(country) loc_country
8567: FROM hz_locations
8568: WHERE location_id = ( SELECT location_id
8569: FROM hz_party_sites
8570: WHERE party_site_id = p_loc_site_id);
8571: Cursor c_aso_shipments(p_quote_id NUMBER) IS

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

8737: l_bill_to_country := null;
8738:
8739: /* Bill to Location id using invoice_to_party_site_id */
8740:
8741: FOR c_hz_locations_rec IN c_hz_locations(g_quote_header_rec.invoice_to_party_site_id) LOOP
8742: l_bill_to_address := c_hz_locations_rec.loc_address;
8743: l_bill_to_city := c_hz_locations_rec.loc_city;
8744: l_bill_to_state := c_hz_locations_rec.loc_state;
8745: l_bill_to_zip := c_hz_locations_rec.loc_zip;

Line 8742: l_bill_to_address := c_hz_locations_rec.loc_address;

8738:
8739: /* Bill to Location id using invoice_to_party_site_id */
8740:
8741: FOR c_hz_locations_rec IN c_hz_locations(g_quote_header_rec.invoice_to_party_site_id) LOOP
8742: l_bill_to_address := c_hz_locations_rec.loc_address;
8743: l_bill_to_city := c_hz_locations_rec.loc_city;
8744: l_bill_to_state := c_hz_locations_rec.loc_state;
8745: l_bill_to_zip := c_hz_locations_rec.loc_zip;
8746: l_bill_to_country := c_hz_locations_rec.loc_country;

Line 8743: l_bill_to_city := c_hz_locations_rec.loc_city;

8739: /* Bill to Location id using invoice_to_party_site_id */
8740:
8741: FOR c_hz_locations_rec IN c_hz_locations(g_quote_header_rec.invoice_to_party_site_id) LOOP
8742: l_bill_to_address := c_hz_locations_rec.loc_address;
8743: l_bill_to_city := c_hz_locations_rec.loc_city;
8744: l_bill_to_state := c_hz_locations_rec.loc_state;
8745: l_bill_to_zip := c_hz_locations_rec.loc_zip;
8746: l_bill_to_country := c_hz_locations_rec.loc_country;
8747:

Line 8744: l_bill_to_state := c_hz_locations_rec.loc_state;

8740:
8741: FOR c_hz_locations_rec IN c_hz_locations(g_quote_header_rec.invoice_to_party_site_id) LOOP
8742: l_bill_to_address := c_hz_locations_rec.loc_address;
8743: l_bill_to_city := c_hz_locations_rec.loc_city;
8744: l_bill_to_state := c_hz_locations_rec.loc_state;
8745: l_bill_to_zip := c_hz_locations_rec.loc_zip;
8746: l_bill_to_country := c_hz_locations_rec.loc_country;
8747:
8748: END LOOP;

Line 8745: l_bill_to_zip := c_hz_locations_rec.loc_zip;

8741: FOR c_hz_locations_rec IN c_hz_locations(g_quote_header_rec.invoice_to_party_site_id) LOOP
8742: l_bill_to_address := c_hz_locations_rec.loc_address;
8743: l_bill_to_city := c_hz_locations_rec.loc_city;
8744: l_bill_to_state := c_hz_locations_rec.loc_state;
8745: l_bill_to_zip := c_hz_locations_rec.loc_zip;
8746: l_bill_to_country := c_hz_locations_rec.loc_country;
8747:
8748: END LOOP;
8749:

Line 8746: l_bill_to_country := c_hz_locations_rec.loc_country;

8742: l_bill_to_address := c_hz_locations_rec.loc_address;
8743: l_bill_to_city := c_hz_locations_rec.loc_city;
8744: l_bill_to_state := c_hz_locations_rec.loc_state;
8745: l_bill_to_zip := c_hz_locations_rec.loc_zip;
8746: l_bill_to_country := c_hz_locations_rec.loc_country;
8747:
8748: END LOOP;
8749:
8750: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 8831: FOR c_hz_locations_rec IN c_hz_locations(l_ship_to_site_id) LOOP

8827: l_ship_to_state := null;
8828: l_ship_to_zip := null;
8829: l_ship_to_country := null;
8830:
8831: FOR c_hz_locations_rec IN c_hz_locations(l_ship_to_site_id) LOOP
8832:
8833: l_ship_to_address := c_hz_locations_rec.loc_address;
8834: l_ship_to_city := c_hz_locations_rec.loc_city;
8835: l_ship_to_state := c_hz_locations_rec.loc_state;

Line 8833: l_ship_to_address := c_hz_locations_rec.loc_address;

8829: l_ship_to_country := null;
8830:
8831: FOR c_hz_locations_rec IN c_hz_locations(l_ship_to_site_id) LOOP
8832:
8833: l_ship_to_address := c_hz_locations_rec.loc_address;
8834: l_ship_to_city := c_hz_locations_rec.loc_city;
8835: l_ship_to_state := c_hz_locations_rec.loc_state;
8836: l_ship_to_zip := c_hz_locations_rec.loc_zip;
8837: l_ship_to_country := c_hz_locations_rec.loc_country;

Line 8834: l_ship_to_city := c_hz_locations_rec.loc_city;

8830:
8831: FOR c_hz_locations_rec IN c_hz_locations(l_ship_to_site_id) LOOP
8832:
8833: l_ship_to_address := c_hz_locations_rec.loc_address;
8834: l_ship_to_city := c_hz_locations_rec.loc_city;
8835: l_ship_to_state := c_hz_locations_rec.loc_state;
8836: l_ship_to_zip := c_hz_locations_rec.loc_zip;
8837: l_ship_to_country := c_hz_locations_rec.loc_country;
8838:

Line 8835: l_ship_to_state := c_hz_locations_rec.loc_state;

8831: FOR c_hz_locations_rec IN c_hz_locations(l_ship_to_site_id) LOOP
8832:
8833: l_ship_to_address := c_hz_locations_rec.loc_address;
8834: l_ship_to_city := c_hz_locations_rec.loc_city;
8835: l_ship_to_state := c_hz_locations_rec.loc_state;
8836: l_ship_to_zip := c_hz_locations_rec.loc_zip;
8837: l_ship_to_country := c_hz_locations_rec.loc_country;
8838:
8839: END LOOP;

Line 8836: l_ship_to_zip := c_hz_locations_rec.loc_zip;

8832:
8833: l_ship_to_address := c_hz_locations_rec.loc_address;
8834: l_ship_to_city := c_hz_locations_rec.loc_city;
8835: l_ship_to_state := c_hz_locations_rec.loc_state;
8836: l_ship_to_zip := c_hz_locations_rec.loc_zip;
8837: l_ship_to_country := c_hz_locations_rec.loc_country;
8838:
8839: END LOOP;
8840:

Line 8837: l_ship_to_country := c_hz_locations_rec.loc_country;

8833: l_ship_to_address := c_hz_locations_rec.loc_address;
8834: l_ship_to_city := c_hz_locations_rec.loc_city;
8835: l_ship_to_state := c_hz_locations_rec.loc_state;
8836: l_ship_to_zip := c_hz_locations_rec.loc_zip;
8837: l_ship_to_country := c_hz_locations_rec.loc_country;
8838:
8839: END LOOP;
8840:
8841: