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 3966: l_ship_to_name aso_shipments_v.ship_to_cust_name%TYPE;

3962: l_last_name VARCHAR2(1000);
3963: l_contact_phone hz_contact_points.phone_number%TYPE;
3964: l_cart_name ibe_quote_headers_v.quote_name%TYPE;
3965: l_cart_date ibe_quote_headers_v.last_update_date%TYPE;
3966: l_ship_to_name aso_shipments_v.ship_to_cust_name%TYPE;
3967: l_address VARCHAR2(4000);
3968: l_address1 VARCHAR2(240);
3969: l_address2 VARCHAR2(240);
3970: l_address3 VARCHAR2(240);

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

Line 8638: l_ship_to_party_id aso_shipments.ship_to_party_id%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;
8641:
8642: l_ship_method varchar2(80);

Line 8639: l_ship_to_cust_account_id aso_shipments.ship_to_cust_account_id%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;
8641:
8642: l_ship_method varchar2(80);
8643:

Line 8640: l_ship_method_code aso_shipments.ship_method_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;
8641:
8642: l_ship_method varchar2(80);
8643:
8644: l_ship_to_party_name hz_parties.party_name%TYPE;

Line 8666: Cursor c_aso_shipments(p_quote_id NUMBER) IS

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
8667: SELECT ship_to_cust_account_id, ship_to_party_site_id, ship_to_party_id, ship_method_code
8668: FROM aso_shipments
8669: WHERE quote_header_id = p_quote_id
8670: AND quote_line_id IS NULL

Line 8668: FROM aso_shipments

8664: FROM hz_party_sites
8665: WHERE party_site_id = p_loc_site_id);
8666: Cursor c_aso_shipments(p_quote_id NUMBER) IS
8667: SELECT ship_to_cust_account_id, ship_to_party_site_id, ship_to_party_id, ship_method_code
8668: FROM aso_shipments
8669: WHERE quote_header_id = p_quote_id
8670: AND quote_line_id IS NULL
8671: AND rownum = 1;
8672:

Line 8859: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id) LOOP

8855: l_ship_to_site_id := null;
8856: l_ship_to_party_id := null;
8857: l_ship_method_code := null;
8858:
8859: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id) LOOP
8860: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;
8861: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;
8862: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;
8863: l_ship_method_code := c_aso_shipments_rec.ship_method_code;

Line 8860: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;

8856: l_ship_to_party_id := null;
8857: l_ship_method_code := null;
8858:
8859: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id) LOOP
8860: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;
8861: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;
8862: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;
8863: l_ship_method_code := c_aso_shipments_rec.ship_method_code;
8864: END LOOP;

Line 8861: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;

8857: l_ship_method_code := null;
8858:
8859: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id) LOOP
8860: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;
8861: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;
8862: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;
8863: l_ship_method_code := c_aso_shipments_rec.ship_method_code;
8864: END LOOP;
8865:

Line 8862: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;

8858:
8859: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id) LOOP
8860: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;
8861: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;
8862: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;
8863: l_ship_method_code := c_aso_shipments_rec.ship_method_code;
8864: END LOOP;
8865:
8866: For c_ship_method_rec in c_ship_methods(l_ship_method_code) LOOP

Line 8863: l_ship_method_code := c_aso_shipments_rec.ship_method_code;

8859: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id) LOOP
8860: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;
8861: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;
8862: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;
8863: l_ship_method_code := c_aso_shipments_rec.ship_method_code;
8864: END LOOP;
8865:
8866: For c_ship_method_rec in c_ship_methods(l_ship_method_code) LOOP
8867: l_Ship_Method := c_ship_method_rec.Meaning;