[Home] [Help] [Dependency Information]
Object Name: | AMW_AP_STEPS_B |
---|---|
Object Type: | TABLE |
Owner: | AMW |
FND Design Data: | AMW.AMW_AP_STEPS_B |
Subobject Name: | |
Status: | VALID |
Steps are associated to an audit procedure revision. New steps maybe added, existing steps maybe
updated or deleted from an audit procedure revision. This table will store steps for audit procedure
and validity information is tracked using TO_REV_NUM and FROM_REV_NUM.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMW_AP_STEPS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | AP_STEP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AP_STEP_ID | NUMBER | Yes | Audit Step Unique identifier | |
AUDIT_PROCEDURE_ID | NUMBER | Yes | Identifier used to reference the audit procedure to which this step belongs. This column references the AUDIT_PROCEDURE_ID column of the AUDIT_PROCEDURES_B table. | |
SEQNUM | NUMBER | This column is no longer used. | ||
SAMPLESIZE | NUMBER | Sample size for this audit step | ||
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
FROM_REV_NUM | NUMBER | Yes | Revision number of the audit procedure in which this step was created or updated. When a new audit step is created, a new row is inserted into this table which has FROM_REV_NUM set to the revision number of the audit procedure in which this step was created. When an existing step is updated, TO_REV_NUM is set to the revision number of the audit procedure in which the step is updated. A new row is inserted into this table which has FROM_REV_NUM set to the revision number of the audit procedure in which the step is updated. | |
TO_REV_NUM | NUMBER | Revision number of the audit procedure till which this step is valid. When an existing step is updated, the row corresponding to that step has TO_REV_NUM set to the revision number of the audit procedure in which this step is updated and a new row is inserted into this table. The new row has FROM_REV_NUM set to the revision number of the audit procedure in which the step is updated and TO_REV_NUM is null. When an existing step is deleted, TO_REV_NUM is set to the revision number of the audit procedure in which the step is deleted. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
SECURITY_GROUP_ID | NUMBER | Used for hosting environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Object version number is used for Optimistic Locking. | ||
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (30) | Original system reference | |
REQUESTOR_ID | NUMBER | Requestor Identifier | ||
CSEQNUM | VARCHAR2 | (240) | Sequence number for this audit step |
Cut, paste (and edit) the following text to query this object:
SELECT AP_STEP_ID
, AUDIT_PROCEDURE_ID
, SEQNUM
, SAMPLESIZE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, FROM_REV_NUM
, TO_REV_NUM
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, ORIG_SYSTEM_REFERENCE
, REQUESTOR_ID
, CSEQNUM
FROM AMW.AMW_AP_STEPS_B;
AMW.AMW_AP_STEPS_B does not reference any database object
AMW.AMW_AP_STEPS_B is referenced by following:
|
|
|