Skip to content

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

VIEW: APPS.PA_CUST_REV_DIST_LINES_EI_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
EXPENDITURE_ITEM_ID NUMBER (15) Yes
LINE_NUM NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
PROJECT_ID NUMBER (15) Yes
DRAFT_REVENUE_NUM NUMBER (15) Yes
DRAFT_REVENUE_ITEM_LINE_NUM NUMBER (15) Yes
AMOUNT NUMBER (22) Yes
CODE_COMBINATION_ID NUMBER (15)
BILL_AMOUNT NUMBER (22)
FUNCTION_CODE VARCHAR2 (15)
FUNCTION_TRANSACTION_CODE VARCHAR2 (30)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

BATCH_NAME VARCHAR2 (30)
ADDITIONAL_REVENUE_FLAG VARCHAR2 (1)
INVOICE_ELIGIBLE_FLAG VARCHAR2 (1)
DRAFT_INVOICE_NUM NUMBER (15)
DRAFT_INVOICE_ITEM_LINE_NUM NUMBER (15)
REVERSED_FLAG VARCHAR2 (1)
LINE_NUM_REVERSED NUMBER (15)
REV_IND_COMPILED_SET_ID NUMBER (15)
INV_IND_COMPILED_SET_ID NUMBER (15)
RAW_COST NUMBER (22)
ORG_ID NUMBER (15)
OUTPUT_VAT_TAX_ID NUMBER

OUTPUT_TAX_CLASSIFICATION_CODE VARCHAR2 (50)
OUTPUT_TAX_EXEMPT_FLAG VARCHAR2 (1)
OUTPUT_TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
OUTPUT_TAX_EXEMPT_NUMBER VARCHAR2 (80)
PRC_GENERATED_FLAG VARCHAR2 (1)
BILL_TRANS_CURRENCY_CODE VARCHAR2 (15) Yes
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_REVENUE_AMOUNT NUMBER

PROJECT_REV_RATE_TYPE VARCHAR2 (30)
PROJECT_REV_RATE_DATE DATE

PROJECT_REV_EXCHANGE_RATE NUMBER

PROJECT_BILL_AMOUNT NUMBER

PROJECT_INV_RATE_TYPE VARCHAR2 (30)
PROJECT_INV_RATE_DATE DATE

PROJECT_INV_EXCHANGE_RATE NUMBER

PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
PROJFUNC_REVENUE_AMOUNT NUMBER

PROJFUNC_REV_RATE_TYPE VARCHAR2 (30)
PROJFUNC_REV_RATE_DATE DATE

PROJFUNC_REV_EXCHANGE_RATE NUMBER

PROJFUNC_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_REVENUE_AMOUNT NUMBER

FUNDING_REV_RATE_TYPE VARCHAR2 (30)
FUNDING_REV_RATE_DATE DATE

FUNDING_REV_EXCHANGE_RATE NUMBER

FUNDING_BILL_AMOUNT NUMBER

FUNDING_INV_RATE_TYPE VARCHAR2 (30)
FUNDING_INV_RATE_DATE DATE

FUNDING_INV_EXCHANGE_RATE 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)
RETN_DRAFT_INVOICE_NUM NUMBER

RETN_DRAFT_INVOICE_LINE_NUM NUMBER

RETAINED_AMOUNT NUMBER

RETENTION_RULE_ID NUMBER (15)
RATE_DISC_REASON_CODE VARCHAR2 (30)
MRC_PROJFUNC_CURRENCY_CODE VARCHAR2 (0)
MRC_AMOUNT VARCHAR2 (0)
Query Text

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


SELECT ROW_ID
,      EXPENDITURE_ITEM_ID
,      LINE_NUM
,      CREATION_DATE
,      CREATED_BY
,      PROJECT_ID
,      DRAFT_REVENUE_NUM
,      DRAFT_REVENUE_ITEM_LINE_NUM
,      AMOUNT
,      CODE_COMBINATION_ID
,      BILL_AMOUNT
,      FUNCTION_CODE
,      FUNCTION_TRANSACTION_CODE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      BATCH_NAME
,      ADDITIONAL_REVENUE_FLAG
,      INVOICE_ELIGIBLE_FLAG
,      DRAFT_INVOICE_NUM
,      DRAFT_INVOICE_ITEM_LINE_NUM
,      REVERSED_FLAG
,      LINE_NUM_REVERSED
,      REV_IND_COMPILED_SET_ID
,      INV_IND_COMPILED_SET_ID
,      RAW_COST
,      ORG_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
,      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_REVENUE_AMOUNT
,      PROJECT_REV_RATE_TYPE
,      PROJECT_REV_RATE_DATE
,      PROJECT_REV_EXCHANGE_RATE
,      PROJECT_BILL_AMOUNT
,      PROJECT_INV_RATE_TYPE
,      PROJECT_INV_RATE_DATE
,      PROJECT_INV_EXCHANGE_RATE
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_REVENUE_AMOUNT
,      PROJFUNC_REV_RATE_TYPE
,      PROJFUNC_REV_RATE_DATE
,      PROJFUNC_REV_EXCHANGE_RATE
,      PROJFUNC_BILL_AMOUNT
,      PROJFUNC_INV_RATE_TYPE
,      PROJFUNC_INV_RATE_DATE
,      PROJFUNC_INV_EXCHANGE_RATE
,      FUNDING_CURRENCY_CODE
,      FUNDING_REVENUE_AMOUNT
,      FUNDING_REV_RATE_TYPE
,      FUNDING_REV_RATE_DATE
,      FUNDING_REV_EXCHANGE_RATE
,      FUNDING_BILL_AMOUNT
,      FUNDING_INV_RATE_TYPE
,      FUNDING_INV_RATE_DATE
,      FUNDING_INV_EXCHANGE_RATE
,      LABOR_MULTIPLIER
,      DISCOUNT_PERCENTAGE
,      AMOUNT_CALCULATION_CODE
,      BILL_MARKUP_PERCENTAGE
,      RATE_SOURCE_ID
,      INV_GEN_REJECTION_CODE
,      RETN_DRAFT_INVOICE_NUM
,      RETN_DRAFT_INVOICE_LINE_NUM
,      RETAINED_AMOUNT
,      RETENTION_RULE_ID
,      RATE_DISC_REASON_CODE
,      MRC_PROJFUNC_CURRENCY_CODE
,      MRC_AMOUNT
FROM APPS.PA_CUST_REV_DIST_LINES_EI_V;

Dependencies

[top of page]

APPS.PA_CUST_REV_DIST_LINES_EI_V references the following:

SchemaAPPS
SynonymPA_CUST_REV_DIST_LINES_ALL

APPS.PA_CUST_REV_DIST_LINES_EI_V is not referenced by any database object