Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_IMPLEMENTATIONS_ALL_MRC_V |
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