[Home] [Help] [Dependency Information]
Object Name: | OTFV_FINANCE_LINES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OTA.OTFV_FINANCE_LINES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows transactions with suppliers or customers.It records charges to customer for an enrollment, use of resources, to deduct from the balance of a prepurchase agreement.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_ID | NUMBER | (9) | ||
LINE_TYPE | VARCHAR2 | (4000) | ||
SEQUENCE | NUMBER | (9) | ||
LINE_CANCELLED | VARCHAR2 | (4000) | ||
CURRENCY | VARCHAR2 | (4000) | ||
STANDARD_AMOUNT | NUMBER | |||
MONEY_AMOUNT | NUMBER | |||
UNITARY_AMOUNT | NUMBER | (9) | ||
DATE_RAISED | DATE | |||
COMMENTS | VARCHAR2 | (2000) | ||
TRANSFER_STATUS | VARCHAR2 | (4000) | ||
TRANSFER_DATE | DATE | |||
TRANSFER_MESSAGE | VARCHAR2 | (240) | ||
HEADER_TYPE | VARCHAR2 | (4000) | ||
HEADER_SUB_TYPE | VARCHAR2 | (30) | ||
DATE_HEADER_RAISED | DATE | |||
ENROLLMENT_AGREEMENT | VARCHAR2 | (80) | ||
AGREEMENT_TYPE | VARCHAR2 | (4000) | ||
AGREEMENT_DISCOUNT | NUMBER | |||
TRAINING_UNIT | VARCHAR2 | (4000) | ||
ENROLLMENT_TYPE | VARCHAR2 | (1) | ||
STUDENT_NAME | VARCHAR2 | (4000) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | ||
CUSTOMER_NAME | VARCHAR2 | (50) | ||
CONTACT_NAME | VARCHAR2 | (4000) | ||
EVENT_TITLE | VARCHAR2 | (80) | ||
ACTIVITY_NAME | VARCHAR2 | (80) | ||
EVENT_START_DATE | DATE | |||
RESOURCE_NAME | VARCHAR2 | (400) | ||
RESOURCE_TYPE | VARCHAR2 | (4000) | ||
RESOURCE_REQUIRED_FROM | DATE | |||
RESOURCE_REQUIRED_TO | DATE | |||
SUPPLIER_NAME | VARCHAR2 | (240) | ||
_DF:LINE | CHAR | (29) | ||
_DF:TRANSFER | CHAR | (28) | ||
HEADER_ID | NUMBER | (9) | ||
ENROLLMENT_AGREEMENT_ID | NUMBER | (9) | ||
ENROLLMENT_ID | NUMBER | |||
VENDOR_ID | NUMBER | |||
STUDENT_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
EVENT_ID | NUMBER | |||
ACTIVITY_VERSION_ID | NUMBER | |||
RESOURCE_BOOKING_ID | NUMBER | |||
RESOURCE_ALLOCATION_ID | NUMBER | (9) | ||
ROC_ID | NUMBER | |||
OFFERING_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_ID
, LINE_TYPE
, SEQUENCE
, LINE_CANCELLED
, CURRENCY
, STANDARD_AMOUNT
, MONEY_AMOUNT
, UNITARY_AMOUNT
, DATE_RAISED
, COMMENTS
, TRANSFER_STATUS
, TRANSFER_DATE
, TRANSFER_MESSAGE
, HEADER_TYPE
, HEADER_SUB_TYPE
, DATE_HEADER_RAISED
, ENROLLMENT_AGREEMENT
, AGREEMENT_TYPE
, AGREEMENT_DISCOUNT
, TRAINING_UNIT
, ENROLLMENT_TYPE
, STUDENT_NAME
, ORGANIZATION_NAME
, CUSTOMER_NAME
, CONTACT_NAME
, EVENT_TITLE
, ACTIVITY_NAME
, EVENT_START_DATE
, RESOURCE_NAME
, RESOURCE_TYPE
, RESOURCE_REQUIRED_FROM
, RESOURCE_REQUIRED_TO
, SUPPLIER_NAME
, _DF:LINE
, _DF:TRANSFER
, HEADER_ID
, ENROLLMENT_AGREEMENT_ID
, ENROLLMENT_ID
, VENDOR_ID
, STUDENT_ID
, ORGANIZATION_ID
, CUSTOMER_ID
, EVENT_ID
, ACTIVITY_VERSION_ID
, RESOURCE_BOOKING_ID
, RESOURCE_ALLOCATION_ID
, ROC_ID
, OFFERING_ID
FROM APPS.OTFV_FINANCE_LINES;
APPS.OTFV_FINANCE_LINES is not referenced by any database object
|
|
|