VIEW: APPS.AR_CONS_INV_DRAFT_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'