VIEW: APPS.OKX_AGREEMENTS_V

Source

View Text - Preformatted

SELECT B.AGREEMENT_ID AGREEMENT_ID, B.PRICE_LIST_ID PRICE_LIST_ID, B.AGREEMENT_NUM AGREEMENT_NUM, B.INVOICING_RULE_ID INVOICING_RULE, B.ACCOUNTING_RULE_ID ACCOUNTING_RULE, B.SOLD_TO_ORG_ID CUSTOMER_ID, B.START_DATE_ACTIVE START_DATE_ACTIVE, B.END_DATE_ACTIVE END_DATE_ACTIVE, TL.NAME NAME, B.AGREEMENT_TYPE_CODE DESCRIPTION, DECODE(SIGN(TRUNC(sysdate) - TRUNC(NVL(B.START_DATE_ACTIVE,sysdate))),-1,'I', DECODE(SIGN(TRUNC(sysdate) - TRUNC(NVL(B.END_DATE_ACTIVE,sysdate))),1,'I','A')) STATUS FROM OE_AGREEMENTS_B B,OE_AGREEMENTS_TL TL WHERE B.AGREEMENT_ID = TL.AGREEMENT_ID and TL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.AGREEMENT_ID AGREEMENT_ID
, B.PRICE_LIST_ID PRICE_LIST_ID
, B.AGREEMENT_NUM AGREEMENT_NUM
, B.INVOICING_RULE_ID INVOICING_RULE
, B.ACCOUNTING_RULE_ID ACCOUNTING_RULE
, B.SOLD_TO_ORG_ID CUSTOMER_ID
, B.START_DATE_ACTIVE START_DATE_ACTIVE
, B.END_DATE_ACTIVE END_DATE_ACTIVE
, TL.NAME NAME
, B.AGREEMENT_TYPE_CODE DESCRIPTION
, DECODE(SIGN(TRUNC(SYSDATE) - TRUNC(NVL(B.START_DATE_ACTIVE
, SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - TRUNC(NVL(B.END_DATE_ACTIVE
, SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
FROM OE_AGREEMENTS_B B
, OE_AGREEMENTS_TL TL
WHERE B.AGREEMENT_ID = TL.AGREEMENT_ID
AND TL.LANGUAGE = USERENV('LANG')