[Home] [Help] [Dependency Information]
Object Name: | PA_AEL_SL_EI_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_AEL_SL_EI_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | |||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
ORG_ID | NUMBER | (15) | ||
TRX_CLASS_NAME | VARCHAR2 | (80) | ||
TRX_CLASS | VARCHAR2 | (30) | ||
TRX_TYPE_NAME | VARCHAR2 | (80) | ||
TRX_TYPE_C | VARCHAR2 | (30) | ||
TRX_NUMBER_DISPLAYED | VARCHAR2 | (40) | ||
TRX_NUMBER_N | NUMBER | (15) | ||
TRX_DATE | DATE | |||
COMMENTS | VARCHAR2 | (240) | ||
TRX_HDR_TABLE | CHAR | (2) | ||
TRX_HDR_ID | NUMBER | (15) | ||
ACCT_LINE_TYPE_NAME | VARCHAR2 | (80) | ||
ACCT_LINE_TYPE | VARCHAR2 | (30) | ||
CODE_COMBINATION_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
ACCOUNTED_DR | NUMBER | |||
ACCOUNTED_CR | NUMBER | |||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_RATE | NUMBER | |||
CURRENCY_USER_CONVERSION_TYPE | VARCHAR2 | (30) | ||
PA_EMPLOYEE_NUM | VARCHAR2 | (30) | ||
PA_EMPLOYEE_NAME | VARCHAR2 | (240) | ||
PA_SUPPLIER_NUM | VARCHAR2 | (30) | ||
PA_SUPPLIER_NAME | VARCHAR2 | (240) | ||
ACCOUNTING_DATE | DATE | |||
PA_TRANSFER_TO_GL | VARCHAR2 | (0) | ||
SOURCE_TABLE | CHAR | (2) | ||
SOURCE_ID | NUMBER | |||
AEL_TABLE | CHAR | (3) | ||
AEL_ID | NUMBER | |||
AE_LINE_REFERENCE | VARCHAR2 | (200) | ||
AE_LINE_REFERENCE_INTERNAL | VARCHAR2 | (200) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
PA_PROJECT_NUM | VARCHAR2 | (25) | ||
PA_PROJECT_ID | NUMBER | (15) | ||
PA_PROJECT_NAME | VARCHAR2 | (30) | ||
PA_TASK_NUM | VARCHAR2 | (25) | ||
PA_TASK_NAME | VARCHAR2 | (20) | ||
PA_EI_EV_ORG | VARCHAR2 | (240) | ||
PA_NL_RESOURCE_ORG | VARCHAR2 | (240) | ||
PA_NL_RESOURCE | VARCHAR2 | (250) | ||
PA_EI_EV_TYPE | VARCHAR2 | (30) | ||
PA_EVENT_NUM | NUMBER | |||
PA_QUANTITY | NUMBER | |||
PA_UOM | VARCHAR2 | (80) | ||
PA_PERIOD_DATE | DATE | |||
PA_GL_TRANSFER_DATE | DATE | |||
PA_CUSTOMER_NUMBER | NUMBER | |||
PA_CUSTOMER_NAME | VARCHAR2 | (0) | ||
PA_AGREEMENT_NUM | VARCHAR2 | (0) | ||
PA_ACCRUE_THRU_DATE | DATE | |||
PA_DRI_NUMBER | NUMBER | |||
PA_TRANS_ID | NUMBER | |||
PA_LINE_NUMBER | NUMBER | |||
TRANSFER_SYSTEM_NAME | VARCHAR2 | (80) | ||
TRANSFER_SYSTEM | VARCHAR2 | (80) | ||
GL_TRANSFER_STATUS_NAME | VARCHAR2 | (80) | ||
GL_TRANSFER_STATUS | VARCHAR2 | (30) | ||
GL_TRANSFER_FROM_TO_NAME | VARCHAR2 | (80) | ||
TRANSFER_STATUS_DETAIL_NAME | VARCHAR2 | (250) | ||
ACCOUNTING_COMPLETE | VARCHAR2 | (30) | ||
ACCOUNTING_COMPLETE_NAME | VARCHAR2 | (80) | ||
PA_VIEW_LABOR_COST | VARCHAR2 | (30) | ||
PRVDR_ORGANIZATION_NAME | VARCHAR2 | (240) | ||
RECVR_ORGANIZATION_NAME | VARCHAR2 | (240) | ||
PRVDR_OU_NAME | VARCHAR2 | (240) | ||
RECVR_OU_NAME | VARCHAR2 | (240) | ||
CC_TYPE_NAME | VARCHAR2 | (80) | ||
CC_TYPE | VARCHAR2 | (30) | ||
CC_PROC_METHOD_NAME | VARCHAR2 | (80) | ||
CC_PROC_METHOD | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, SET_OF_BOOKS_ID
, ORG_ID
, TRX_CLASS_NAME
, TRX_CLASS
, TRX_TYPE_NAME
, TRX_TYPE_C
, TRX_NUMBER_DISPLAYED
, TRX_NUMBER_N
, TRX_DATE
, COMMENTS
, TRX_HDR_TABLE
, TRX_HDR_ID
, ACCT_LINE_TYPE_NAME
, ACCT_LINE_TYPE
, CODE_COMBINATION_ID
, CURRENCY_CODE
, ENTERED_DR
, ENTERED_CR
, ACCOUNTED_DR
, ACCOUNTED_CR
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_USER_CONVERSION_TYPE
, PA_EMPLOYEE_NUM
, PA_EMPLOYEE_NAME
, PA_SUPPLIER_NUM
, PA_SUPPLIER_NAME
, ACCOUNTING_DATE
, PA_TRANSFER_TO_GL
, SOURCE_TABLE
, SOURCE_ID
, AEL_TABLE
, AEL_ID
, AE_LINE_REFERENCE
, AE_LINE_REFERENCE_INTERNAL
, CREATION_DATE
, CREATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PA_PROJECT_NUM
, PA_PROJECT_ID
, PA_PROJECT_NAME
, PA_TASK_NUM
, PA_TASK_NAME
, PA_EI_EV_ORG
, PA_NL_RESOURCE_ORG
, PA_NL_RESOURCE
, PA_EI_EV_TYPE
, PA_EVENT_NUM
, PA_QUANTITY
, PA_UOM
, PA_PERIOD_DATE
, PA_GL_TRANSFER_DATE
, PA_CUSTOMER_NUMBER
, PA_CUSTOMER_NAME
, PA_AGREEMENT_NUM
, PA_ACCRUE_THRU_DATE
, PA_DRI_NUMBER
, PA_TRANS_ID
, PA_LINE_NUMBER
, TRANSFER_SYSTEM_NAME
, TRANSFER_SYSTEM
, GL_TRANSFER_STATUS_NAME
, GL_TRANSFER_STATUS
, GL_TRANSFER_FROM_TO_NAME
, TRANSFER_STATUS_DETAIL_NAME
, ACCOUNTING_COMPLETE
, ACCOUNTING_COMPLETE_NAME
, PA_VIEW_LABOR_COST
, PRVDR_ORGANIZATION_NAME
, RECVR_ORGANIZATION_NAME
, PRVDR_OU_NAME
, RECVR_OU_NAME
, CC_TYPE_NAME
, CC_TYPE
, CC_PROC_METHOD_NAME
, CC_PROC_METHOD
FROM APPS.PA_AEL_SL_EI_V;
|
|
|