Skip to content

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

VIEW: APPS.PA_CC_DIST_LINES_ALL_MRC_V

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

View Type

A multiple reporting currency view

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACCT_TP_EXCHANGE_RATE NUMBER

ACCT_TP_RATE_DATE DATE

ACCT_TP_RATE_TYPE VARCHAR2 (30)
AMOUNT NUMBER
Yes
BILL_MARKUP_PERCENTAGE NUMBER

BILL_RATE NUMBER

CC_DIST_LINE_ID NUMBER
Yes
CR_CODE_COMBINATION_ID NUMBER

CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CROSS_CHARGE_CODE VARCHAR2 (1) Yes
DENOM_TP_CURRENCY_CODE VARCHAR2 (15)
DENOM_TRANSFER_PRICE NUMBER

DIST_LINE_ID_REVERSED NUMBER

DR_CODE_COMBINATION_ID NUMBER

EXPENDITURE_ITEM_ID NUMBER (15) Yes
GL_BATCH_NAME VARCHAR2 (30)
GL_DATE DATE

IND_COMPILED_SET_ID NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATED_BY NUMBER (15) Yes
LINE_NUM NUMBER
Yes
LINE_NUM_REVERSED NUMBER

LINE_TYPE VARCHAR2 (2) Yes
MARKUP_CALC_BASE_CODE VARCHAR2 (1)
ORG_ID NUMBER

PA_DATE DATE

PRC_ASSIGNMENT_ID NUMBER (15) Yes
PROGRAM_APPLICATION_ID NUMBER (15) Yes
PROGRAM_ID NUMBER (15) Yes
PROGRAM_UPDATE_DATE DATE
Yes
PROJECT_ID NUMBER
Yes
REFERENCE_1 NUMBER

REFERENCE_2 VARCHAR2 (240)
REFERENCE_3 NUMBER

REQUEST_ID NUMBER (15) Yes
REVERSED_FLAG VARCHAR2 (1)
RULE_PERCENTAGE NUMBER

SET_OF_BOOKS_ID NUMBER (15) Yes
SCHEDULE_LINE_PERCENTAGE NUMBER

TASK_ID NUMBER
Yes
TP_BASE_AMOUNT NUMBER

TRANSFER_REJECTION_CODE VARCHAR2 (30)
TRANSFER_STATUS_CODE VARCHAR2 (30) Yes
TRANSFERRED_DATE DATE

GL_PERIOD_NAME VARCHAR2 (15)
PA_PERIOD_NAME VARCHAR2 (15)
PROJECT_TP_CURRENCY_CODE VARCHAR2 (15)
PROJECT_TP_RATE_DATE DATE

PROJECT_TP_RATE_TYPE VARCHAR2 (30)
PROJECT_TP_EXCHANGE_RATE NUMBER

PROJECT_TRANSFER_PRICE NUMBER

PROJFUNC_TP_CURRENCY_CODE VARCHAR2 (15)
PROJFUNC_TP_RATE_DATE DATE

PROJFUNC_TP_RATE_TYPE VARCHAR2 (30)
PROJFUNC_TP_EXCHANGE_RATE NUMBER

PROJFUNC_TRANSFER_PRICE NUMBER

TP_AMT_TYPE_CODE VARCHAR2 (30)
ACCT_CURRENCY_CODE VARCHAR2 (15) Yes
ACCT_EVENT_ID NUMBER (15)
Query Text

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


SELECT ACCT_TP_EXCHANGE_RATE
,      ACCT_TP_RATE_DATE
,      ACCT_TP_RATE_TYPE
,      AMOUNT
,      BILL_MARKUP_PERCENTAGE
,      BILL_RATE
,      CC_DIST_LINE_ID
,      CR_CODE_COMBINATION_ID
,      CREATED_BY
,      CREATION_DATE
,      CROSS_CHARGE_CODE
,      DENOM_TP_CURRENCY_CODE
,      DENOM_TRANSFER_PRICE
,      DIST_LINE_ID_REVERSED
,      DR_CODE_COMBINATION_ID
,      EXPENDITURE_ITEM_ID
,      GL_BATCH_NAME
,      GL_DATE
,      IND_COMPILED_SET_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LINE_NUM
,      LINE_NUM_REVERSED
,      LINE_TYPE
,      MARKUP_CALC_BASE_CODE
,      ORG_ID
,      PA_DATE
,      PRC_ASSIGNMENT_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROJECT_ID
,      REFERENCE_1
,      REFERENCE_2
,      REFERENCE_3
,      REQUEST_ID
,      REVERSED_FLAG
,      RULE_PERCENTAGE
,      SET_OF_BOOKS_ID
,      SCHEDULE_LINE_PERCENTAGE
,      TASK_ID
,      TP_BASE_AMOUNT
,      TRANSFER_REJECTION_CODE
,      TRANSFER_STATUS_CODE
,      TRANSFERRED_DATE
,      GL_PERIOD_NAME
,      PA_PERIOD_NAME
,      PROJECT_TP_CURRENCY_CODE
,      PROJECT_TP_RATE_DATE
,      PROJECT_TP_RATE_TYPE
,      PROJECT_TP_EXCHANGE_RATE
,      PROJECT_TRANSFER_PRICE
,      PROJFUNC_TP_CURRENCY_CODE
,      PROJFUNC_TP_RATE_DATE
,      PROJFUNC_TP_RATE_TYPE
,      PROJFUNC_TP_EXCHANGE_RATE
,      PROJFUNC_TRANSFER_PRICE
,      TP_AMT_TYPE_CODE
,      ACCT_CURRENCY_CODE
,      ACCT_EVENT_ID
FROM APPS.PA_CC_DIST_LINES_ALL_MRC_V;

Dependencies

[top of page]

APPS.PA_CC_DIST_LINES_ALL_MRC_V references the following:

SchemaAPPS
SynonymPA_CC_DIST_LINES_ALL
SynonymPA_MC_CC_DIST_LINES_ALL
APPS.PA_CC_DIST_LINES_ALL_MRC_V is referenced by following:

SchemaAPPS
ViewPA_AEL_SL_EI_MRC_V