[Home] [Help] [Dependency Information]
Object Name: | PAYBV_ACTION_INFORMATION_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAYBV_ACTION_INFORMATION_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTION_CONTEXT_TYPE | VARCHAR2 | (15) | Yes | Type of context archived in table. |
JURISDICTION_CODE | VARCHAR2 | (30) | Archived context information | |
SOURCE_TEXT | VARCHAR2 | (240) | Archived context information | |
TAX_GROUP | VARCHAR2 | (240) | Archived context information | |
EFFECTIVE_DATE | DATE | Effective date of the record. | ||
ACTION_INFORMATION_CATEGORY | VARCHAR2 | (80) | Yes | Developer descriptive flexfield column. |
ACTION_INFORMATION1 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION2 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION3 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION4 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION5 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION6 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION7 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION8 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION9 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION10 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION11 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION12 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION13 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION14 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION15 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION16 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION17 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION18 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION19 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION20 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION21 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION22 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION23 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION24 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION25 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION26 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION27 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION28 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION29 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION30 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ASSIGNMENT_ID | NUMBER | (10) | Assignment ID for which this action is archived | |
ACTION_INFORMATION_ID | NUMBER | (15) | Yes | System-generated primary key column. |
ACTION_CONTEXT_ID | NUMBER | (15) | Yes | Foreign key to PAY_ACTION_CONTEXTS. |
TAX_UNIT_ID | NUMBER | (15) | Identifies the Government Reporting Entity, or Legal Entity for the assignment. | |
SOURCE_ID | NUMBER | (15) | Archived context information | |
OBJECT_VERSION_NUMBER | NUMBER | System-generated version of row. Increments by one with each update. | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. |
Cut, paste (and edit) the following text to query this object:
SELECT ACTION_CONTEXT_TYPE
, JURISDICTION_CODE
, SOURCE_TEXT
, TAX_GROUP
, EFFECTIVE_DATE
, ACTION_INFORMATION_CATEGORY
, ACTION_INFORMATION1
, ACTION_INFORMATION2
, ACTION_INFORMATION3
, ACTION_INFORMATION4
, ACTION_INFORMATION5
, ACTION_INFORMATION6
, ACTION_INFORMATION7
, ACTION_INFORMATION8
, ACTION_INFORMATION9
, ACTION_INFORMATION10
, ACTION_INFORMATION11
, ACTION_INFORMATION12
, ACTION_INFORMATION13
, ACTION_INFORMATION14
, ACTION_INFORMATION15
, ACTION_INFORMATION16
, ACTION_INFORMATION17
, ACTION_INFORMATION18
, ACTION_INFORMATION19
, ACTION_INFORMATION20
, ACTION_INFORMATION21
, ACTION_INFORMATION22
, ACTION_INFORMATION23
, ACTION_INFORMATION24
, ACTION_INFORMATION25
, ACTION_INFORMATION26
, ACTION_INFORMATION27
, ACTION_INFORMATION28
, ACTION_INFORMATION29
, ACTION_INFORMATION30
, ASSIGNMENT_ID
, ACTION_INFORMATION_ID
, ACTION_CONTEXT_ID
, TAX_UNIT_ID
, SOURCE_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
FROM APPS.PAYBV_ACTION_INFORMATION_V;
APPS.PAYBV_ACTION_INFORMATION_V is not referenced by any database object
|
|
|