View: OP_CUST_ASC_VW1

Product:	GML - Process Manufacturing Logistics
Description:	Customer Association View.
Implementation/DBA Data:	APPS.OP_CUST_ASC_VW1

View Text

SELECT A.CUST_ID
, ASSOC_TYPE
, ASSOCCUST_ID
, C.CUST_NO
, C.CUST_NAME
, A.DELETE_MARK
, A.TRANS_CNT
, A.TEXT_CODE
FROM OP_CUST_MST C
, OP_CUST_ASC A
WHERE ASSOCCUST_ID = C.CUST_ID
AND C.DELETE_MARK = 0

Columns