[Home] [Help]
View: PA_ALLOC_AUDIT_GL_V
View Text
SELECT PAGD.RUN_ID
, PAGD.LINE_NUM
, PAGD.SOURCE_CCID
, PAGD.AMOUNT
, PAGD.SOURCE_PERCENT
, PAR.POOL_PERCENT
, PAGD.ELIGIBLE_AMOUNT
, PAGD.SUBTRACT_FLAG
, PAR.ORG_ID
FROM PA_ALLOC_RUN_GL_DET PAGD
, PA_ALLOC_RUNS PAR
WHERE PAR.RUN_ID = PAGD.RUN_ID
Columns
Name |
RUN_ID |
LINE_NUM |
SOURCE_CCID |
AMOUNT |
SOURCE_PERCENT |
POOL_PERCENT |
ELIGIBLE_AMOUNT |
SUBTRACT_FLAG |
ORG_ID |