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.

VIEW: APPS.OEFV_ORDER_AGREEMENTS

Source

View Text - Preformatted


SELECT AGREEMENT.AGREEMENT_NUM , T.NAME , '_LA:AGREEMENT_TYPE_CODE:QP_LOOKUPS:QP_AGREEMENT_TYPE:MEANING' , '_LA:OVERRIDE_ARULE_FLAG:OE_LOOKUPS:YES_NO:MEANING' , '_LA:OVERRIDE_IRULE_FLAG:OE_LOOKUPS:YES_NO:MEANING' , AGREEMENT.START_DATE_ACTIVE , AGREEMENT.END_DATE_ACTIVE , AGREEMENT.SIGNATURE_DATE , AGREEMENT.PURCHASE_ORDER_NUM , '_DF:QP:OE_AGREEMENTS:AGREEMENT' , RULE1.NAME , RULE2.NAME , INVOICE_SITE_USE.LOCATION , INVOICE_TO_ADDR2.ADDRESS1 , INVOICE_TO_ADDR2.ADDRESS2 , INVOICE_TO_ADDR2.ADDRESS3 , INVOICE_TO_ADDR2.ADDRESS4 , INVOICE_TO_ADDR2.CITY , INVOICE_TO_ADDR2.STATE , INVOICE_TO_ADDR2.POSTAL_CODE , INVOICE_TO_ADDR2.PROVINCE , INVOICE_TO_ADDR2.COUNTY , INVOICE_TO_ADDR2.COUNTRY , OE_BIS_SALESPERSON.GET_SALESPERSON_NAME(AGREEMENT.SALESREP_ID) SALESREP_NAME , TERM.NAME , PRICE_LIST.NAME , AGREEMENT.AGREEMENT_ID , AGREEMENT.INVOICE_CONTACT_ID , AGREEMENT.AGREEMENT_CONTACT_ID , AGREEMENT.SOLD_TO_ORG_ID , AGREEMENT.INVOICING_RULE_ID , AGREEMENT.ACCOUNTING_RULE_ID , AGREEMENT.SALESREP_ID , AGREEMENT.INVOICE_TO_ORG_ID , INVOICE_SITE_USE.CUST_ACCT_SITE_ID , AGREEMENT.TERM_ID , AGREEMENT.PRICE_LIST_ID , AGREEMENT.LAST_UPDATE_DATE , AGREEMENT.LAST_UPDATED_BY , AGREEMENT.CREATION_DATE , AGREEMENT.CREATED_BY, AGREEMENT.REVISION FROM OE_AGREEMENTS_B AGREEMENT , OE_AGREEMENTS_TL T, RA_RULES RULE1 , RA_RULES RULE2 , HZ_CUST_SITE_USES_ALL INVOICE_SITE_USE , HZ_PARTY_SITES INVOICE_TO_ADDR1, HZ_LOCATIONS INVOICE_TO_ADDR2, HZ_CUST_ACCT_SITES_ALL INVOICE_TO_ADDR3, RA_TERMS_TL TERM , QP_LIST_HEADERS_TL PRICE_LIST WHERE AGREEMENT.AGREEMENT_ID = T.AGREEMENT_ID AND T.LANGUAGE = userenv('LANG') AND AGREEMENT.INVOICING_RULE_ID = RULE1.RULE_ID(+) AND AGREEMENT.ACCOUNTING_RULE_ID = RULE2.RULE_ID(+) AND AGREEMENT.INVOICE_TO_ORG_ID = INVOICE_SITE_USE.SITE_USE_ID(+) AND INVOICE_SITE_USE.CUST_ACCT_SITE_ID = INVOICE_TO_ADDR3.CUST_ACCT_SITE_ID(+) AND INVOICE_TO_ADDR3.PARTY_SITE_ID = INVOICE_TO_ADDR1.PARTY_SITE_ID(+) AND INVOICE_TO_ADDR2.LOCATION_ID(+) = INVOICE_TO_ADDR1.LOCATION_ID AND AGREEMENT.TERM_ID = TERM.TERM_ID(+) AND AGREEMENT.PRICE_LIST_ID = PRICE_LIST.LIST_HEADER_ID AND TERM.language(+) = userenv('LANG') AND PRICE_LIST.language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT AGREEMENT.AGREEMENT_NUM
, T.NAME
, '_LA:AGREEMENT_TYPE_CODE:QP_LOOKUPS:QP_AGREEMENT_TYPE:MEANING'
, '_LA:OVERRIDE_ARULE_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, '_LA:OVERRIDE_IRULE_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, AGREEMENT.START_DATE_ACTIVE
, AGREEMENT.END_DATE_ACTIVE
, AGREEMENT.SIGNATURE_DATE
, AGREEMENT.PURCHASE_ORDER_NUM
, '_DF:QP:OE_AGREEMENTS:AGREEMENT'
, RULE1.NAME
, RULE2.NAME
, INVOICE_SITE_USE.LOCATION
, INVOICE_TO_ADDR2.ADDRESS1
, INVOICE_TO_ADDR2.ADDRESS2
, INVOICE_TO_ADDR2.ADDRESS3
, INVOICE_TO_ADDR2.ADDRESS4
, INVOICE_TO_ADDR2.CITY
, INVOICE_TO_ADDR2.STATE
, INVOICE_TO_ADDR2.POSTAL_CODE
, INVOICE_TO_ADDR2.PROVINCE
, INVOICE_TO_ADDR2.COUNTY
, INVOICE_TO_ADDR2.COUNTRY
, OE_BIS_SALESPERSON.GET_SALESPERSON_NAME(AGREEMENT.SALESREP_ID) SALESREP_NAME
, TERM.NAME
, PRICE_LIST.NAME
, AGREEMENT.AGREEMENT_ID
, AGREEMENT.INVOICE_CONTACT_ID
, AGREEMENT.AGREEMENT_CONTACT_ID
, AGREEMENT.SOLD_TO_ORG_ID
, AGREEMENT.INVOICING_RULE_ID
, AGREEMENT.ACCOUNTING_RULE_ID
, AGREEMENT.SALESREP_ID
, AGREEMENT.INVOICE_TO_ORG_ID
, INVOICE_SITE_USE.CUST_ACCT_SITE_ID
, AGREEMENT.TERM_ID
, AGREEMENT.PRICE_LIST_ID
, AGREEMENT.LAST_UPDATE_DATE
, AGREEMENT.LAST_UPDATED_BY
, AGREEMENT.CREATION_DATE
, AGREEMENT.CREATED_BY
, AGREEMENT.REVISION
FROM OE_AGREEMENTS_B AGREEMENT
, OE_AGREEMENTS_TL T
, RA_RULES RULE1
, RA_RULES RULE2
, HZ_CUST_SITE_USES_ALL INVOICE_SITE_USE
, HZ_PARTY_SITES INVOICE_TO_ADDR1
, HZ_LOCATIONS INVOICE_TO_ADDR2
, HZ_CUST_ACCT_SITES_ALL INVOICE_TO_ADDR3
, RA_TERMS_TL TERM
, QP_LIST_HEADERS_TL PRICE_LIST
WHERE AGREEMENT.AGREEMENT_ID = T.AGREEMENT_ID
AND T.LANGUAGE = USERENV('LANG')
AND AGREEMENT.INVOICING_RULE_ID = RULE1.RULE_ID(+)
AND AGREEMENT.ACCOUNTING_RULE_ID = RULE2.RULE_ID(+)
AND AGREEMENT.INVOICE_TO_ORG_ID = INVOICE_SITE_USE.SITE_USE_ID(+)
AND INVOICE_SITE_USE.CUST_ACCT_SITE_ID = INVOICE_TO_ADDR3.CUST_ACCT_SITE_ID(+)
AND INVOICE_TO_ADDR3.PARTY_SITE_ID = INVOICE_TO_ADDR1.PARTY_SITE_ID(+)
AND INVOICE_TO_ADDR2.LOCATION_ID(+) = INVOICE_TO_ADDR1.LOCATION_ID
AND AGREEMENT.TERM_ID = TERM.TERM_ID(+)
AND AGREEMENT.PRICE_LIST_ID = PRICE_LIST.LIST_HEADER_ID
AND TERM.LANGUAGE(+) = USERENV('LANG')
AND PRICE_LIST.LANGUAGE = USERENV('LANG') WITH READ ONLY