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_SOURCING_PVT dependencies on ASO_SHIPMENTS

Line 56: FROM aso_quote_headers_all qh, aso_shipments qs

52: l_ship_to_cust_account_id NUMBER;
53:
54: CURSOR C_get_quote_info (l_quote_header_id NUMBER) IS
55: SELECT qh.cust_account_id, qs.ship_to_party_site_id,qs.ship_to_cust_account_id
56: FROM aso_quote_headers_all qh, aso_shipments qs
57: WHERE qh.quote_header_id = qs.quote_header_id
58: AND qh.quote_header_id = l_quote_header_id
59: AND qs.quote_line_id is NULL;
60:

Line 121: FROM aso_quote_headers_all qh, aso_shipments qs, aso_quote_lines_all ql

117: l_quote_header_id number;
118: CURSOR C_get_quote_info (l_quote_line_id NUMBER) IS
119: SELECT qh.cust_account_id, qs.ship_to_party_site_id,
120: qs.ship_to_cust_account_id,qh.quote_header_id
121: FROM aso_quote_headers_all qh, aso_shipments qs, aso_quote_lines_all ql
122: WHERE qh.quote_header_id = qs.quote_header_id
123: AND ql.quote_header_id = qh.quote_header_id
124: AND ql.quote_line_id = l_quote_line_id
125: AND ql.quote_line_id = qs.quote_line_id;

Line 313: FROM aso_shipments qs

309: RETURN NUMBER
310: IS
311: CURSOR C_get_quote_info (l_quote_header_id NUMBER) IS
312: SELECT qs.ship_to_party_site_id
313: FROM aso_shipments qs
314: WHERE qs.quote_header_id = l_quote_header_id
315: AND qs.quote_line_id is NULL;
316:
317: x_ship_party_site_id NUMBER := NULL;

Line 342: FROM aso_shipments qs

338: RETURN NUMBER
339: IS
340: CURSOR C_get_quote_info (l_quote_line_id NUMBER) IS
341: SELECT qs.ship_to_party_site_id
342: FROM aso_shipments qs
343: WHERE qs.quote_line_id = l_quote_line_id;
344:
345: x_ship_party_site_id NUMBER;
346:

Line 678: Cursor get_req_date is SELECT request_date from aso_shipments

674: p_qte_header_id number
675: ) RETURN DATE
676: IS
677:
678: Cursor get_req_date is SELECT request_date from aso_shipments
679: WHERE
680: quote_header_id = p_qte_header_id and quote_line_id is NULL;
681: l_request_date DATE;
682: x_request_date DATE;

Line 697: Cursor get_req_date is SELECT request_date from aso_shipments

693: p_qte_line_id number
694: ) RETURN DATE
695: IS
696:
697: Cursor get_req_date is SELECT request_date from aso_shipments
698: WHERE quote_line_id = p_qte_line_id ;
699: l_request_date DATE;
700: x_request_date DATE;
701: BEGIN

Line 716: Cursor get_frieght is SELECT FREIGHT_TERMS_CODE from aso_shipments

712: p_qte_header_id number
713: ) RETURN DATE
714: IS
715:
716: Cursor get_frieght is SELECT FREIGHT_TERMS_CODE from aso_shipments
717: WHERE
718: quote_header_id = p_qte_header_id and quote_line_id is NULL;
719: l_freight_terms_code VARCHAR2(30);
720: BEGIN

Line 732: Cursor get_frieght is SELECT FREIGHT_TERMS_CODE from aso_shipments

728: p_qte_line_id number
729: ) RETURN VARCHAR2
730: IS
731:
732: Cursor get_frieght is SELECT FREIGHT_TERMS_CODE from aso_shipments
733: WHERE
734: quote_line_id = p_qte_line_id;
735: l_freight_terms_code VARCHAR2(30);
736: BEGIN

Line 806: FROM aso_shipments qs

802: RETURN VARCHAR2
803: IS
804: CURSOR C_line_freight_terms_code IS
805: SELECT qs.freight_terms_code
806: FROM aso_shipments qs
807: WHERE qs.quote_line_id = p_qte_line_id
808: and qs.freight_terms_code is not null;
809:
810: CURSOR C_hdr_freight_terms_code IS

Line 812: FROM aso_shipments qs, aso_quote_lines_all ql

808: and qs.freight_terms_code is not null;
809:
810: CURSOR C_hdr_freight_terms_code IS
811: SELECT qs.freight_terms_code
812: FROM aso_shipments qs, aso_quote_lines_all ql
813: WHERE qs.quote_header_id = ql.quote_header_id
814: and ql.quote_line_id = p_qte_line_id
815: and qs.quote_line_id IS NULL;
816:

Line 871: FROM aso_shipments qs

867: RETURN VARCHAR2
868: IS
869: CURSOR C_line_ship_method_code IS
870: SELECT qs.ship_method_code
871: FROM aso_shipments qs
872: WHERE qs.quote_line_id = p_qte_line_id
873: and qs.ship_method_code is not null;
874:
875: CURSOR C_hdr_ship_method_code IS

Line 877: FROM aso_shipments qs, aso_quote_lines_all ql

873: and qs.ship_method_code is not null;
874:
875: CURSOR C_hdr_ship_method_code IS
876: SELECT qs.ship_method_code
877: FROM aso_shipments qs, aso_quote_lines_all ql
878: WHERE qs.quote_header_id = ql.quote_header_id
879: and ql.quote_line_id = p_qte_line_id
880: and qs.quote_line_id IS NULL;
881: