[Home] [Help]
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
Name |
CUST_ID |
ASSOC_TYPE |
ASSOCCUST_ID |
ASSOCCUST_NO |
ASSOCCUST_NAME |
DELETE_MARK |
TRANS_CNT |
TEXT_CODE |