[Home] [Help]
[Dependency Information]
[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;
APPS
HZ_CONTACT_POINTS
HZ_PARTIES
APPS
JTF_TASK_UTL
- show dependent code
|
|
|
|