eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PA_IMPLEMENTATIONS_ALL_MRC_V

Object Details

Object Name:	PA_IMPLEMENTATIONS_ALL_MRC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_IMPLEMENTATIONS_ALL_MRC_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
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes
SET_OF_BOOKS_ID	NUMBER
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
ORGANIZATION_STRUCTURE_ID	NUMBER	(15)	Yes
ORG_STRUCTURE_VERSION_ID	NUMBER	(15)	Yes
START_ORGANIZATION_ID	NUMBER	(15)	Yes
USER_DEFINED_PROJECT_NUM_CODE	VARCHAR2	(25)	Yes
MANUAL_PROJECT_NUM_TYPE	VARCHAR2	(25)	Yes
PROJECT_ORGANIZATION_TYPE	VARCHAR2	(30)	Yes
EXP_CYCLE_START_DAY_CODE	VARCHAR2	(30)	Yes
OVERTIME_CALC_ENABLED_FLAG	VARCHAR2	(1)	Yes
INTERFACE_LABOR_TO_GL_FLAG	VARCHAR2	(1)	Yes
INTERFACE_USAGE_TO_GL_FLAG	VARCHAR2	(1)	Yes
INTERFACE_REVENUE_TO_GL_FLAG	VARCHAR2	(1)
BILLING_CYCLE	NUMBER	(15)
BILLING_OFFSET	NUMBER	(15)
USER_DEFINED_INVOICE_NUM_CODE	VARCHAR2	(25)
MANUAL_INVOICE_NUM_TYPE	VARCHAR2	(25)
INVOICE_ORGANIZATION_TYPE	VARCHAR2	(30)
INVOICE_BATCH_SOURCE_ID	NUMBER	(15)
ACCUMULATION_PERIOD_TYPE	VARCHAR2	(30)	Yes
PA_PERIOD_TYPE	VARCHAR2	(15)	Yes
NEXT_AUTOMATIC_INVOICE_NUMBER	NUMBER
ORG_ID	NUMBER	(15)	Yes
EXP_ORG_STRUCTURE_ID	NUMBER		Yes
EXP_ORG_STRUCTURE_VERSION_ID	NUMBER		Yes
EXP_START_ORG_ID	NUMBER		Yes
PROJ_ORG_STRUCTURE_ID	NUMBER		Yes
PROJ_ORG_STRUCTURE_VERSION_ID	NUMBER		Yes
PROJ_START_ORG_ID	NUMBER		Yes
CENTRALIZED_INVOICING_FLAG	VARCHAR2	(1)	Yes
DEFAULT_RATE_TYPE	VARCHAR2	(30)
DEFAULT_RATE_DATE_CODE	VARCHAR2	(1)
OUTPUT_TAX_USE_CUST_FLAG	VARCHAR2	(1)		Indicates whether tax rate defined for the customer will be used for customer invoice
OUTPUT_TAX_USE_SITE_FLAG	VARCHAR2	(1)		Indicates whether tax rate defined for the customers business purpose for customer invoice
OUTPUT_TAX_USE_PROJECT_FLAG	VARCHAR2	(1)		Indicates whether tax rate defined for the project will be used
OUTPUT_TAX_USE_EXP_EV_FLAG	VARCHAR2	(1)		Indicates whether tax rate defined for the expenditure type or event type will be used for customer invoices
OUTPUT_TAX_USE_EXTN_FLAG	VARCHAR2	(1)		Indicates whether tax rate returned by client extension will be used for customer invoices
OUTPUT_TAX_USE_AR_PARAM_FLAG	VARCHAR2	(1)		Indicates whether tax rate defined in AR system options will be used for customer invoices
OUTPUT_TAX_HIER_CUST	NUMBER			Indicates tax code defaulting hierarchy associated with customer level tax code for customer invoices
OUTPUT_TAX_HIER_SITE	NUMBER			Indicates tax code defaulting hierarchy associated with customer site level tax code for customer invoices
OUTPUT_TAX_HIER_PROJECT	NUMBER			Indicates tax code defaulting hierarchy associated with project level tax code for customer invoices
OUTPUT_TAX_HIER_EXP_EV	NUMBER			Indicates tax code defaulting hierarchy associated with expenditure type / event type level tax code for customer invoices
OUTPUT_TAX_HIER_EXTN	NUMBER			Indicates tax code defaulting hierarchy associated with using client extension returned tax code for customer invoices
OUTPUT_TAX_HIER_AR_PARAM	NUMBER			Indicates tax code defaulting hierarchy associated with AR system options for customer invoices
CC_PROCESS_IO_CODE	VARCHAR2	(1)
CC_DEFAULT_RATE_TYPE	VARCHAR2	(30)
CC_DEFAULT_RATE_DATE_CODE	VARCHAR2	(1)
CC_ALLOW_IU_FLAG	VARCHAR2	(1)
CC_PROCESS_IU_CODE	VARCHAR2	(1)
CC_IC_BILLING_PRVDR_FLAG	VARCHAR2	(1)
VENDOR_ID	NUMBER
CC_MANUAL_INVOICE_NUM_TYPE	VARCHAR2	(30)
CC_MANUAL_INVOICE_NUM_CODE	VARCHAR2	(30)
CC_NEXT_AUTOMATIC_INVOICE_NUM	NUMBER
CC_IC_AR_BATCH_SOURCE_ID	NUMBER	(20)
CC_PRVDR_CAC_COST_RECLASS_CODE	VARCHAR2	(1)
CC_PRVDR_OTH_COST_RECLASS_CODE	VARCHAR2	(1)
CC_IC_BILLING_RECVR_FLAG	VARCHAR2	(1)
CUSTOMER_ID	NUMBER
COMPETENCE_MATCH_WT	NUMBER
AVAILABILITY_MATCH_WT	NUMBER
JOB_LEVEL_MATCH_WT	NUMBER
MULTI_CURRENCY_BILLING_FLAG	VARCHAR2	(1)
SHARE_ACROSS_OU_BR_SCH_FLAG	VARCHAR2	(1)
ALLOW_FUNDING_ACROSS_OU_FLAG	VARCHAR2	(1)
PERIOD_SET_NAME	VARCHAR2	(15)
SAME_PA_GL_PERIOD	VARCHAR2	(1)
ADV_ACTION_SET_ID	NUMBER	(15)
RETN_ACCOUNTING_FLAG	VARCHAR2	(1)
FTE_DAY	NUMBER
FTE_WEEK	NUMBER
INCLUDE_GAINS_LOSSES_FLAG	VARCHAR2	(1)		This column indicates whether realized gains and losses shold be included in project revenue or not.
ENABLE_MRC_FOR_FUND_FLAG	VARCHAR2	(1)		This flag allows users to enable MRC for funding and budgets provided the MRC for projects is implemented.
RATE_DISCOUNT_REASON_FLAG	VARCHAR2	(1)		Determine whether Discount Reason is required with entry of override information and also if reason is required when entering discount % in billing schedules.
BR_OVERRIDE_FLAG	VARCHAR2	(1)		Controls the access to Rate and Markup % override fields.
BR_DISCOUNT_OVERRIDE_FLAG	VARCHAR2	(1)		Controls the access to Bill Rate Discount override field.
REVAL_MRC_FUNDING_FLAG	VARCHAR2	(1)		This flag indicates where the funding revaluation process has to rev aluate the reporting currency funding.
FINPLAN_MRC_OPTION_CODE	VARCHAR2	(1)		Indicates whether financial planning amounts are generated in each reporting currency for all working versions or only for baselined versions.
ENABLE_MRC_FOR_FINPLAN_FLAG	VARCHAR2	(1)		Indicates whether the financial planning amounts are generated in ea ch reporting currency.
BOOK_TYPE_CODE	VARCHAR2	(15)		Default Corporate Asset Book identifier.
SALES_CREDIT_TYPE_CODE	VARCHAR2	(240)		Name of Sales Credit Type
CREDIT_MEMO_REASON_FLAG	VARCHAR2	(1)		Credit Memo Reason Flag
CUST_ACC_REL_CODE	VARCHAR2	(30)		Customer Account Relationship Code
XFACE_CWK_LABOR_TO_GL_FLAG	VARCHAR2	(1)		Interface Contingent Worker Labor Costs
XFACE_CWK_TIMECARDS_FLAG	VARCHAR2	(1)		Import Contingent Worker Timecards with Purchase Order Integration

