[Home] [Help] [Dependency Information]
Object Name: | JTF_PARTY_CONT_POINTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JTF.JTF_PARTY_CONT_POINTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
JTF_PARTY_CONT_POINTS_V retrieves all contact points for parties without any restriction. Includes displaying certain party columns in the view like party type, party name, person first and last name.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTACT_POINT_ID | NUMBER | (15) | Yes | Contact point identifier |
PARTY_ID | NUMBER | (15) | Yes | Party identifier |
PARTY_NUMBER | VARCHAR2 | (30) | Yes | Unique identification number for this party |
PARTY_NAME | VARCHAR2 | (360) | Yes | Name of this party |
PERSON_FIRST_NAME | VARCHAR2 | (150) | First name of the person | |
PERSON_LAST_NAME | VARCHAR2 | (150) | Last or surname of the person | |
PARTY_TYPE | VARCHAR2 | (30) | Yes | The party type can only be Person, Organization, Group or Relationship. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
PHONE_NUMBER | VARCHAR2 | (40) | A telephone number formatted in the local format. The number should not include area code, country code, or extension. | |
STATUS | VARCHAR2 | (30) | Yes | Lookup: contact_point_status. Typically, active, inactive, delete. |
TELEPHONE_TYPE | VARCHAR2 | (30) | No Longer Used. | |
CONTACT_POINT_TYPE | VARCHAR2 | (30) | Yes | Contact point type, such as phone or e-mail. Valid value from COMMUNICATION_TYPE lookup type. |
PHONE_LINE_TYPE | VARCHAR2 | (30) | Lookup code for the type of phone line. For example, general, fax, inbound, or outbound. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
PHONE_COUNTRY_CODE | VARCHAR2 | (10) | International country code for a telephone number. For example, 33 for France. | |
PHONE_AREA_CODE | VARCHAR2 | (10) | The area code within a country code. | |
PHONE_EXTENSION | VARCHAR2 | (20) | Additional number addressed after initial connection to an internal telephone system. | |
PRIMARY_FLAG | VARCHAR2 | (1) | Indicates if this is the primary contact point of this contact point type for referenced party, site, or location. Y for primary contact, N for all others. | |
EMAIL_FORMAT | VARCHAR2 | (30) | Indicates the preferred format for e-mail addressed to this address. For example, HTML or ASCII. | |
EMAIL_ADDRESS | VARCHAR2 | (2000) | E-mail address of the contact point | |
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | Identifier for this record from foreign or legacy system. | |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
TIME_ZONE | NUMBER | Time zone expressed as the deviation or difference in hours from Greenwich Mean Time(GMT). | ||
EDI_TRANSACTION_HANDLING | VARCHAR2 | (25) | ANSI standard code for EDI transaction type | |
EDI_ID_NUMBER | VARCHAR2 | (30) | EDI trading partner number for the supplier site | |
EDI_PAYMENT_METHOD | VARCHAR2 | (30) | Indicates how a payment is to be made through EDI. Valid methods are ACH and BOP. | |
EDI_PAYMENT_FORMAT | VARCHAR2 | (30) | Indicates type of information being transmitted with the funds if using EDI_PAYMENT_METHOD ACH. Valid values are CCD, CCP, CHZ, CTX, PPD, and PPP. | |
EDI_REMITTANCE_METHOD | VARCHAR2 | (30) | Indicates how remittance advice are sent to the supplier. | |
EDI_REMITTANCE_INSTRUCTION | VARCHAR2 | (30) | Indicates who will send the remittance advice. Valid values are Banks or Payables systems. | |
EDI_TP_HEADER_ID | NUMBER | (15) | EDI transaction header unique identifier | |
EDI_ECE_TP_LOCATION_CODE | VARCHAR2 | (40) | Trading partner location code for EDI Gateway | |
BEST_TIME_TO_CONTACT_START | DATE | No Longer Used | ||
BEST_TIME_TO_CONTACT_END | DATE | No Longer Used | ||
URL | VARCHAR2 | (2000) | Uniform resource locator | |
WEB_TYPE | VARCHAR2 | (60) | The prefix class to a web address. Typically this is either FTP or HTTP. |
Cut, paste (and edit) the following text to query this object:
SELECT CONTACT_POINT_ID
, PARTY_ID
, PARTY_NUMBER
, PARTY_NAME
, PERSON_FIRST_NAME
, PERSON_LAST_NAME
, PARTY_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, PHONE_NUMBER
, STATUS
, TELEPHONE_TYPE
, CONTACT_POINT_TYPE
, PHONE_LINE_TYPE
, LAST_UPDATE_LOGIN
, PHONE_COUNTRY_CODE
, PHONE_AREA_CODE
, PHONE_EXTENSION
, PRIMARY_FLAG
, EMAIL_FORMAT
, EMAIL_ADDRESS
, ORIG_SYSTEM_REFERENCE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, TIME_ZONE
, EDI_TRANSACTION_HANDLING
, EDI_ID_NUMBER
, EDI_PAYMENT_METHOD
, EDI_PAYMENT_FORMAT
, EDI_REMITTANCE_METHOD
, EDI_REMITTANCE_INSTRUCTION
, EDI_TP_HEADER_ID
, EDI_ECE_TP_LOCATION_CODE
, BEST_TIME_TO_CONTACT_START
, BEST_TIME_TO_CONTACT_END
, URL
, WEB_TYPE
FROM APPS.JTF_PARTY_CONT_POINTS_V;
|
|
|