[Home] [Help]
View: OE_PRINT_CONT_POINTS_V
Product: | ONT - Order Management |
Description: | This view is used to print the details of the various modes of communication for the Customer Contact |
Implementation/DBA Data: |
APPS.OE_PRINT_CONT_POINTS_V
|
View Text
SELECT CONTACT_POINT_ID
, CONTACT_POINT_TYPE
, STATUS
, OWNER_TABLE_NAME
, OWNER_TABLE_ID
, PRIMARY_FLAG
, PHONE_COUNTRY_CODE
, PHONE_AREA_CODE
, PHONE_NUMBER
, PHONE_EXTENSION
, PHONE_LINE_TYPE
, TELEX_NUMBER
, WEB_TYPE
, URL
FROM HZ_CONTACT_POINTS
WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
AND STATUS = 'A'
AND CONTACT_POINT_TYPE IN ('PHONE'
, 'WEB'
, 'TLX')
Columns
Name |
CONTACT_POINT_ID |
CONTACT_POINT_TYPE |
STATUS |
OWNER_TABLE_NAME |
OWNER_TABLE_ID |
PRIMARY_FLAG |
PHONE_COUNTRY_CODE |
PHONE_AREA_CODE |
PHONE_NUMBER |
PHONE_EXTENSION |
PHONE_LINE_TYPE |
TELEX_NUMBER |
WEB_TYPE |
URL |