Query Text

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


SELECT LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SET_OF_BOOKS_ID
,      BUSINESS_GROUP_ID
,      ORGANIZATION_STRUCTURE_ID
,      ORG_STRUCTURE_VERSION_ID
,      START_ORGANIZATION_ID
,      USER_DEFINED_PROJECT_NUM_CODE
,      MANUAL_PROJECT_NUM_TYPE
,      PROJECT_ORGANIZATION_TYPE
,      EXP_CYCLE_START_DAY_CODE
,      OVERTIME_CALC_ENABLED_FLAG
,      INTERFACE_LABOR_TO_GL_FLAG
,      INTERFACE_USAGE_TO_GL_FLAG
,      INTERFACE_REVENUE_TO_GL_FLAG
,      BILLING_CYCLE
,      BILLING_OFFSET
,      USER_DEFINED_INVOICE_NUM_CODE
,      MANUAL_INVOICE_NUM_TYPE
,      INVOICE_ORGANIZATION_TYPE
,      INVOICE_BATCH_SOURCE_ID
,      ACCUMULATION_PERIOD_TYPE
,      PA_PERIOD_TYPE
,      NEXT_AUTOMATIC_INVOICE_NUMBER
,      ORG_ID
,      EXP_ORG_STRUCTURE_ID
,      EXP_ORG_STRUCTURE_VERSION_ID
,      EXP_START_ORG_ID
,      PROJ_ORG_STRUCTURE_ID
,      PROJ_ORG_STRUCTURE_VERSION_ID
,      PROJ_START_ORG_ID
,      CENTRALIZED_INVOICING_FLAG
,      DEFAULT_RATE_TYPE
,      DEFAULT_RATE_DATE_CODE
,      OUTPUT_TAX_USE_CUST_FLAG
,      OUTPUT_TAX_USE_SITE_FLAG
,      OUTPUT_TAX_USE_PROJECT_FLAG
,      OUTPUT_TAX_USE_EXP_EV_FLAG
,      OUTPUT_TAX_USE_EXTN_FLAG
,      OUTPUT_TAX_USE_AR_PARAM_FLAG
,      OUTPUT_TAX_HIER_CUST
,      OUTPUT_TAX_HIER_SITE
,      OUTPUT_TAX_HIER_PROJECT
,      OUTPUT_TAX_HIER_EXP_EV
,      OUTPUT_TAX_HIER_EXTN
,      OUTPUT_TAX_HIER_AR_PARAM
,      CC_PROCESS_IO_CODE
,      CC_DEFAULT_RATE_TYPE
,      CC_DEFAULT_RATE_DATE_CODE
,      CC_ALLOW_IU_FLAG
,      CC_PROCESS_IU_CODE
,      CC_IC_BILLING_PRVDR_FLAG
,      VENDOR_ID
,      CC_MANUAL_INVOICE_NUM_TYPE
,      CC_MANUAL_INVOICE_NUM_CODE
,      CC_NEXT_AUTOMATIC_INVOICE_NUM
,      CC_IC_AR_BATCH_SOURCE_ID
,      CC_PRVDR_CAC_COST_RECLASS_CODE
,      CC_PRVDR_OTH_COST_RECLASS_CODE
,      CC_IC_BILLING_RECVR_FLAG
,      CUSTOMER_ID
,      COMPETENCE_MATCH_WT
,      AVAILABILITY_MATCH_WT
,      JOB_LEVEL_MATCH_WT
,      MULTI_CURRENCY_BILLING_FLAG
,      SHARE_ACROSS_OU_BR_SCH_FLAG
,      ALLOW_FUNDING_ACROSS_OU_FLAG
,      PERIOD_SET_NAME
,      SAME_PA_GL_PERIOD
,      ADV_ACTION_SET_ID
,      RETN_ACCOUNTING_FLAG
,      FTE_DAY
,      FTE_WEEK
,      INCLUDE_GAINS_LOSSES_FLAG
,      ENABLE_MRC_FOR_FUND_FLAG
,      RATE_DISCOUNT_REASON_FLAG
,      BR_OVERRIDE_FLAG
,      BR_DISCOUNT_OVERRIDE_FLAG
,      REVAL_MRC_FUNDING_FLAG
,      FINPLAN_MRC_OPTION_CODE
,      ENABLE_MRC_FOR_FINPLAN_FLAG
,      BOOK_TYPE_CODE
,      SALES_CREDIT_TYPE_CODE
,      CREDIT_MEMO_REASON_FLAG
,      CUST_ACC_REL_CODE
,      XFACE_CWK_LABOR_TO_GL_FLAG
,      XFACE_CWK_TIMECARDS_FLAG
FROM APPS.PA_IMPLEMENTATIONS_ALL_MRC_V;

Dependencies

[top of page]

APPS.PA_IMPLEMENTATIONS_ALL_MRC_V references the following:

APPS: PA_IMPLEMENTATIONS_ALL

APPS.PA_IMPLEMENTATIONS_ALL_MRC_V is referenced by following:

APPS: PA_AEL_GL_DR_MRC_TMP_V; PA_AEL_GL_DR_MRC_V; PA_AEL_SL_DR_MRC_TMP_V; PA_AEL_SL_DR_MRC_V; PA_AEL_SL_EI_MRC_V