View: GMS_DRAFT_INV_LINE_DETAILS_V

Product:	GMS - Grants Accounting
Description:
Implementation/DBA Data:	APPS.GMS_DRAFT_INV_LINE_DETAILS_V

View Text

SELECT EI.ROWID
, INT.EXPENDITURE_ITEM_ID
, INT.ADL_LINE_NUM
, DRF.PROJECT_ID
, DRF.DRAFT_INVOICE_NUM
, DRF.LINE_NUM
, DECODE (EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100 )
, NULL )
, 'OT'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100 )
, NULL )
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100) )
, EI.PROJECT_CURRENCY_CODE
, EI.PROJECT_RATE_DATE
, EI.PROJECT_RATE_TYPE
, CONV.USER_CONVERSION_TYPE USER_PROJECT_RATE_TYPE
, EI.PROJECT_EXCHANGE_RATE
, DECODE (EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100 )
, NULL )
, 'OT'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100 )
, NULL )
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100) )
, EI.RECEIPT_CURRENCY_CODE
, EI.RECEIPT_EXCHANGE_RATE
, DECODE (EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100 )
, NULL )
, 'OT'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100 )
, NULL )
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100) )
, DECODE (EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100 )
, NULL )
, 'OT'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100 )
, NULL )
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100) )
, EI.DENOM_CURRENCY_CODE
, DECODE (EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100 )
, NULL )
, 'OT'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100 )
, NULL )
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100) )
, DECODE (EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100 )
, NULL )
, 'OT'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100 )
, NULL )
, (ADL.RAW_COST * ADL.DISTRIBUTION_VALUE / 100) )
, EI.ACCT_CURRENCY_CODE
, EI.ACCT_RATE_DATE
, EI.ACCT_RATE_TYPE
, CONV2.USER_CONVERSION_TYPE USER_ACCT_RATE_TYPE
, EI.ACCT_EXCHANGE_RATE
, EI.ACCT_EXCHANGE_ROUNDING_LIMIT
, INT.AMOUNT
, TO_NUMBER (NULL)
, NULL
, E.EXPENDITURE_ID
, EI.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, EI.EXPENDITURE_ITEM_DATE
, EI.EXPENDITURE_TYPE
, E.INCURRED_BY_PERSON_ID
, EMP.FULL_NAME EMPLOYEE_NAME
, EMP.EMPLOYEE_NUMBER
, EI.JOB_ID
, J.NAME JOB_NAME
, NVL (EI.OVERRIDE_TO_ORGANIZATION_ID
, E.INCURRED_BY_ORGANIZATION_ID)
, O1.NAME EXPENDITURE_ORGANIZATION_NAME
, VEND.VENDOR_ID
, VEND.VENDOR_NAME
, VEND.SEGMENT1 VENDOR_NUMBER
, NVL (EMP.FULL_NAME
, VEND.VENDOR_NAME) EMPLOYEE_VENDOR_NAME
, NVL (EMP.EMPLOYEE_NUMBER
, VEND.SEGMENT1) EMPLOYEE_VENDOR_NUMBER
, EI.NON_LABOR_RESOURCE
, EI.ORGANIZATION_ID NLR_ORGANIZATION_ID
, O2.NAME NLR_ORGANIZATION_NAME
, EI.SYSTEM_LINKAGE_FUNCTION
, SL.MEANING
, C.EXPENDITURE_COMMENT
, EI.TRANSACTION_SOURCE
, EI.ORIG_TRANSACTION_REFERENCE
, E.EXPENDITURE_GROUP
, E.EXPENDITURE_STATUS_CODE
, EI.QUANTITY * (ADL.DISTRIBUTION_VALUE / 100) * DECODE (ADL.LINE_NUM_REVERSED
, NULL
, 1
, -1)
, ADL.RAW_COST * (ADL.DISTRIBUTION_VALUE / 100)
, ET.UNIT_OF_MEASURE
, L2.MEANING UNIT_OF_MEASURE_M
, ADL.COST_DISTRIBUTED_FLAG
, DECODE (EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, EI.RAW_COST_RATE
, NULL )
, 'OT'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, EI.RAW_COST_RATE
, NULL )
, EI.RAW_COST_RATE )
, EI.BILL_RATE
, EI.BILL_JOB_BILLING_TITLE
, EI.BILL_EMPLOYEE_BILLING_TITLE
, EI.ADJUSTED_EXPENDITURE_ITEM_ID
, EI.NET_ZERO_ADJUSTMENT_FLAG
, EI.TRANSFERRED_FROM_EXP_ITEM_ID
, EI.CONVERTED_FLAG
, EI.SOURCE_EXPENDITURE_ITEM_ID
, DRF.PROJECT_ID
, DRF.EVENT_TASK_ID
, DRF.EVENT_NUM
, ADL.BILLABLE_FLAG
, ADL.BILL_HOLD_FLAG
, ADL.REVENUE_DISTRIBUTED_FLAG
, EI.LAST_UPDATE_DATE
, EI.LAST_UPDATED_BY
, EI.LAST_UPDATE_LOGIN
, TR.USER_TRANSACTION_SOURCE
, TR.ALLOW_ADJUSTMENTS_FLAG
, TR.COSTED_FLAG
, TR.COST_BURDENED_FLAG
, TR.GL_ACCOUNTED_FLAG
, EI.BURDEN_SUM_DEST_RUN_ID
, CDL.BURDEN_SUM_REJECTION_CODE
, L9.MEANING BURDEN_SUM_REJECTION_M
, P.PROJECT_STATUS_CODE
, CDL.SYSTEM_REFERENCE2
, 'FROM-EI'
, P.SEGMENT1
, P.SEGMENT1
, P.PROJECT_ID
, EI.CREATED_BY
, EI.CREATION_DATE
, EI.BILL_TRANS_CURRENCY_CODE
, EI.INVPROC_CURRENCY_CODE
, EI.INVPROC_RATE_TYPE
, EI.INVPROC_RATE_DATE
, EI.INVPROC_EXCHANGE_RATE
, EI.BILL_AMOUNT
, EI.PROJFUNC_CURRENCY_CODE
, GL_FUNC.USER_CONVERSION_TYPE PROJFUNC_INV_RATE_TYPE
, P.PROJFUNC_COST_RATE_DATE
, EI.ACCT_EXCHANGE_RATE
, EI.PROJFUNC_BILL_AMOUNT
, GL_FUNC.USER_CONVERSION_TYPE PROJECT_INV_RATE_TYPE
, EI.PROJECT_RATE_DATE
, EI.ACCT_EXCHANGE_RATE
, EI.BILL_AMOUNT
, EI.ACCT_CURRENCY_CODE
, GL_FUNC.USER_CONVERSION_TYPE FUNDING_INV_RATE_TYPE
, P.FUNDING_RATE_DATE
, P.FUNDING_EXCHANGE_RATE
, EI.BILL_AMOUNT
, DECODE (EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, EI.PROJECT_RAW_COST
, NULL )
, 'OT'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, EI.PROJECT_RAW_COST
, NULL )
, EI.PROJECT_RAW_COST ) PROJECT_RAW_COST
, EI.PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE
, GL_FUNC.USER_CONVERSION_TYPE PROJFUNC_COST_RATE_TYPE
, EI.PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE
, ''
, ''
, EI.DENOM_TP_CURRENCY_CODE
, EI.ACCT_TP_RATE_TYPE
, (SELECT NVL (USER_CONVERSION_TYPE
, EI.ACCT_TP_RATE_TYPE)
FROM PA_CONVERSION_TYPES_V
WHERE CONVERSION_TYPE = EI.ACCT_TP_RATE_TYPE)
, EI.ACCT_TP_RATE_DATE
, EI.ACCT_TP_EXCHANGE_RATE
, (SELECT NVL (USER_CONVERSION_TYPE
, EI.PROJFUNC_COST_RATE_TYPE)
FROM PA_CONVERSION_TYPES_V
WHERE CONVERSION_TYPE = EI.PROJFUNC_COST_RATE_TYPE)
, EI.ORG_ID
, EI.RECVR_ORG_ID
, EI.CC_CROSS_CHARGE_CODE
, EI.CC_CROSS_CHARGE_TYPE
, EI.CC_BL_DISTRIBUTED_CODE
, EI.CC_IC_PROCESSED_CODE
, EI.CC_REJECTION_CODE
, EI.ORG_ID
, EI.WORK_TYPE_ID
, PA_UTILS4.GET_WORK_TYPE_NAME (EI.WORK_TYPE_ID)
, EI.TP_AMT_TYPE_CODE
, PL.MEANING
, ''
, TO_NUMBER (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_DATE (NULL)
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_DATE (NULL)
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, TO_CHAR (NULL)
, TO_DATE (NULL)
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, TO_CHAR (NULL)
, TO_NUMBER (NULL)
, DRI.ORG_ID
, EI.DOCUMENT_HEADER_ID
, EI.DOCUMENT_LINE_NUMBER
, EI.DOCUMENT_DISTRIBUTION_ID
, EI.DOCUMENT_TYPE
, EI.DOCUMENT_DISTRIBUTION_TYPE
, EI.DOCUMENT_PAYMENT_ID
, TR.ALLOW_BURDEN_FLAG
FROM GMS_EVENT_INTERSECT INT
, PA_DRAFT_INVOICE_ITEMS DRF
, PA_DRAFT_INVOICES DRI
, PA_EXPENDITURE_ITEMS_ALL EI
, GMS_AWARD_DISTRIBUTIONS ADL
, PA_TASKS T
, PA_PROJECTS_ALL P
, PA_EXPENDITURES_ALL E
, PA_EXPENDITURE_TYPES ET
, PA_EXPENDITURE_COMMENTS C
, PA_SYSTEM_LINKAGES SL
, PA_COST_DISTRIBUTION_LINES_ALL CDL
, PER_JOBS J
, PER_PEOPLE_F EMP
, PO_VENDORS VEND
, PA_TRANSACTION_SOURCES TR
, HR_ALL_ORGANIZATION_UNITS_TL O1
, HR_ALL_ORGANIZATION_UNITS_TL O2
, FND_LOOKUP_VALUES L2
, FND_LOOKUP_VALUES L9
, PA_CONVERSION_TYPES_V CONV
, PA_CONVERSION_TYPES_V CONV2
, GL_DAILY_CONVERSION_TYPES GL_FUNC
, PA_LOOKUPS PL
WHERE DRI.DRAFT_INVOICE_NUM = DRF.DRAFT_INVOICE_NUM
AND DRI.PROJECT_ID = DRF.PROJECT_ID
AND NVL(DRI.WRITE_OFF_FLAG
, 'N') <> 'Y'
AND NVL(DRI.CANCEL_CREDIT_MEMO_FLAG
, 'N') <> 'Y'
AND NVL(DRI.CONCESSION_FLAG
, 'N') <> 'Y'
AND INT.AWARD_PROJECT_ID = DRF.PROJECT_ID
AND INT.EVENT_NUM = DRF.EVENT_NUM
AND INT.EVENT_TYPE = 'INVOICE'
AND EI.EXPENDITURE_ITEM_ID = INT.EXPENDITURE_ITEM_ID
AND INT.EXPENDITURE_ITEM_ID = ADL.EXPENDITURE_ITEM_ID
AND INT.ADL_LINE_NUM = ADL.ADL_LINE_NUM
AND ADL.DOCUMENT_TYPE = 'EXP'
AND ADL.ADL_STATUS = 'A'
AND T.TASK_ID = EI.TASK_ID
AND P.PROJECT_ID = T.PROJECT_ID
AND E.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND EI.EXPENDITURE_ITEM_ID = C.EXPENDITURE_ITEM_ID(+)
AND EI.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE
AND SL.FUNCTION = EI.SYSTEM_LINKAGE_FUNCTION
AND CDL.EXPENDITURE_ITEM_ID = ADL.EXPENDITURE_ITEM_ID
AND CDL.LINE_NUM = ADL.CDL_LINE_NUM
AND EI.JOB_ID = J.JOB_ID(+)
AND E.INCURRED_BY_PERSON_ID = EMP.PERSON_ID(+)
AND EMP.EMPLOYEE_NUMBER(+) IS NOT NULL
AND TRUNC (SYSDATE) BETWEEN EMP.EFFECTIVE_START_DATE(+)
AND EMP.EFFECTIVE_END_DATE(+)
AND EI.VENDOR_ID = VEND.VENDOR_ID(+)
AND EI.TRANSACTION_SOURCE = TR.TRANSACTION_SOURCE(+)
AND NVL (EI.OVERRIDE_TO_ORGANIZATION_ID
, E.INCURRED_BY_ORGANIZATION_ID) = O1.ORGANIZATION_ID
AND O1.LANGUAGE = USERENV ('LANG')
AND EI.ORGANIZATION_ID = O2.ORGANIZATION_ID(+)
AND O2.LANGUAGE(+) = USERENV ('LANG')
AND L2.LOOKUP_TYPE = 'UNIT'
AND L2.LOOKUP_CODE = ET.UNIT_OF_MEASURE
AND L2.VIEW_APPLICATION_ID = 275
AND L2.LANGUAGE = USERENV ('LANG')
AND L9.LOOKUP_TYPE(+) = 'BURDEN SUM REJECTION CODE'
AND L9.LOOKUP_CODE(+) = CDL.BURDEN_SUM_REJECTION_CODE
AND L9.VIEW_APPLICATION_ID(+) = 275
AND L9.LANGUAGE(+) = USERENV ('LANG')
AND EI.ACCT_RATE_TYPE = CONV.CONVERSION_TYPE(+)
AND EI.PROJECT_RATE_TYPE = CONV2.CONVERSION_TYPE(+)
AND EI.PROJFUNC_COST_RATE_TYPE = GL_FUNC.CONVERSION_TYPE(+)
AND PL.LOOKUP_TYPE = 'TRANSACTION_TYPE'
AND PL.LOOKUP_CODE = 'EXP_ITEM' UNION ALL SELECT EI.ROWID
, BC.EXPENDITURE_ITEM_ID
, BC.ADL_LINE_NUM
, DRF.PROJECT_ID
, DRF.DRAFT_INVOICE_NUM
, DRF.LINE_NUM
, TO_NUMBER (NULL) RAW_COST
, EI.PROJECT_CURRENCY_CODE
, EI.PROJECT_RATE_DATE
, EI.PROJECT_RATE_TYPE
, CONV2.USER_CONVERSION_TYPE USER_PROJECT_RATE_TYPE
, EI.PROJECT_EXCHANGE_RATE
, TO_NUMBER (NULL)
, NULL
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, NULL
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, NULL
, TO_DATE (NULL)
, NULL
, NULL
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, BC.AMOUNT BILL_AMOUNT
, TO_NUMBER (NULL)
, NULL
, E.EXPENDITURE_ID
, BC.ACTUAL_TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, EI.EXPENDITURE_ITEM_DATE
, BC.BURDEN_EXP_TYPE
, E.INCURRED_BY_PERSON_ID
, EMP.FULL_NAME EMPLOYEE_NAME
, EMP.EMPLOYEE_NUMBER
, EI.JOB_ID
, J.NAME JOB_NAME
, BC.EXPENDITURE_ORG_ID
, O.NAME
, TO_NUMBER (NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER (NULL)
, NULL
, NULL
, NULL
, NULL
, EI.EXPENDITURE_TYPE
, BC.BURDEN_COST_CODE
, E.EXPENDITURE_GROUP
, NULL
, TO_NUMBER (NULL)
, BC.AMOUNT
, NULL
, NULL
, NULL
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, NULL
, NULL
, TO_NUMBER (NULL)
, NULL
, TO_NUMBER (NULL)
, NULL
, TO_NUMBER (NULL)
, DRF.PROJECT_ID
, DRF.EVENT_TASK_ID
, DRF.EVENT_NUM
, NULL
, NULL
, NULL
, EI.LAST_UPDATE_DATE
, EI.LAST_UPDATED_BY
, EI.LAST_UPDATE_LOGIN
, EI.EXPENDITURE_TYPE
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER (NULL)
, NULL
, NULL
, NULL
, NULL
, 'FROM-EI'
, P.SEGMENT1 PROJECT_NUMBER
, P.NAME PROJECT_NAME
, BC.ACTUAL_PROJECT_ID
, EI.CREATED_BY
, EI.CREATION_DATE
, EI.BILL_TRANS_CURRENCY_CODE
, EI.INVPROC_CURRENCY_CODE
, EI.INVPROC_RATE_TYPE
, EI.INVPROC_RATE_DATE
, EI.INVPROC_EXCHANGE_RATE
, EI.BILL_AMOUNT
, EI.PROJFUNC_CURRENCY_CODE
, GL_FUNC.USER_CONVERSION_TYPE PROJFUNC_INV_RATE_TYPE
, P.PROJFUNC_COST_RATE_DATE
, EI.ACCT_EXCHANGE_RATE
, EI.PROJFUNC_BILL_AMOUNT
, GL_FUNC.USER_CONVERSION_TYPE PROJECT_INV_RATE_TYPE
, EI.PROJECT_RATE_DATE
, EI.ACCT_EXCHANGE_RATE
, EI.BILL_AMOUNT
, EI.ACCT_CURRENCY_CODE
, GL_FUNC.USER_CONVERSION_TYPE FUNDING_INV_RATE_TYPE
, P.FUNDING_RATE_DATE
, P.FUNDING_EXCHANGE_RATE
, EI.BILL_AMOUNT
, DECODE (EI.SYSTEM_LINKAGE_FUNCTION
, 'ST'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, EI.PROJECT_RAW_COST
, NULL )
, 'OT'
, DECODE (PA_SECURITY.VIEW_LABOR_COSTS (DRF.PROJECT_ID)
, 'Y'
, EI.PROJECT_RAW_COST
, NULL )
, EI.PROJECT_RAW_COST ) PROJECT_RAW_COST
, EI.PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE
, GL_FUNC.USER_CONVERSION_TYPE PROJFUNC_COST_RATE_TYPE
, EI.PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE
, ''
, ''
, EI.DENOM_TP_CURRENCY_CODE
, EI.ACCT_TP_RATE_TYPE
, (SELECT NVL (USER_CONVERSION_TYPE
, EI.ACCT_TP_RATE_TYPE)
FROM PA_CONVERSION_TYPES_V
WHERE CONVERSION_TYPE = EI.ACCT_TP_RATE_TYPE)
, EI.ACCT_TP_RATE_DATE
, EI.ACCT_TP_EXCHANGE_RATE
, (SELECT NVL (USER_CONVERSION_TYPE
, EI.PROJFUNC_COST_RATE_TYPE)
FROM PA_CONVERSION_TYPES_V
WHERE CONVERSION_TYPE = EI.PROJFUNC_COST_RATE_TYPE)
, EI.ORG_ID
, EI.RECVR_ORG_ID
, EI.CC_CROSS_CHARGE_CODE
, EI.CC_CROSS_CHARGE_TYPE
, EI.CC_BL_DISTRIBUTED_CODE
, EI.CC_IC_PROCESSED_CODE
, EI.CC_REJECTION_CODE
, EI.ORG_ID
, EI.WORK_TYPE_ID
, PA_UTILS4.GET_WORK_TYPE_NAME (EI.WORK_TYPE_ID)
, EI.TP_AMT_TYPE_CODE
, PL.MEANING
, ''
, TO_NUMBER (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_DATE (NULL)
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, TO_CHAR (NULL)
, TO_CHAR (NULL)
, TO_DATE (NULL)
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, TO_CHAR (NULL)
, TO_DATE (NULL)
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, TO_CHAR (NULL)
, TO_NUMBER (NULL)
, DRI.ORG_ID
, EI.DOCUMENT_HEADER_ID
, EI.DOCUMENT_LINE_NUMBER
, EI.DOCUMENT_DISTRIBUTION_ID
, EI.DOCUMENT_TYPE
, EI.DOCUMENT_DISTRIBUTION_TYPE
, EI.DOCUMENT_PAYMENT_ID
, NULL
FROM GMS_BURDEN_COMPONENTS BC
, PA_DRAFT_INVOICE_ITEMS DRF
, PA_DRAFT_INVOICES DRI
, PA_PROJECTS_ALL P
, PA_TASKS T
, PA_EXPENDITURE_ITEMS_ALL EI
, GMS_AWARD_DISTRIBUTIONS ADL
, HR_ORGANIZATION_UNITS O
, PA_EXPENDITURES_ALL E
, PER_PEOPLE_F EMP
, PER_JOBS J
, PA_CONVERSION_TYPES_V CONV2
, GL_DAILY_CONVERSION_TYPES GL_FUNC
, PA_LOOKUPS PL
WHERE DRI.DRAFT_INVOICE_NUM = DRF.DRAFT_INVOICE_NUM
AND DRI.PROJECT_ID = DRF.PROJECT_ID
AND NVL(DRI.WRITE_OFF_FLAG
, 'N') <> 'Y'
AND NVL(DRI.CANCEL_CREDIT_MEMO_FLAG
, 'N') <> 'Y'
AND NVL(DRI.CONCESSION_FLAG
, 'N') <> 'Y'
AND BC.AWARD_PROJECT_ID = DRI.PROJECT_ID
AND BC.EVENT_NUM = DRF.EVENT_NUM
AND BC.EVENT_TYPE = 'INVOICE'
AND EI.EXPENDITURE_ITEM_ID = BC.EXPENDITURE_ITEM_ID
AND E.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND ADL.EXPENDITURE_ITEM_ID = BC.EXPENDITURE_ITEM_ID
AND ADL.ADL_LINE_NUM = BC.ADL_LINE_NUM
AND ADL.DOCUMENT_TYPE = 'EXP'
AND ADL.ADL_STATUS = 'A'
AND T.TASK_ID = BC.ACTUAL_TASK_ID
AND P.PROJECT_ID = BC.ACTUAL_PROJECT_ID
AND O.ORGANIZATION_ID = BC.EXPENDITURE_ORG_ID
AND EI.JOB_ID = J.JOB_ID(+)
AND E.INCURRED_BY_PERSON_ID = EMP.PERSON_ID(+)
AND EMP.EMPLOYEE_NUMBER(+) IS NOT NULL
AND TRUNC (SYSDATE) BETWEEN EMP.EFFECTIVE_START_DATE(+)
AND EMP.EFFECTIVE_END_DATE(+)
AND EI.PROJECT_RATE_TYPE = CONV2.CONVERSION_TYPE(+)
AND EI.PROJFUNC_COST_RATE_TYPE = GL_FUNC.CONVERSION_TYPE(+)
AND PL.LOOKUP_TYPE = 'TRANSACTION_TYPE'
AND PL.LOOKUP_CODE = 'EXP_ITEM'

Columns