View: AR_CONS_INV_DRAFT_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_CONS_INV_DRAFT_V

View Text

SELECT CV.CONS_BILLING_NUMBER
, CV.ORG_ID
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 30) CUSTOMER_NAME
, CV.SITE_USE_ID
, CV.CUSTOMER_ID
FROM AR_CONS_INV CV
, HZ_CUST_ACCOUNTS C
, HZ_PARTIES PARTY
WHERE C.CUST_ACCOUNT_ID = CV.CUSTOMER_ID
AND C.PARTY_ID = PARTY.PARTY_ID
AND CV.STATUS = 'DRAFT'

Columns