[Home] [Help] [Dependency Information]
Object Name: | AHL_DOCUMENTS_B |
---|---|
Object Type: | TABLE |
Owner: | AHL |
FND Design Data: | AHL.AHL_DOCUMENTS_B |
Subobject Name: | |
Status: | VALID |
This table stores information about documents, which are provided by suppliers of a product or any other manuals used in the ASO industry. It stores Associations between documents and sub types, operator codes, product type codes and sources of the documents. This information is utilized in the Route Management, Unit Configuration and Master Configuration modules.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AHL_DOCUMENTS_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED | DOCUMENT_ID |
AHL_DOCUMENTS_B_U2 | NORMAL | UNIQUE | APPS_TS_SEED | DOCUMENT_NO |
AHL_DOCUMENTS_B_U3 | NORMAL | NONUNIQUE | APPS_TS_SEED | SOURCE_PARTY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOCUMENT_ID | NUMBER | Yes | Primary Key | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Stores locking sequence number | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
DOCUMENT_NO | VARCHAR2 | (30) | Yes | Document Number |
SOURCE_PARTY_ID | NUMBER | Yes | Source of the document, foreign key to HZ_PARTIES | |
SUBSCRIBE_AVAIL_FLAG | VARCHAR2 | (1) | Yes | Subscription Available Flag |
SUBSCRIBE_TO_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the document is subscribed to |
DOC_TYPE_CODE | VARCHAR2 | (30) | Yes | Document Type Code |
DOC_SUB_TYPE_CODE | VARCHAR2 | (30) | Document Sub Type Code | |
OPERATOR_CODE | VARCHAR2 | (30) | Operator Code | |
PRODUCT_TYPE_CODE | VARCHAR2 | (30) | Product Type Code | |
SECURITY_GROUP_ID | NUMBER | Used in application hosting | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment column |
Cut, paste (and edit) the following text to query this object:
SELECT DOCUMENT_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DOCUMENT_NO
, SOURCE_PARTY_ID
, SUBSCRIBE_AVAIL_FLAG
, SUBSCRIBE_TO_FLAG
, DOC_TYPE_CODE
, DOC_SUB_TYPE_CODE
, OPERATOR_CODE
, PRODUCT_TYPE_CODE
, SECURITY_GROUP_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM AHL.AHL_DOCUMENTS_B;
AHL.AHL_DOCUMENTS_B does not reference any database object
AHL.AHL_DOCUMENTS_B is referenced by following:
|
|
|