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.ASO_WORKFLOW_QUOTE_PVT dependencies on ASO_SHIPMENTS

Line 400: l_ship_to_site_id aso_shipments.ship_to_party_site_id%TYPE;

396: l_bill_to_city hz_locations.city%TYPE;
397: l_bill_to_state hz_locations.state%TYPE;
398: l_bill_to_zip hz_locations.postal_code%TYPE;
399: l_bill_to_country hz_locations.country%TYPE;
400: l_ship_to_site_id aso_shipments.ship_to_party_site_id%TYPE;
401: l_ship_to_party_id aso_shipments.ship_to_party_id%TYPE;
402: l_ship_to_cust_account_id aso_shipments.ship_to_cust_account_id%TYPE;
403: l_ship_method_code aso_shipments.ship_method_code%TYPE;
404:

Line 401: l_ship_to_party_id aso_shipments.ship_to_party_id%TYPE;

397: l_bill_to_state hz_locations.state%TYPE;
398: l_bill_to_zip hz_locations.postal_code%TYPE;
399: l_bill_to_country hz_locations.country%TYPE;
400: l_ship_to_site_id aso_shipments.ship_to_party_site_id%TYPE;
401: l_ship_to_party_id aso_shipments.ship_to_party_id%TYPE;
402: l_ship_to_cust_account_id aso_shipments.ship_to_cust_account_id%TYPE;
403: l_ship_method_code aso_shipments.ship_method_code%TYPE;
404:
405: l_ship_method varchar2(80);

Line 402: l_ship_to_cust_account_id aso_shipments.ship_to_cust_account_id%TYPE;

398: l_bill_to_zip hz_locations.postal_code%TYPE;
399: l_bill_to_country hz_locations.country%TYPE;
400: l_ship_to_site_id aso_shipments.ship_to_party_site_id%TYPE;
401: l_ship_to_party_id aso_shipments.ship_to_party_id%TYPE;
402: l_ship_to_cust_account_id aso_shipments.ship_to_cust_account_id%TYPE;
403: l_ship_method_code aso_shipments.ship_method_code%TYPE;
404:
405: l_ship_method varchar2(80);
406:

Line 403: l_ship_method_code aso_shipments.ship_method_code%TYPE;

399: l_bill_to_country hz_locations.country%TYPE;
400: l_ship_to_site_id aso_shipments.ship_to_party_site_id%TYPE;
401: l_ship_to_party_id aso_shipments.ship_to_party_id%TYPE;
402: l_ship_to_cust_account_id aso_shipments.ship_to_cust_account_id%TYPE;
403: l_ship_method_code aso_shipments.ship_method_code%TYPE;
404:
405: l_ship_method varchar2(80);
406:
407: l_ship_to_party_name hz_parties.party_name%TYPE;

Line 429: Cursor c_aso_shipments(p_quote_id NUMBER) IS

425: FROM hz_locations
426: WHERE location_id = ( SELECT location_id
427: FROM hz_party_sites
428: WHERE party_site_id = p_loc_site_id);
429: Cursor c_aso_shipments(p_quote_id NUMBER) IS
430: SELECT ship_to_cust_account_id, ship_to_party_site_id, ship_to_party_id, ship_method_code
431: FROM aso_shipments
432: WHERE quote_header_id = p_quote_id
433: AND quote_line_id IS NULL

Line 431: FROM aso_shipments

427: FROM hz_party_sites
428: WHERE party_site_id = p_loc_site_id);
429: Cursor c_aso_shipments(p_quote_id NUMBER) IS
430: SELECT ship_to_cust_account_id, ship_to_party_site_id, ship_to_party_id, ship_method_code
431: FROM aso_shipments
432: WHERE quote_header_id = p_quote_id
433: AND quote_line_id IS NULL
434: AND rownum = 1;
435:

Line 650: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id)

646: l_ship_to_site_id := null;
647: l_ship_to_party_id := null;
648: l_ship_method_code := null;
649:
650: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id)
651: LOOP
652: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;
653: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;
654: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;

Line 652: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;

648: l_ship_method_code := null;
649:
650: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id)
651: LOOP
652: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;
653: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;
654: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;
655: l_ship_method_code := c_aso_shipments_rec.ship_method_code;
656: END LOOP;

Line 653: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;

649:
650: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id)
651: LOOP
652: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;
653: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;
654: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;
655: l_ship_method_code := c_aso_shipments_rec.ship_method_code;
656: END LOOP;
657:

Line 654: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;

650: FOR c_aso_shipments_rec IN c_aso_shipments(l_quote_id)
651: LOOP
652: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;
653: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;
654: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;
655: l_ship_method_code := c_aso_shipments_rec.ship_method_code;
656: END LOOP;
657:
658: FOR c_ship_method_rec in c_ship_methods(l_ship_method_code)

Line 655: l_ship_method_code := c_aso_shipments_rec.ship_method_code;

651: LOOP
652: l_ship_to_site_id := c_aso_shipments_rec.ship_to_party_site_id;
653: l_ship_to_cust_account_id := c_aso_shipments_rec.ship_to_cust_account_id;
654: l_ship_to_party_id := c_aso_shipments_rec.ship_to_party_id;
655: l_ship_method_code := c_aso_shipments_rec.ship_method_code;
656: END LOOP;
657:
658: FOR c_ship_method_rec in c_ship_methods(l_ship_method_code)
659: LOOP