VIEW: APPS.OKX_RECEIPT_METHODS_V

Source

View Text - Preformatted

SELECT a.cust_receipt_method_id ID1, '#' ID2, b.name NAME, b.printed_name DESCRIPTION, a.CUSTOMER_ID CUSTOMER_ID, a.SITE_USE_ID SITE_USE_ID, a.RECEIPT_METHOD_ID RECEIPT_METHOD_ID, a.PRIMARY_FLAG PRIMARY_FLAG, a.START_DATE START_DATE_ACTIVE, a.END_DATE END_DATE_ACTIVE, DECODE(SIGN(trunc(sysdate)-NVL(A.start_date,trunc(sysdate))),-1,'I', DECODE(SIGN(trunc(sysdate) - NVL(A.end_date,trunc(sysdate))), 1,'I','A')) STATUS, NULL PRIMARY_UOM_CODE, b.receipt_class_id RECEIPT_CLASS_ID, b.lead_days LEAD_DAYS, b.payment_type_code PAYMENT_TYPE_CODE FROM AR_RECEIPT_METHODS B,RA_CUST_RECEIPT_METHODS A WHERE B.RECEIPT_METHOD_ID = A.RECEIPT_METHOD_ID

View Text - HTML Formatted

SELECT A.CUST_RECEIPT_METHOD_ID ID1
, '#' ID2
, B.NAME NAME
, B.PRINTED_NAME DESCRIPTION
, A.CUSTOMER_ID CUSTOMER_ID
, A.SITE_USE_ID SITE_USE_ID
, A.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, A.PRIMARY_FLAG PRIMARY_FLAG
, A.START_DATE START_DATE_ACTIVE
, A.END_DATE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(A.START_DATE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(A.END_DATE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, NULL PRIMARY_UOM_CODE
, B.RECEIPT_CLASS_ID RECEIPT_CLASS_ID
, B.LEAD_DAYS LEAD_DAYS
, B.PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE
FROM AR_RECEIPT_METHODS B
, RA_CUST_RECEIPT_METHODS A
WHERE B.RECEIPT_METHOD_ID = A.RECEIPT_METHOD_ID