[Home] [Help] [Dependency Information]
Object Name: | FA_MASS_EXTERNAL_TRANSFERS |
---|---|
Object Type: | TABLE |
Owner: | FA |
FND Design Data: | OFA.FA_MASS_EXTERNAL_TRANSFERS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FA_MASS_EXTERNAL_TRANSFERS_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | MASS_EXTERNAL_TRANSFER_ID |
FA_MASS_EXTERNAL_TRANSFERS_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
BOOK_TYPE_CODE
TRANSACTION_TYPE TRANSACTION_STATUS BATCH_NAME |
FA_MASS_EXTERNAL_TRANSFERS_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
BATCH_NAME
TRANSACTION_TYPE TRANSACTION_STATUS BOOK_TYPE_CODE |
FA_MASS_EXTERNAL_TRANSFERS_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
FROM_ASSET_ID
BOOK_TYPE_CODE |
FA_MASS_EXTERNAL_TRANSFERS_N4 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
TO_ASSET_ID
BOOK_TYPE_CODE |
FA_MASS_EXTERNAL_TRANSFERS_N5 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
FROM_GROUP_ASSET_ID
BOOK_TYPE_CODE BATCH_NAME |
FA_MASS_EXTERNAL_TRANSFERS_N6 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
TO_GROUP_ASSET_ID
BOOK_TYPE_CODE BATCH_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_NAME | VARCHAR2 | (15) | Yes | |
MASS_EXTERNAL_TRANSFER_ID | NUMBER | (15) | Yes | |
EXTERNAL_REFERENCE_NUM | VARCHAR2 | (15) | ||
TRANSACTION_REFERENCE_NUM | NUMBER | (15) | ||
TRANSACTION_TYPE | VARCHAR2 | (15) | Yes | |
FROM_ASSET_ID | NUMBER | (15) | ||
TO_ASSET_ID | NUMBER | (15) | ||
BOOK_TYPE_CODE | VARCHAR2 | (15) | ||
TRANSACTION_STATUS | VARCHAR2 | (20) | Yes | |
TRANSACTION_DATE_ENTERED | DATE | |||
FROM_DISTRIBUTION_ID | NUMBER | (15) | ||
FROM_LOCATION_ID | NUMBER | (15) | ||
FROM_GL_CCID | NUMBER | (15) | ||
FROM_EMPLOYEE_ID | NUMBER | (15) | ||
TO_DISTRIBUTION_ID | NUMBER | (15) | ||
TO_LOCATION_ID | NUMBER | (15) | ||
TO_GL_CCID | NUMBER | (15) | ||
TO_EMPLOYEE_ID | NUMBER | (15) | ||
DESCRIPTION | VARCHAR2 | (200) | ||
TRANSFER_UNITS | NUMBER | |||
TRANSFER_AMOUNT | NUMBER | |||
SOURCE_LINE_ID | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATED_DATE | DATE | Yes | ||
TRX_ATTRIBUTE1 | VARCHAR2 | (150) | ||
TRX_ATTRIBUTE2 | VARCHAR2 | (150) | ||
TRX_ATTRIBUTE3 | VARCHAR2 | (150) | ||
TRX_ATTRIBUTE4 | VARCHAR2 | (150) | ||
TRX_ATTRIBUTE5 | VARCHAR2 | (150) | ||
TRX_ATTRIBUTE6 | VARCHAR2 | (150) | ||
TRX_ATTRIBUTE7 | VARCHAR2 | (150) | ||
TRX_ATTRIBUTE8 | VARCHAR2 | (150) | ||
TRX_ATTRIBUTE9 | VARCHAR2 | (150) | ||
TRX_ATTRIBUTE10 | VARCHAR2 | (150) | ||
TRX_ATTRIBUTE11 | VARCHAR2 | (150) | ||
TRX_ATTRIBUTE12 | VARCHAR2 | (150) | ||
TRX_ATTRIBUTE13 | VARCHAR2 | (150) | ||
TRX_ATTRIBUTE14 | VARCHAR2 | (150) | ||
TRX_ATTRIBUTE15 | VARCHAR2 | (150) | ||
TRX_ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | (30) | ||
POST_BATCH_ID | NUMBER | (15) | ||
TH_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
TH_ATTRIBUTE1 | VARCHAR2 | (150) | ||
TH_ATTRIBUTE2 | VARCHAR2 | (150) | ||
TH_ATTRIBUTE3 | VARCHAR2 | (150) | ||
TH_ATTRIBUTE4 | VARCHAR2 | (150) | ||
TH_ATTRIBUTE5 | VARCHAR2 | (150) | ||
TH_ATTRIBUTE6 | VARCHAR2 | (150) | ||
TH_ATTRIBUTE7 | VARCHAR2 | (150) | ||
TH_ATTRIBUTE8 | VARCHAR2 | (150) | ||
TH_ATTRIBUTE9 | VARCHAR2 | (150) | ||
TH_ATTRIBUTE10 | VARCHAR2 | (150) | ||
TH_ATTRIBUTE11 | VARCHAR2 | (150) | ||
TH_ATTRIBUTE12 | VARCHAR2 | (150) | ||
TH_ATTRIBUTE13 | VARCHAR2 | (150) | ||
TH_ATTRIBUTE14 | VARCHAR2 | (150) | ||
TH_ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | (30) | ||
WORKER_ID | NUMBER | (15) | ||
FROM_GROUP_ASSET_ID | NUMBER | (15) | ||
TO_GROUP_ASSET_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_NAME
, MASS_EXTERNAL_TRANSFER_ID
, EXTERNAL_REFERENCE_NUM
, TRANSACTION_REFERENCE_NUM
, TRANSACTION_TYPE
, FROM_ASSET_ID
, TO_ASSET_ID
, BOOK_TYPE_CODE
, TRANSACTION_STATUS
, TRANSACTION_DATE_ENTERED
, FROM_DISTRIBUTION_ID
, FROM_LOCATION_ID
, FROM_GL_CCID
, FROM_EMPLOYEE_ID
, TO_DISTRIBUTION_ID
, TO_LOCATION_ID
, TO_GL_CCID
, TO_EMPLOYEE_ID
, DESCRIPTION
, TRANSFER_UNITS
, TRANSFER_AMOUNT
, SOURCE_LINE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_DATE
, TRX_ATTRIBUTE1
, TRX_ATTRIBUTE2
, TRX_ATTRIBUTE3
, TRX_ATTRIBUTE4
, TRX_ATTRIBUTE5
, TRX_ATTRIBUTE6
, TRX_ATTRIBUTE7
, TRX_ATTRIBUTE8
, TRX_ATTRIBUTE9
, TRX_ATTRIBUTE10
, TRX_ATTRIBUTE11
, TRX_ATTRIBUTE12
, TRX_ATTRIBUTE13
, TRX_ATTRIBUTE14
, TRX_ATTRIBUTE15
, TRX_ATTRIBUTE_CATEGORY_CODE
, POST_BATCH_ID
, TH_ATTRIBUTE_CATEGORY
, TH_ATTRIBUTE1
, TH_ATTRIBUTE2
, TH_ATTRIBUTE3
, TH_ATTRIBUTE4
, TH_ATTRIBUTE5
, TH_ATTRIBUTE6
, TH_ATTRIBUTE7
, TH_ATTRIBUTE8
, TH_ATTRIBUTE9
, TH_ATTRIBUTE10
, TH_ATTRIBUTE11
, TH_ATTRIBUTE12
, TH_ATTRIBUTE13
, TH_ATTRIBUTE14
, TH_ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY_CODE
, WORKER_ID
, FROM_GROUP_ASSET_ID
, TO_GROUP_ASSET_ID
FROM FA.FA_MASS_EXTERNAL_TRANSFERS;
FA.FA_MASS_EXTERNAL_TRANSFERS does not reference any database object
FA.FA_MASS_EXTERNAL_TRANSFERS is referenced by following:
|
|
|