[Home] [Help]
[Dependency Information]
Object Name: | PAYBV_PAYROLL_MESSAGE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYROLL_NAME | VARCHAR2 | (80) | ||
PERIOD_NAME | VARCHAR2 | (4000) | ||
PROCESS_TYPE_M | VARCHAR2 | (4000) | ||
PROCESS_DATE | DATE | |||
PAYROLL_ACTION_STATUS | VARCHAR2 | (4000) | ||
FULL_NAME | VARCHAR2 | (240) | ||
ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
ASSIGNMENT_ACTION_STATUS | VARCHAR2 | (4000) | ||
SEVERITY_LEVEL_M | VARCHAR2 | (4000) | ||
MESSAGE_LINE | VARCHAR2 | (240) | ||
LINE_SEQUENCE | NUMBER | (15) | ||
MESSAGE_SOURCE_M | VARCHAR2 | (4000) | ||
PROCESS_TYPE | VARCHAR2 | (30) | ||
SEVERITY_LEVEL | VARCHAR2 | (1) | ||
MESSAGE_SOURCE | VARCHAR2 | (1) | ||
PAYROLL_ACTION_ID | NUMBER | (9) | ||
PAYROLL_ID | NUMBER | (9) | ||
REQUEST_ID | NUMBER | (15) | ||
ASSIGNMENT_ACTION_ID | NUMBER | |||
BG_SECURITY_FLAG_CODE | CHAR | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT PAYROLL_NAME
, PERIOD_NAME
, PROCESS_TYPE_M
, PROCESS_DATE
, PAYROLL_ACTION_STATUS
, FULL_NAME
, ASSIGNMENT_NUMBER
, ASSIGNMENT_ACTION_STATUS
, SEVERITY_LEVEL_M
, MESSAGE_LINE
, LINE_SEQUENCE
, MESSAGE_SOURCE_M
, PROCESS_TYPE
, SEVERITY_LEVEL
, MESSAGE_SOURCE
, PAYROLL_ACTION_ID
, PAYROLL_ID
, REQUEST_ID
, ASSIGNMENT_ACTION_ID
, BG_SECURITY_FLAG_CODE
FROM APPS.PAYBV_PAYROLL_MESSAGE_V;
|
|
|