VIEW: APPS.QPBV_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 ,ag.FREIGHT_TERMS_CODE ,ag.SHIP_METHOD_CODE ,ag.AGREEMENT_TYPE_CODE ,ag.AGREEMENT_ID ,ag.CREATION_DATE ,ag.CREATED_BY ,ag.LAST_UPDATE_DATE ,ag.LAST_UPDATED_BY ,ag.AGREEMENT_SOURCE_CODE ,ag.ORIG_SYSTEM_AGR_ID FROM oe_agreements_b ag, oe_agreements_tl tl WHERE ag.agreement_id = tl.agreement_id and tl.language = userenv('lang')

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
, AG.FREIGHT_TERMS_CODE
, AG.SHIP_METHOD_CODE
, AG.AGREEMENT_TYPE_CODE
, AG.AGREEMENT_ID
, AG.CREATION_DATE
, AG.CREATED_BY
, AG.LAST_UPDATE_DATE
, AG.LAST_UPDATED_BY
, AG.AGREEMENT_SOURCE_CODE
, AG.ORIG_SYSTEM_AGR_ID
FROM OE_AGREEMENTS_B AG
, OE_AGREEMENTS_TL TL
WHERE AG.AGREEMENT_ID = TL.AGREEMENT_ID
AND TL.LANGUAGE = USERENV('LANG')