[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OTA_FINANCE_HEADERS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OTA.OTA_FINANCE_HEADERS_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| FINANCE_HEADER_ID | NUMBER | (9) | Yes | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
| SUPERCEDING_HEADER_ID | NUMBER | (9) | ||
| AUTHORIZER_PERSON_ID | NUMBER | (10) | ||
| AUTHORIZER_PERSON_FULL_NAME | VARCHAR2 | (100) | ||
| ORGANIZATION_ID | NUMBER | (9) | Yes | |
| ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | |
| ADMINISTRATOR | NUMBER | Yes | ||
| ADMINISTRATOR_FULL_NAME | VARCHAR2 | (100) | Yes | |
| CANCELLED_FLAG | VARCHAR2 | (30) | Yes | |
| CURRENCY_CODE | VARCHAR2 | (30) | Yes | |
| INVOICE_FULL_AMOUNT | VARCHAR2 | (4000) | ||
| DATE_RAISED | DATE | Yes | ||
| PAYMENT_STATUS_FLAG | VARCHAR2 | (30) | Yes | |
| TRANSFER_STATUS | VARCHAR2 | (30) | Yes | |
| TRANSFER_STATUS_MEANING | VARCHAR2 | (4000) | ||
| TYPE | VARCHAR2 | (30) | Yes | |
| TYPE_MEANING | VARCHAR2 | (4000) | ||
| RECEIVABLE_TYPE | VARCHAR2 | (30) | ||
| COMMENTS | VARCHAR2 | (2000) | ||
| EXTERNAL_REFERENCE | VARCHAR2 | (30) | ||
| INVOICE_ADDRESS | VARCHAR2 | (2000) | ||
| INVOICE_CONTACT | VARCHAR2 | (240) | ||
| PAYMENT_METHOD | VARCHAR2 | (30) | ||
| PAYMENT_METHOD_MEANING | VARCHAR2 | (4000) | ||
| PYM_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| PYM_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| PYM_INFORMATION_CATEGORY | VARCHAR2 | (30) | ||
| TRANSFER_DATE | DATE | |||
| TRANSFER_MESSAGE | VARCHAR2 | (240) | ||
| VENDOR_ID | NUMBER | (15) | ||
| VENDOR_NAME | VARCHAR2 | (240) | ||
| CONTACT_ID | NUMBER | (15) | ||
| ADDRESS_ID | NUMBER | |||
| CUSTOMER_ID | NUMBER | (15) | ||
| CUSTOMER_NAME | VARCHAR2 | (50) | ||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| CREATED_BY | NUMBER | (15) | ||
| CREATION_DATE | DATE | |||
| TFH_INFORMATION_CATEGORY | VARCHAR2 | (30) | ||
| TFH_INFORMATION1 | VARCHAR2 | (150) | ||
| TFH_INFORMATION2 | VARCHAR2 | (150) | ||
| TFH_INFORMATION3 | VARCHAR2 | (150) | ||
| TFH_INFORMATION4 | VARCHAR2 | (150) | ||
| TFH_INFORMATION5 | VARCHAR2 | (150) | ||
| TFH_INFORMATION6 | VARCHAR2 | (150) | ||
| TFH_INFORMATION7 | VARCHAR2 | (150) | ||
| TFH_INFORMATION8 | VARCHAR2 | (150) | ||
| TFH_INFORMATION9 | VARCHAR2 | (150) | ||
| TFH_INFORMATION10 | VARCHAR2 | (150) | ||
| TFH_INFORMATION11 | VARCHAR2 | (150) | ||
| TFH_INFORMATION12 | VARCHAR2 | (150) | ||
| TFH_INFORMATION13 | VARCHAR2 | (150) | ||
| TFH_INFORMATION14 | VARCHAR2 | (150) | ||
| TFH_INFORMATION15 | VARCHAR2 | (150) | ||
| TFH_INFORMATION16 | VARCHAR2 | (150) | ||
| TFH_INFORMATION17 | VARCHAR2 | (150) | ||
| TFH_INFORMATION18 | VARCHAR2 | (150) | ||
| TFH_INFORMATION19 | VARCHAR2 | (150) | ||
| TFH_INFORMATION20 | VARCHAR2 | (150) | ||
| RECEIVING_COST_CENTER | VARCHAR2 | (800) | ||
| PAYING_COST_CENTER | VARCHAR2 | (800) | ||
| TRANSFER_FROM_SET_OF_BOOKS_ID | NUMBER | (15) | ||
| TRANSFER_TO_SET_OF_BOOKS_ID | NUMBER | (15) | ||
| FROM_SEGMENT1 | VARCHAR2 | (25) | ||
| FROM_SEGMENT2 | VARCHAR2 | (25) | ||
| FROM_SEGMENT3 | VARCHAR2 | (25) | ||
| FROM_SEGMENT4 | VARCHAR2 | (25) | ||
| FROM_SEGMENT5 | VARCHAR2 | (25) | ||
| FROM_SEGMENT6 | VARCHAR2 | (25) | ||
| FROM_SEGMENT7 | VARCHAR2 | (25) | ||
| FROM_SEGMENT8 | VARCHAR2 | (25) | ||
| FROM_SEGMENT9 | VARCHAR2 | (25) | ||
| FROM_SEGMENT10 | VARCHAR2 | (25) | ||
| FROM_SEGMENT11 | VARCHAR2 | (25) | ||
| FROM_SEGMENT12 | VARCHAR2 | (25) | ||
| FROM_SEGMENT13 | VARCHAR2 | (25) | ||
| FROM_SEGMENT14 | VARCHAR2 | (25) | ||
| FROM_SEGMENT15 | VARCHAR2 | (25) | ||
| FROM_SEGMENT16 | VARCHAR2 | (25) | ||
| FROM_SEGMENT17 | VARCHAR2 | (25) | ||
| FROM_SEGMENT18 | VARCHAR2 | (25) | ||
| FROM_SEGMENT19 | VARCHAR2 | (25) | ||
| FROM_SEGMENT20 | VARCHAR2 | (25) | ||
| FROM_SEGMENT21 | VARCHAR2 | (25) | ||
| FROM_SEGMENT22 | VARCHAR2 | (25) | ||
| FROM_SEGMENT23 | VARCHAR2 | (25) | ||
| FROM_SEGMENT24 | VARCHAR2 | (25) | ||
| FROM_SEGMENT25 | VARCHAR2 | (25) | ||
| FROM_SEGMENT26 | VARCHAR2 | (25) | ||
| FROM_SEGMENT27 | VARCHAR2 | (25) | ||
| FROM_SEGMENT28 | VARCHAR2 | (25) | ||
| FROM_SEGMENT29 | VARCHAR2 | (25) | ||
| FROM_SEGMENT30 | VARCHAR2 | (25) | ||
| TO_SEGMENT1 | VARCHAR2 | (25) | ||
| TO_SEGMENT2 | VARCHAR2 | (25) | ||
| TO_SEGMENT3 | VARCHAR2 | (25) | ||
| TO_SEGMENT4 | VARCHAR2 | (25) | ||
| TO_SEGMENT5 | VARCHAR2 | (25) | ||
| TO_SEGMENT6 | VARCHAR2 | (25) | ||
| TO_SEGMENT7 | VARCHAR2 | (25) | ||
| TO_SEGMENT8 | VARCHAR2 | (25) | ||
| TO_SEGMENT9 | VARCHAR2 | (25) | ||
| TO_SEGMENT10 | VARCHAR2 | (25) | ||
| TO_SEGMENT11 | VARCHAR2 | (25) | ||
| TO_SEGMENT12 | VARCHAR2 | (25) | ||
| TO_SEGMENT13 | VARCHAR2 | (25) | ||
| TO_SEGMENT14 | VARCHAR2 | (25) | ||
| TO_SEGMENT15 | VARCHAR2 | (25) | ||
| TO_SEGMENT16 | VARCHAR2 | (25) | ||
| TO_SEGMENT17 | VARCHAR2 | (25) | ||
| TO_SEGMENT18 | VARCHAR2 | (25) | ||
| TO_SEGMENT19 | VARCHAR2 | (25) | ||
| TO_SEGMENT20 | VARCHAR2 | (25) | ||
| TO_SEGMENT21 | VARCHAR2 | (25) | ||
| TO_SEGMENT22 | VARCHAR2 | (25) | ||
| TO_SEGMENT23 | VARCHAR2 | (25) | ||
| TO_SEGMENT24 | VARCHAR2 | (25) | ||
| TO_SEGMENT25 | VARCHAR2 | (25) | ||
| TO_SEGMENT26 | VARCHAR2 | (25) | ||
| TO_SEGMENT27 | VARCHAR2 | (25) | ||
| TO_SEGMENT28 | VARCHAR2 | (25) | ||
| TO_SEGMENT29 | VARCHAR2 | (25) | ||
| TO_SEGMENT30 | VARCHAR2 | (25) | ||
| TRANSFER_FROM_CC_ID | NUMBER | (15) | ||
| TRANSFER_TO_CC_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, FINANCE_HEADER_ID
, OBJECT_VERSION_NUMBER
, BUSINESS_GROUP_ID
, SUPERCEDING_HEADER_ID
, AUTHORIZER_PERSON_ID
, AUTHORIZER_PERSON_FULL_NAME
, ORGANIZATION_ID
, ORGANIZATION_NAME
, ADMINISTRATOR
, ADMINISTRATOR_FULL_NAME
, CANCELLED_FLAG
, CURRENCY_CODE
, INVOICE_FULL_AMOUNT
, DATE_RAISED
, PAYMENT_STATUS_FLAG
, TRANSFER_STATUS
, TRANSFER_STATUS_MEANING
, TYPE
, TYPE_MEANING
, RECEIVABLE_TYPE
, COMMENTS
, EXTERNAL_REFERENCE
, INVOICE_ADDRESS
, INVOICE_CONTACT
, PAYMENT_METHOD
, PAYMENT_METHOD_MEANING
, PYM_ATTRIBUTE1
, PYM_ATTRIBUTE2
, PYM_ATTRIBUTE3
, PYM_ATTRIBUTE4
, PYM_ATTRIBUTE5
, PYM_ATTRIBUTE6
, PYM_ATTRIBUTE7
, PYM_ATTRIBUTE8
, PYM_ATTRIBUTE9
, PYM_ATTRIBUTE10
, PYM_ATTRIBUTE11
, PYM_ATTRIBUTE12
, PYM_ATTRIBUTE13
, PYM_ATTRIBUTE14
, PYM_ATTRIBUTE15
, PYM_ATTRIBUTE16
, PYM_ATTRIBUTE17
, PYM_ATTRIBUTE18
, PYM_ATTRIBUTE19
, PYM_ATTRIBUTE20
, PYM_INFORMATION_CATEGORY
, TRANSFER_DATE
, TRANSFER_MESSAGE
, VENDOR_ID
, VENDOR_NAME
, CONTACT_ID
, ADDRESS_ID
, CUSTOMER_ID
, CUSTOMER_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, TFH_INFORMATION_CATEGORY
, TFH_INFORMATION1
, TFH_INFORMATION2
, TFH_INFORMATION3
, TFH_INFORMATION4
, TFH_INFORMATION5
, TFH_INFORMATION6
, TFH_INFORMATION7
, TFH_INFORMATION8
, TFH_INFORMATION9
, TFH_INFORMATION10
, TFH_INFORMATION11
, TFH_INFORMATION12
, TFH_INFORMATION13
, TFH_INFORMATION14
, TFH_INFORMATION15
, TFH_INFORMATION16
, TFH_INFORMATION17
, TFH_INFORMATION18
, TFH_INFORMATION19
, TFH_INFORMATION20
, RECEIVING_COST_CENTER
, PAYING_COST_CENTER
, TRANSFER_FROM_SET_OF_BOOKS_ID
, TRANSFER_TO_SET_OF_BOOKS_ID
, FROM_SEGMENT1
, FROM_SEGMENT2
, FROM_SEGMENT3
, FROM_SEGMENT4
, FROM_SEGMENT5
, FROM_SEGMENT6
, FROM_SEGMENT7
, FROM_SEGMENT8
, FROM_SEGMENT9
, FROM_SEGMENT10
, FROM_SEGMENT11
, FROM_SEGMENT12
, FROM_SEGMENT13
, FROM_SEGMENT14
, FROM_SEGMENT15
, FROM_SEGMENT16
, FROM_SEGMENT17
, FROM_SEGMENT18
, FROM_SEGMENT19
, FROM_SEGMENT20
, FROM_SEGMENT21
, FROM_SEGMENT22
, FROM_SEGMENT23
, FROM_SEGMENT24
, FROM_SEGMENT25
, FROM_SEGMENT26
, FROM_SEGMENT27
, FROM_SEGMENT28
, FROM_SEGMENT29
, FROM_SEGMENT30
, TO_SEGMENT1
, TO_SEGMENT2
, TO_SEGMENT3
, TO_SEGMENT4
, TO_SEGMENT5
, TO_SEGMENT6
, TO_SEGMENT7
, TO_SEGMENT8
, TO_SEGMENT9
, TO_SEGMENT10
, TO_SEGMENT11
, TO_SEGMENT12
, TO_SEGMENT13
, TO_SEGMENT14
, TO_SEGMENT15
, TO_SEGMENT16
, TO_SEGMENT17
, TO_SEGMENT18
, TO_SEGMENT19
, TO_SEGMENT20
, TO_SEGMENT21
, TO_SEGMENT22
, TO_SEGMENT23
, TO_SEGMENT24
, TO_SEGMENT25
, TO_SEGMENT26
, TO_SEGMENT27
, TO_SEGMENT28
, TO_SEGMENT29
, TO_SEGMENT30
, TRANSFER_FROM_CC_ID
, TRANSFER_TO_CC_ID
FROM APPS.OTA_FINANCE_HEADERS_V;
APPS
FND_USER
HR_ALL_ORGANIZATION_UNITS
HR_ALL_ORGANIZATION_UNITS_TL
HR_GENERAL
- show dependent code
HZ_CUST_ACCOUNTS
HZ_PARTIES
OTA_FINANCE_HEADERS
OTA_TFH_API_BUSINESS_RULES2
- show dependent code
PO_VENDORS
APPS.OTA_FINANCE_HEADERS_V is not referenced by any database object
|
|
|
|