FND Design Data [Home] [Help]

View: PA_IMPLEMENTATIONS_ALL_MRC_V

Product: PA - Projects
Description:
Implementation/DBA Data: ViewAPPS.PA_IMPLEMENTATIONS_ALL_MRC_V
View Text

SELECT LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, NVL(TO_NUMBER( SUBSTR( USERENV('CLIENT_INFO')
, 45
, 10) )
, -99)
, 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 PA_IMPLEMENTATIONS_ALL

Columns

Name
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