VIEW: APPS.QPFV_AGREEMENTS

Source

View Text - Preformatted

SELECT ag. NAME ,ag.PRICE_LIST_ID ,ag.TERM_ID ,ag.OVERRIDE_IRULE_FLAG ,ag.OVERRIDE_ARULE_FLAG ,ag.SIGNATURE_DATE ,ag.AGREEMENT_NUM ,ag.REVISION ,ag.REVISION_DATE ,ag.INVOICING_RULE_ID ,ag.ACCOUNTING_RULE_ID ,ag.PURCHASE_ORDER_NUM ,ag.INVOICE_CONTACT_ID ,ag.AGREEMENT_CONTACT_ID ,ag.SALESREP_ID ,ag.START_DATE_ACTIVE ,ag.END_DATE_ACTIVE ,ag.TP_ATTRIBUTE_CATEGORY ,ag.INVOICE_TO_ORG_ID ,ag.SOLD_TO_ORG_ID ,tl. NAME ,ag.REVISION_REASON_CODE ,'_LA:ag.REVISION_REASON_CODE:QP_LOOKUPS:QP_REVISION_REASON_CODE:MEANING' ,ag.FREIGHT_TERMS_CODE ,freight.FREIGHT_TERMS ,ag.SHIP_METHOD_CODE ,ship.MEANING ,ag.AGREEMENT_TYPE_CODE ,'_LA:ag.AGREEMENT_TYPE_CODE:QP_LOOKUPS:QP_AGREEMENT_TYPE:MEANING' ,ag.AGREEMENT_ID ,ag.CREATION_DATE ,ag.CREATED_BY ,ag.LAST_UPDATE_DATE ,ag.LAST_UPDATED_BY , '_DF:QP:OE_AGREEMENTS:ag' , party.party_name customer_name , cust_acct.account_number customer_number ,ag.agreement_source_code ,ag.orig_system_agr_id FROM oe_agreements_b ag, oe_agreements_tl tl, oe_ship_methods_v ship, oe_frght_terms_active_v freight, hz_cust_accounts cust_acct, hz_parties party WHERE ag.agreement_id = tl.agreement_id and tl.language = userenv('lang') and ag.ship_method_code = ship.lookup_code (+) and ag.freight_terms_code = freight.freight_terms_code (+) and party.party_id(+) = cust_acct.party_id and cust_acct.cust_account_id(+) = ag.sold_to_org_id WITH READ ONLY

View Text - HTML Formatted

SELECT AG. NAME
, AG.PRICE_LIST_ID
, AG.TERM_ID
, AG.OVERRIDE_IRULE_FLAG
, AG.OVERRIDE_ARULE_FLAG
, AG.SIGNATURE_DATE
, AG.AGREEMENT_NUM
, AG.REVISION
, AG.REVISION_DATE
, AG.INVOICING_RULE_ID
, AG.ACCOUNTING_RULE_ID
, AG.PURCHASE_ORDER_NUM
, AG.INVOICE_CONTACT_ID
, AG.AGREEMENT_CONTACT_ID
, AG.SALESREP_ID
, AG.START_DATE_ACTIVE
, AG.END_DATE_ACTIVE
, AG.TP_ATTRIBUTE_CATEGORY
, AG.INVOICE_TO_ORG_ID
, AG.SOLD_TO_ORG_ID
, TL. NAME
, AG.REVISION_REASON_CODE
, '_LA:AG.REVISION_REASON_CODE:QP_LOOKUPS:QP_REVISION_REASON_CODE:MEANING'
, AG.FREIGHT_TERMS_CODE
, FREIGHT.FREIGHT_TERMS
, AG.SHIP_METHOD_CODE
, SHIP.MEANING
, AG.AGREEMENT_TYPE_CODE
, '_LA:AG.AGREEMENT_TYPE_CODE:QP_LOOKUPS:QP_AGREEMENT_TYPE:MEANING'
, AG.AGREEMENT_ID
, AG.CREATION_DATE
, AG.CREATED_BY
, AG.LAST_UPDATE_DATE
, AG.LAST_UPDATED_BY
, '_DF:QP:OE_AGREEMENTS:AG'
, PARTY.PARTY_NAME CUSTOMER_NAME
, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
, AG.AGREEMENT_SOURCE_CODE
, AG.ORIG_SYSTEM_AGR_ID
FROM OE_AGREEMENTS_B AG
, OE_AGREEMENTS_TL TL
, OE_SHIP_METHODS_V SHIP
, OE_FRGHT_TERMS_ACTIVE_V FREIGHT
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
WHERE AG.AGREEMENT_ID = TL.AGREEMENT_ID
AND TL.LANGUAGE = USERENV('LANG')
AND AG.SHIP_METHOD_CODE = SHIP.LOOKUP_CODE (+)
AND AG.FREIGHT_TERMS_CODE = FREIGHT.FREIGHT_TERMS_CODE (+)
AND PARTY.PARTY_ID(+) = CUST_ACCT.PARTY_ID
AND CUST_ACCT.CUST_ACCOUNT_ID(+) = AG.SOLD_TO_ORG_ID WITH READ ONLY