VIEW: APPS.PA_IMPLEMENTATIONS_ALL_MRC_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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