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 ASO_SHIPMENTS

Line 3871: l_ship_to_name aso_shipments_v.ship_to_cust_name%TYPE;

3867: l_last_name VARCHAR2(1000);
3868: l_contact_phone hz_contact_points.phone_number%TYPE;
3869: l_cart_name ibe_quote_headers_v.quote_name%TYPE;
3870: l_cart_date ibe_quote_headers_v.last_update_date%TYPE;
3871: l_ship_to_name aso_shipments_v.ship_to_cust_name%TYPE;
3872: l_address VARCHAR2(4000);
3873: l_address1 VARCHAR2(240);
3874: l_address2 VARCHAR2(240);
3875: l_address3 VARCHAR2(240);

Line 8542: l_ship_to_site_id aso_shipments.ship_to_party_site_id%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;
8546:

Line 8543: l_ship_to_party_id aso_shipments.ship_to_party_id%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;
8546:
8547: l_ship_method varchar2(80);

Line 8544: l_ship_to_cust_account_id aso_shipments.ship_to_cust_account_id%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;
8546:
8547: l_ship_method varchar2(80);
8548:

Line 8545: l_ship_method_code aso_shipments.ship_method_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;
8546:
8547: l_ship_method varchar2(80);
8548:
8549: l_ship_to_party_name hz_parties.party_name%TYPE;

Line 8571: Cursor c_aso_shipments(p_quote_id NUMBER) IS

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
8572: SELECT ship_to_cust_account_id, ship_to_party_site_id, ship_to_party_id, ship_method_code
8573: FROM aso_shipments
8574: WHERE quote_header_id = p_quote_id
8575: AND quote_line_id IS NULL

Line 8573: FROM aso_shipments

8569: FROM hz_party_sites
8570: WHERE party_site_id = p_loc_site_id);
8571: Cursor c_aso_shipments(p_quote_id NUMBER) IS
8572: SELECT ship_to_cust_account_id, ship_to_party_site_id, ship_to_party_id, ship_method_code
8573: FROM aso_shipments
8574: WHERE quote_header_id = p_quote_id
8575: AND quote_line_id IS NULL
8576: AND rownum = 1;
8577:

Line 8764: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id) LOOP

8760: l_ship_to_site_id := null;
8761: l_ship_to_party_id := null;
8762: l_ship_method_code := null;
8763:
8764: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id) LOOP
8765: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;
8766: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;
8767: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;
8768: l_ship_method_code := c_aso_shipments_rec.ship_method_code;

Line 8765: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;

8761: l_ship_to_party_id := null;
8762: l_ship_method_code := null;
8763:
8764: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id) LOOP
8765: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;
8766: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;
8767: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;
8768: l_ship_method_code := c_aso_shipments_rec.ship_method_code;
8769: END LOOP;

Line 8766: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;

8762: l_ship_method_code := null;
8763:
8764: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id) LOOP
8765: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;
8766: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;
8767: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;
8768: l_ship_method_code := c_aso_shipments_rec.ship_method_code;
8769: END LOOP;
8770:

Line 8767: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;

8763:
8764: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id) LOOP
8765: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;
8766: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;
8767: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;
8768: l_ship_method_code := c_aso_shipments_rec.ship_method_code;
8769: END LOOP;
8770:
8771: For c_ship_method_rec in c_ship_methods(l_ship_method_code) LOOP

Line 8768: l_ship_method_code := c_aso_shipments_rec.ship_method_code;

8764: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id) LOOP
8765: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;
8766: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;
8767: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;
8768: l_ship_method_code := c_aso_shipments_rec.ship_method_code;
8769: END LOOP;
8770:
8771: For c_ship_method_rec in c_ship_methods(l_ship_method_code) LOOP
8772: l_Ship_Method := c_ship_method_rec.Meaning;