Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PA_CUST_RDL_ALL_MRC_V

Object Details
Object Name: PA_CUST_RDL_ALL_MRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_CUST_RDL_ALL_MRC_V
Subobject Name:
Status: VALID

View Type

A multiple reporting currency view

[View Source]

Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_ITEM_ID NUMBER (15)
LINE_NUM NUMBER (15)
AMOUNT NUMBER

BILL_AMOUNT NUMBER

REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

BATCH_NAME VARCHAR2 (30)
RAW_COST NUMBER

PROJECT_ID NUMBER (15)
DRAFT_REVENUE_NUM NUMBER (15)
DRAFT_REVENUE_ITEM_LINE_NUM NUMBER (15)
DRAFT_INVOICE_NUM NUMBER (15)
DRAFT_INVOICE_ITEM_LINE_NUM NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
CODE_COMBINATION_ID NUMBER (15)
FUNCTION_CODE VARCHAR2 (15)
FUNCTION_TRANSACTION_CODE VARCHAR2 (30)
ADDITIONAL_REVENUE_FLAG VARCHAR2 (1)
INVOICE_ELIGIBLE_FLAG VARCHAR2 (1)
REVERSED_FLAG VARCHAR2 (1)
LINE_NUM_REVERSED NUMBER (15)
REV_IND_COMPILED_SET_ID NUMBER (15)
INV_IND_COMPILED_SET_ID NUMBER (15)
OUTPUT_VAT_TAX_ID NUMBER

OUTPUT_TAX_CLASSIFICATION_CODE VARCHAR2 (50)
OUTPUT_TAX_EXEMPT_FLAG VARCHAR2 (50)
OUTPUT_TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
OUTPUT_TAX_EXEMPT_NUMBER VARCHAR2 (80)
PRC_GENERATED_FLAG VARCHAR2 (1)
ORG_ID NUMBER (15)
PROJFUNC_CURRENCY_CODE VARCHAR2 (30)
PROJFUNC_REVENUE_AMOUNT NUMBER

PROJFUNC_BILL_AMOUNT NUMBER

PROJFUNC_REV_EXCHANGE_RATE NUMBER

PROJFUNC_REV_RATE_DATE DATE

PROJFUNC_REV_RATE_TYPE VARCHAR2 (30)
BILL_TRANS_CURRENCY_CODE VARCHAR2 (15)
BILL_TRANS_AMOUNT NUMBER

BILL_TRANS_BILL_AMOUNT NUMBER

BILL_RATE NUMBER

REVPROC_CURRENCY_CODE VARCHAR2 (15)
REVPROC_RATE_TYPE VARCHAR2 (30)
REVPROC_RATE_DATE DATE

REVPROC_EXCHANGE_RATE NUMBER

INVPROC_CURRENCY_CODE VARCHAR2 (15)
INVPROC_RATE_TYPE VARCHAR2 (30)
INVPROC_RATE_DATE DATE

INVPROC_EXCHANGE_RATE NUMBER

PROJECT_CURRENCY_CODE VARCHAR2 (15)
PROJECT_REV_RATE_TYPE VARCHAR2 (30)
PROJECT_REV_RATE_DATE DATE

PROJECT_REV_EXCHANGE_RATE NUMBER

PROJECT_REVENUE_AMOUNT NUMBER

PROJECT_INV_RATE_TYPE VARCHAR2 (30)
PROJECT_INV_RATE_DATE DATE

PROJECT_INV_EXCHANGE_RATE NUMBER

PROJECT_BILL_AMOUNT NUMBER

PROJFUNC_INV_RATE_TYPE VARCHAR2 (30)
PROJFUNC_INV_RATE_DATE DATE

PROJFUNC_INV_EXCHANGE_RATE NUMBER

FUNDING_CURRENCY_CODE VARCHAR2 (15)
FUNDING_REV_RATE_TYPE VARCHAR2 (30)
FUNDING_REV_RATE_DATE DATE

FUNDING_REV_EXCHANGE_RATE NUMBER

FUNDING_REVENUE_AMOUNT NUMBER

FUNDING_INV_RATE_TYPE VARCHAR2 (30)
FUNDING_INV_RATE_DATE DATE

FUNDING_INV_EXCHANGE_RATE NUMBER

FUNDING_BILL_AMOUNT NUMBER

LABOR_MULTIPLIER NUMBER

DISCOUNT_PERCENTAGE NUMBER

AMOUNT_CALCULATION_CODE VARCHAR2 (15)
BILL_MARKUP_PERCENTAGE NUMBER

RATE_SOURCE_ID NUMBER (15)
INV_GEN_REJECTION_CODE VARCHAR2 (30)
RETENTION_RULE_ID NUMBER (15)
RETN_DRAFT_INVOICE_NUM NUMBER

RETN_DRAFT_INVOICE_LINE_NUM NUMBER

RETAINED_AMOUNT NUMBER

