[Home] [Help]
| Product: | PA - Projects |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT RDL.ROWID
, RDL.EXPENDITURE_ITEM_ID
, RDL.LINE_NUM
, RDL.CREATION_DATE
, RDL.CREATED_BY
, RDL.PROJECT_ID
, RDL.DRAFT_REVENUE_NUM
, RDL.DRAFT_REVENUE_ITEM_LINE_NUM
, RDL.AMOUNT
, RDL.CODE_COMBINATION_ID
, RDL.BILL_AMOUNT
, RDL.FUNCTION_CODE
, RDL.FUNCTION_TRANSACTION_CODE
, RDL.REQUEST_ID
, RDL.PROGRAM_APPLICATION_ID
, RDL.PROGRAM_ID
, RDL.PROGRAM_UPDATE_DATE
, RDL.BATCH_NAME
, RDL.ADDITIONAL_REVENUE_FLAG
, RDL.INVOICE_ELIGIBLE_FLAG
, RDL.DRAFT_INVOICE_NUM
, RDL.DRAFT_INVOICE_ITEM_LINE_NUM
, RDL.REVERSED_FLAG
, RDL.LINE_NUM_REVERSED
, RDL.REV_IND_COMPILED_SET_ID
, RDL.INV_IND_COMPILED_SET_ID
, RDL.RAW_COST
, RDL.ORG_ID
, RDL.OUTPUT_VAT_TAX_ID
, RDL.OUTPUT_TAX_CLASSIFICATION_CODE
, RDL.OUTPUT_TAX_EXEMPT_FLAG
, RDL.OUTPUT_TAX_EXEMPT_REASON_CODE
, RDL.OUTPUT_TAX_EXEMPT_NUMBER
, RDL.PRC_GENERATED_FLAG
, RDL.BILL_TRANS_CURRENCY_CODE
, RDL.BILL_TRANS_AMOUNT
, RDL.BILL_TRANS_BILL_AMOUNT
, RDL.BILL_RATE
, RDL.REVPROC_CURRENCY_CODE
, RDL.REVPROC_RATE_TYPE
, RDL.REVPROC_RATE_DATE
, RDL.REVPROC_EXCHANGE_RATE
, RDL.INVPROC_CURRENCY_CODE
, RDL.INVPROC_RATE_TYPE
, RDL.INVPROC_RATE_DATE
, RDL.INVPROC_EXCHANGE_RATE
, RDL.PROJECT_CURRENCY_CODE
, RDL.PROJECT_REVENUE_AMOUNT
, RDL.PROJECT_REV_RATE_TYPE
, RDL.PROJECT_REV_RATE_DATE
, RDL.PROJECT_REV_EXCHANGE_RATE
, RDL.PROJECT_BILL_AMOUNT
, RDL.PROJECT_INV_RATE_TYPE
, RDL.PROJECT_INV_RATE_DATE
, RDL.PROJECT_INV_EXCHANGE_RATE
, RDL.PROJFUNC_CURRENCY_CODE
, RDL.PROJFUNC_REVENUE_AMOUNT
, RDL.PROJFUNC_REV_RATE_TYPE
, RDL.PROJFUNC_REV_RATE_DATE
, RDL.PROJFUNC_REV_EXCHANGE_RATE
, RDL.PROJFUNC_BILL_AMOUNT
, RDL.PROJFUNC_INV_RATE_TYPE
, RDL.PROJFUNC_INV_RATE_DATE
, RDL.PROJFUNC_INV_EXCHANGE_RATE
, RDL.FUNDING_CURRENCY_CODE
, RDL.FUNDING_REVENUE_AMOUNT
, RDL.FUNDING_REV_RATE_TYPE
, RDL.FUNDING_REV_RATE_DATE
, RDL.FUNDING_REV_EXCHANGE_RATE
, RDL.FUNDING_BILL_AMOUNT
, RDL.FUNDING_INV_RATE_TYPE
, RDL.FUNDING_INV_RATE_DATE
, RDL.FUNDING_INV_EXCHANGE_RATE
, RDL.LABOR_MULTIPLIER
, RDL.DISCOUNT_PERCENTAGE
, RDL.AMOUNT_CALCULATION_CODE
, RDL.BILL_MARKUP_PERCENTAGE
, RDL.RATE_SOURCE_ID
, RDL.INV_GEN_REJECTION_CODE
, RDL.RETN_DRAFT_INVOICE_NUM
, RDL.RETN_DRAFT_INVOICE_LINE_NUM
, RDL.RETAINED_AMOUNT
, RDL.RETENTION_RULE_ID
, RDL.RATE_DISC_REASON_CODE
, MC.CURRENCY_CODE
, MC.AMOUNT
FROM PA_CUST_REV_DIST_LINES_ALL RDL
, PA_MC_CUST_RDL_ALL MC
WHERE MC.EXPENDITURE_ITEM_ID = RDL.EXPENDITURE_ITEM_ID
AND MC.LINE_NUM = RDL.LINE_NUM
AND MC.PRC_ASSIGNMENT_ID = -99
AND MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99)