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_CONTRACT_TERMS_INT dependencies on ASO_QUOTE_HEADERS_ALL

Line 67: FROM aso_quote_headers_all quote

63: IS
64: SELECT quote.contract_id, quote.quote_number, quote.cust_party_id, quote.cust_account_id,
65: quote.quote_version, quote.party_id, quote.resource_id,
66: quote.currency_code, quote.org_id
67: FROM aso_quote_headers_all quote
68: WHERE quote.quote_header_id = p_doc_id;
69:
70: CURSOR c_qte_payments_variable
71: IS

Line 73: FROM aso_quote_headers_all quote, aso_payments payments

69:
70: CURSOR c_qte_payments_variable
71: IS
72: SELECT payments.cust_po_number, payments.payment_term_id
73: FROM aso_quote_headers_all quote, aso_payments payments
74: WHERE quote.quote_header_id = payments.quote_header_id
75: AND payments.quote_line_id IS NULL
76: AND quote.quote_header_id = p_doc_id;
77:

Line 81: FROM aso_quote_headers_all quote, aso_shipments shipments

77:
78: CURSOR c_qte_shipments_variables
79: IS
80: SELECT shipments.freight_terms_code, shipments.ship_method_code
81: FROM aso_quote_headers_all quote, aso_shipments shipments
82: WHERE quote.quote_header_id = shipments.quote_header_id
83: AND shipments.quote_line_id IS NULL
84: AND quote.quote_header_id = p_doc_id;
85:

Line 545: FROM aso_quote_headers_all quote, aso_quote_statuses_b status

541: CURSOR c_quote_header
542: IS
543: SELECT status.update_allowed_flag, quote.quote_expiration_date,
544: quote.max_version_flag, quote.price_request_id
545: FROM aso_quote_headers_all quote, aso_quote_statuses_b status
546: WHERE quote.quote_header_id = p_doc_id
547: AND quote.quote_status_id = status.quote_status_id;
548:
549: BEGIN