RATE_DISC_REASON_CODE VARCHAR2 (30)
REVTRANS_AMOUNT NUMBER

REVTRANS_CURRENCY_CODE VARCHAR2 (15)
REVPROC_REVTRANS_RATE_TYPE VARCHAR2 (30)
REVPROC_REVTRANS_RATE_DATE DATE

REVPROC_REVTRANS_EX_RATE NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXPENDITURE_ITEM_ID
,      LINE_NUM
,      AMOUNT
,      BILL_AMOUNT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      BATCH_NAME
,      RAW_COST
,      PROJECT_ID
,      DRAFT_REVENUE_NUM
,      DRAFT_REVENUE_ITEM_LINE_NUM
,      DRAFT_INVOICE_NUM
,      DRAFT_INVOICE_ITEM_LINE_NUM
,      CREATION_DATE
,      CREATED_BY
,      CODE_COMBINATION_ID
,      FUNCTION_CODE
,      FUNCTION_TRANSACTION_CODE
,      ADDITIONAL_REVENUE_FLAG
,      INVOICE_ELIGIBLE_FLAG
,      REVERSED_FLAG
,      LINE_NUM_REVERSED
,      REV_IND_COMPILED_SET_ID
,      INV_IND_COMPILED_SET_ID
,      OUTPUT_VAT_TAX_ID
,      OUTPUT_TAX_CLASSIFICATION_CODE
,      OUTPUT_TAX_EXEMPT_FLAG
,      OUTPUT_TAX_EXEMPT_REASON_CODE
,      OUTPUT_TAX_EXEMPT_NUMBER
,      PRC_GENERATED_FLAG
,      ORG_ID
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_REVENUE_AMOUNT
,      PROJFUNC_BILL_AMOUNT
,      PROJFUNC_REV_EXCHANGE_RATE
,      PROJFUNC_REV_RATE_DATE
,      PROJFUNC_REV_RATE_TYPE
,      BILL_TRANS_CURRENCY_CODE
,      BILL_TRANS_AMOUNT
,      BILL_TRANS_BILL_AMOUNT
,      BILL_RATE
,      REVPROC_CURRENCY_CODE
,      REVPROC_RATE_TYPE
,      REVPROC_RATE_DATE
,      REVPROC_EXCHANGE_RATE
,      INVPROC_CURRENCY_CODE
,      INVPROC_RATE_TYPE
,      INVPROC_RATE_DATE
,      INVPROC_EXCHANGE_RATE
,      PROJECT_CURRENCY_CODE
,      PROJECT_REV_RATE_TYPE
,      PROJECT_REV_RATE_DATE
,      PROJECT_REV_EXCHANGE_RATE
,      PROJECT_REVENUE_AMOUNT
,      PROJECT_INV_RATE_TYPE
,      PROJECT_INV_RATE_DATE
,      PROJECT_INV_EXCHANGE_RATE
,      PROJECT_BILL_AMOUNT
,      PROJFUNC_INV_RATE_TYPE
,      PROJFUNC_INV_RATE_DATE
,      PROJFUNC_INV_EXCHANGE_RATE
,      FUNDING_CURRENCY_CODE
,      FUNDING_REV_RATE_TYPE
,      FUNDING_REV_RATE_DATE
,      FUNDING_REV_EXCHANGE_RATE
,      FUNDING_REVENUE_AMOUNT
,      FUNDING_INV_RATE_TYPE
,      FUNDING_INV_RATE_DATE
,      FUNDING_INV_EXCHANGE_RATE
,      FUNDING_BILL_AMOUNT
,      LABOR_MULTIPLIER
,      DISCOUNT_PERCENTAGE
,      AMOUNT_CALCULATION_CODE
,      BILL_MARKUP_PERCENTAGE
,      RATE_SOURCE_ID
,      INV_GEN_REJECTION_CODE
,      RETENTION_RULE_ID
,      RETN_DRAFT_INVOICE_NUM
,      RETN_DRAFT_INVOICE_LINE_NUM
,      RETAINED_AMOUNT
,      RATE_DISC_REASON_CODE
,      REVTRANS_AMOUNT
,      REVTRANS_CURRENCY_CODE
,      REVPROC_REVTRANS_RATE_TYPE
,      REVPROC_REVTRANS_RATE_DATE
,      REVPROC_REVTRANS_EX_RATE
FROM APPS.PA_CUST_RDL_ALL_MRC_V;

Dependencies

[top of page]

APPS.PA_CUST_RDL_ALL_MRC_V references the following:

SchemaAPPS
SynonymPA_CUST_REV_DIST_LINES
SynonymPA_EXPENDITURE_ITEMS_ALL
SynonymPA_IMPLEMENTATIONS_ALL
SynonymPA_MC_CUST_RDL_ALL
APPS.PA_CUST_RDL_ALL_MRC_V is referenced by following:

SchemaAPPS
ViewPA_AEL_GL_DR_MRC_V
ViewPA_AEL_SL_DR_MRC_V