daily pastebin goal
75%
SHARE
TWEET

Untitled

a guest Sep 14th, 2018 49 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO "IMT_ADMIN"."STAGE2_POSTV3_FL_OPPS_LEGACY" ( "RECORD_ID" , "FK_POST_ORG_ID" , "RELATED_ID" , "ASSIGNED_TO_POSITION" , "ASSIGNED_ORGANIZATION" , "MEETING_INVITEES" , "REVIEWERS_AND_APPROVERS" , "ASSIGNED_TO_F_NAME" , "ASSIGNED_TO_L_NAME" , "STATE" , "STATUS" , "STATUS_REASON" , "MTG_CHAIR" , "MEETING_LOCATION" , "REPEAT_ASSIGNED_TO" , "MEETING_TYPE" , "MASTER_MEETING_FREQUENCY" , "PROJECTS_CONTROL_CATEGORY" , "DATETIME_CREATED" , "DATETIME_UPDATED" , "CREATED_BY_NAME" , "ACCEPTANCE_CRITERIA" , "ACCEPTED_SOLUTION_DATE" , "ACCOUNT_SPECIFIC_PROCESS_NAME" , "ACTUAL_ACCEPTED_DATE" , "ACTUAL_COMPLETE_DATE" , "ACTUAL_COUNT" , "ACTUAL_COUNT_CORRECT_DATE" , "ACTUAL_DATE" , "ACTUAL_DATE_DELIVERED" , "ACTUAL_START_DATE" , "ACTUAL_VERIFIED_DATE" , "ADEQUATE_RESOURCES_ASSIGNED" , "AGREEMENT_REFERENCE" , "AGREEMENT_REFERENCE_DETAILS" , "ANALYSIS_DATE" , "X_AREA" , "BTT" , "BASELINE_OWNER" , "BASELINE_VALUE" , "BASELINE_VARIATION" , "BASELINE_VARIATION_DATE" , "BASELINES_AGREEMENT_REFERENCE" , "BASELINES_MGMT_KEYWORD" , "BASELINES_MGMT_FREQUENCY" , "BILLABLE" , "BILLING_COMPLETED" , "BUSINESS_CONTROLS_RISK" , "CUST_CPM" , "CANCELED_THE_RFS" , "CATEGORY" , "CLAIM_CODE" , "CONDITION" , "CONTINGENCY_PLAN" , "CONTRACT_CHANGE_KEYWORD" , "CONTRACT_CHANGE_REQUIRED" , "CONTRACT_METRIC" , "CONTRACT_REFERENCE" , "COUNTRY" , "CURRENT_BASELINE_VALUE" , "CUST_ACCOUNT_CODE" , "CUSTOMER_APPROVER" , "CUSTOMER_CONTACT" , "CUSTOMER_MEETING_FLAG" , "CUSTOMER_REFERENCE" , "CUSTOMER_REVIEW" , "CUSTOMER_SIGNOFF_FREQUENCY" , "FLAG_CUSTVIS" , "DATA_CLASSIFICATION" , "DATA_RECIPIENT" , "DATE_CLOSED" , "DATE_CUST_ACCEPTED_CHARGE" , "DATE_INVOICED" , "DATE_OPENED" , "DATE_SIGNED" , "FLAG_DELETE" , "DELIVERABLE_FREQUENCY" , "DELIVERY_AUTHORIZED" , "DEPENDENCY" , "DOC_VERSION" , "DUE_DATE" , "IBM_ACCOUNT_CODE" , "IBM_APPROVER" , "IBM_CPM" , "IBM_OWNER" , "IBM_RESTRICTED" , "IMPACT" , "IMPLEMENTATION_COMPLETED" , "IMPLEMENTATION_PLANNED" , "IMPLEMENTATION_REQUESTED" , "IMPLEMENTATION_REVISED" , "IN_SCOPE" , "KEY_DATE" , "PROGRAM_KEYWORD" , "LEVEL_OF_APPROVAL" , "LOCATION" , "LONG_DESCRIPTION" , "MPS" , "MASTER_MEETING_STATUS" , "END_DATE_TIME" , "MITIGATION_MEASURES" , "MITIGATION_PLAN" , "NEW_BASELINE_VALUE" , "OCCURENCE_FREQUENCY" , "OPPORTUNITY_OWNER" , "OPPORTUNITY_TYPE" , "ORIGINAL_BASELINE_DATE" , "ORIGINAL_BASELINE_VALUE" , "ORIGINATING_COMPANY" , "ORIGINATING_ORGANIZATION" , "ORIGINATOR" , "RELATED_PROCESS" , "PLAN_DATE" , "PRICING_COMPLETED_DATE" , "PRIORITY" , "PROBABILITY" , "PROCESS" , "PROGRAM_DATE_1" , "PROGRAM_DATE_2" , "PROGRAM_DATE_3" , "PROGRAM_DATE_4" , "PROGRAM_DEFINED_1" , "PROGRAM_DEFINED_2" , "PROGRAM_DEFINED_3" , "PROGRAM_DEFINED_4" , "PROGRAM_DEFINED_5" , "PROGRAM_DEFINED_6" , "PROJECT_APPROVED_DATE" , "PROJECT_DEPENDENCIES" , "PROJECT_PLAN_AVAILABLE" , "PROJECTS_CONTROL_DATA_CLASS" , "PROJECTS_CONTROL_KEYWORD" , "PROPOSAL_COMPLETED" , "PROPOSAL_PLANNED" , "PROPOSAL_PLANNED_REVISION" , "PROPOSAL_REQUESTED" , "PROPOSAL_RESPONSE_ACCEPTED" , "PROPOSAL_RESPONSE_PLANNED" , "PROPOSAL_RESPONSE_REJECTED" , "QA2_COMPLETED" , "QA3_COMPLETED" , "QUALIFICATON_DATE" , "QUALIFIED" , "REASON_FOR_RECALCULATION" , "RECALCULATE_BASELINE" , "REGION" , "REJECTED_THE_RFS" , "REMARKS" , "REMEDIATION_PLAN" , "REMEDIATION_PLAN_REQUIRED" , "REPEAT_STATUS" , "REPEATING_DELIVERABLE" , "REPEATING_MEETING_END_DATE" , "REQUEST_ACCEPTED" , "REQUEST_SUBMITTED" , "REQUESTED_COMPLETION_DATE" , "REQUESTED_START_DATE" , "REQUIRED_FOR_BILLING" , "REQUIRED_FOR_SLA" , "REQUIREMENTS_AGREED" , "RESOLUTION" , "RESPONSE_DESCRIPTION" , "RISK_FACTORS" , "RISK_REVIEW_FREQUENCY" , "RISK_KEYWORD" , "RISK_RESPONSE" , "SEND_NOTIFICATION" , "SERVICE_PROVIDER_ORG" , "SOLUTION_ACCEPTED" , "SOLUTION_COMPLETED" , "SOLUTION_PLANNED" , "START_DATE_TIME" , "STATUS_REPORT_FREQUENCY" , "STATUS_REPORTING_REQ" , "SYSTEM" , "TIMEFRAME" , "TYPE_OF_BASELINE" , "TYPE_OF_PROJECTS_CONTROL" , "TYPE_OF_RISK" , "VARIATION_DESCRIPTION" , "VERSION" , "VERSION_DATE" , "BRIEF_DESCRIPTION" , "ACCEPTED_ASS_CHARGE_TEXT" , "ACTUAL_ASS_CHARGE_NUM_ORIG" , "ACTUAL_ASS_COST_NUM_ORIG" , "CONTINGENCY_COST_NUM_ORIG" , "COST_NUM_ORIG" , "ESTIMATED_ASS_CHARGE_NUM_ORIG" , "ESTIMATED_ASS_COST_NUM_ORIG" , "EXPOSURE_NUM_ORIG" , "LOCAL_CONTIN_COST_NUM_ORIG" , "LOCAL_COST_NUM_ORIG" , "LOCAL_EXPOSURE_NUM_ORIG" , "LOCAL_PRICE_NUM_ORIG" , "PRICE_NUM_ORIG" , "PROGRAM_DEFINED_FIN_NUM_ORIG" , "PLAN_START_DATE" , "TITLE" , "PGM_DEF_FIN_CRCYCD" , "PRICE_CRCYCD" , "LOCAL_PRICE_CRCYCD" , "COST_CRCYCD" , "LOCAL_COST_CRCYCD" , "EXPOSURE_CRCYCD" , "LOCAL_EXPOSURE_CRCYCD" , "CONTIN_COST_CRCYCD" , "LOCAL_CONTIN_COST_CRCYCD" , "EST_ASS_CHG_CRCYCD" , "EST_ASS_COST_CRCYCD" , "ACT_ASS_COST_CRCYCD" , "ACT_ASS_CHG_CRCYCD" , "PGM_DEF_FIN_DATE" , "PRICE_DATE" , "LOCAL_PRICE_DATE" , "COST_DATE" , "LOCAL_COST_DATE" , "EXPOSURE_DATE" , "LOCAL_EXPOSURE_DATE" , "CONTIN_COST_DATE" , "LOCAL_CONTIN_COST_DATE" , "SRC_SYS_CD" , "PUBLIC_TEXT_2" , "PUBLIC_TEXT_3" , "PUBLIC_TEXT_4" , "PUBLIC_DATE_1" , "PUBLIC_DATE_2" , "PUBLIC_DATE_3" , "PUBLIC_DATE_4" , "PUBLIC_DATE_5" , "POST_LEGACY_ID" , "PGMP_COMPLEXITY" )
  2. SELECT  "STAGE2_POSTV3_FL_OPPS"."RECORD_ID"  ,  "STAGE2_POSTV3_FL_OPPS"."FK_POST_ORG_ID"  ,  "STAGE2_POSTV3_FL_OPPS"."RELATED_ID"  ,  "STAGE2_POSTV3_FL_OPPS"."ASSIGNED_TO_POSITION"  ,  "STAGE2_POSTV3_FL_OPPS"."ASSIGNED_ORGANIZATION"  ,  "STAGE2_POSTV3_FL_OPPS"."MEETING_INVITEES"  ,  "STAGE2_POSTV3_FL_OPPS"."REVIEWERS_AND_APPROVERS"  ,  "STAGE2_POSTV3_FL_OPPS"."ASSIGNED_TO_F_NAME"  ,  "STAGE2_POSTV3_FL_OPPS"."ASSIGNED_TO_L_NAME"  ,  "STAGE2_POSTV3_FL_OPPS"."STATE"  ,  "STAGE2_POSTV3_FL_OPPS"."STATUS"  ,  "STAGE2_POSTV3_FL_OPPS"."STATUS_REASON"  ,  "STAGE2_POSTV3_FL_OPPS"."MTG_CHAIR"  ,  "STAGE2_POSTV3_FL_OPPS"."MEETING_LOCATION"  ,  "STAGE2_POSTV3_FL_OPPS"."REPEAT_ASSIGNED_TO"  ,  "STAGE2_POSTV3_FL_OPPS"."MEETING_TYPE"  ,  "STAGE2_POSTV3_FL_OPPS"."MASTER_MEETING_FREQUENCY"  ,  "STAGE2_POSTV3_FL_OPPS"."PROJECTS_CONTROL_CATEGORY"  ,  "STAGE2_POSTV3_FL_OPPS"."DATETIME_CREATED"  ,  "STAGE2_POSTV3_FL_OPPS"."DATETIME_UPDATED"  ,  "STAGE2_POSTV3_FL_OPPS"."CREATED_BY_NAME"  ,  "STAGE2_POSTV3_FL_OPPS"."ACCEPTANCE_CRITERIA"  ,  "STAGE2_POSTV3_FL_OPPS"."ACCEPTED_SOLUTION_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."ACCOUNT_SPECIFIC_PROCESS_NAME"  ,  "STAGE2_POSTV3_FL_OPPS"."ACTUAL_ACCEPTED_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."ACTUAL_COMPLETE_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."ACTUAL_COUNT"  ,  "STAGE2_POSTV3_FL_OPPS"."ACTUAL_COUNT_CORRECT_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."ACTUAL_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."ACTUAL_DATE_DELIVERED"  ,  "STAGE2_POSTV3_FL_OPPS"."ACTUAL_START_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."ACTUAL_VERIFIED_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."ADEQUATE_RESOURCES_ASSIGNED"  ,  "STAGE2_POSTV3_FL_OPPS"."AGREEMENT_REFERENCE"  ,  "STAGE2_POSTV3_FL_OPPS"."AGREEMENT_REFERENCE_DETAILS"  ,  "STAGE2_POSTV3_FL_OPPS"."ANALYSIS_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."X_AREA"  ,  "STAGE2_POSTV3_FL_OPPS"."BTT"  ,  "STAGE2_POSTV3_FL_OPPS"."BASELINE_OWNER"  ,  "STAGE2_POSTV3_FL_OPPS"."BASELINE_VALUE"  ,  "STAGE2_POSTV3_FL_OPPS"."BASELINE_VARIATION"  ,  "STAGE2_POSTV3_FL_OPPS"."BASELINE_VARIATION_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."BASELINES_AGREEMENT_REFERENCE"  ,  "STAGE2_POSTV3_FL_OPPS"."BASELINES_MGMT_KEYWORD"  ,  "STAGE2_POSTV3_FL_OPPS"."BASELINES_MGMT_FREQUENCY"  ,  "STAGE2_POSTV3_FL_OPPS"."BILLABLE"  ,  "STAGE2_POSTV3_FL_OPPS_FULLLOAD"."BILLING_COMPLETED"  ,  "STAGE2_POSTV3_FL_OPPS"."BUSINESS_CONTROLS_RISK"  ,  "STAGE2_POSTV3_FL_OPPS"."CUST_CPM"  ,  "STAGE2_POSTV3_FL_OPPS"."CANCELED_THE_RFS"  ,  "STAGE2_POSTV3_FL_OPPS"."CATEGORY"  ,  "STAGE2_POSTV3_FL_OPPS"."CLAIM_CODE"  ,  "STAGE2_POSTV3_FL_OPPS"."CONDITION"  ,  "STAGE2_POSTV3_FL_OPPS"."CONTINGENCY_PLAN"  ,  "STAGE2_POSTV3_FL_OPPS"."CONTRACT_CHANGE_KEYWORD"  ,  "STAGE2_POSTV3_FL_OPPS"."CONTRACT_CHANGE_REQUIRED"  ,  "STAGE2_POSTV3_FL_OPPS"."CONTRACT_METRIC"  ,  "STAGE2_POSTV3_FL_OPPS"."CONTRACT_REFERENCE"  ,  "STAGE2_POSTV3_FL_OPPS"."COUNTRY"  ,  "STAGE2_POSTV3_FL_OPPS"."CURRENT_BASELINE_VALUE"  ,  "STAGE2_POSTV3_FL_OPPS"."CUST_ACCOUNT_CODE"  ,  "STAGE2_POSTV3_FL_OPPS"."CUSTOMER_APPROVER"  ,  "STAGE2_POSTV3_FL_OPPS"."CUSTOMER_CONTACT"  ,  "STAGE2_POSTV3_FL_OPPS"."CUSTOMER_MEETING_FLAG"  ,  "STAGE2_POSTV3_FL_OPPS"."CUSTOMER_REFERENCE"  ,  "STAGE2_POSTV3_FL_OPPS"."CUSTOMER_REVIEW"  ,  "STAGE2_POSTV3_FL_OPPS"."CUSTOMER_SIGNOFF_FREQUENCY"  ,  "STAGE2_POSTV3_FL_OPPS"."FLAG_CUSTVIS"  ,  "STAGE2_POSTV3_FL_OPPS"."DATA_CLASSIFICATION"  ,  "STAGE2_POSTV3_FL_OPPS"."DATA_RECIPIENT"  ,  "STAGE2_POSTV3_FL_OPPS"."DATE_CLOSED"  ,  "STAGE2_POSTV3_FL_OPPS"."DATE_CUST_ACCEPTED_CHARGE"  ,  "STAGE2_POSTV3_FL_OPPS"."DATE_INVOICED"  ,  "STAGE2_POSTV3_FL_OPPS"."DATE_OPENED"  ,  "STAGE2_POSTV3_FL_OPPS"."DATE_SIGNED"  ,  "STAGE2_POSTV3_FL_OPPS"."FLAG_DELETE"  ,  "STAGE2_POSTV3_FL_OPPS"."DELIVERABLE_FREQUENCY"  ,  "STAGE2_POSTV3_FL_OPPS_FULLLOAD"."DELIVERY_AUTHORIZED"  ,  "STAGE2_POSTV3_FL_OPPS"."DEPENDENCY"  ,  "STAGE2_POSTV3_FL_OPPS"."DOC_VERSION"  ,  "STAGE2_POSTV3_FL_OPPS"."DUE_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."IBM_ACCOUNT_CODE"  ,  "STAGE2_POSTV3_FL_OPPS"."IBM_APPROVER"  ,  "STAGE2_POSTV3_FL_OPPS"."IBM_CPM"  ,  "STAGE2_POSTV3_FL_OPPS"."IBM_OWNER"  ,  "STAGE2_POSTV3_FL_OPPS"."IBM_RESTRICTED"  ,  "STAGE2_POSTV3_FL_OPPS"."IMPACT"  ,  "STAGE2_POSTV3_FL_OPPS"."IMPLEMENTATION_COMPLETED"  ,  "STAGE2_POSTV3_FL_OPPS"."IMPLEMENTATION_PLANNED"  ,  "STAGE2_POSTV3_FL_OPPS"."IMPLEMENTATION_REQUESTED"  ,  "STAGE2_POSTV3_FL_OPPS"."IMPLEMENTATION_REVISED"  ,  "STAGE2_POSTV3_FL_OPPS"."IN_SCOPE"  ,  "STAGE2_POSTV3_FL_OPPS"."KEY_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."PROGRAM_KEYWORD"  ,  "STAGE2_POSTV3_FL_OPPS"."LEVEL_OF_APPROVAL"  ,  "STAGE2_POSTV3_FL_OPPS"."LOCATION"  ,  "STAGE2_POSTV3_FL_OPPS"."LONG_DESCRIPTION"  ,  "STAGE2_POSTV3_FL_OPPS"."MPS"  ,  "STAGE2_POSTV3_FL_OPPS"."MASTER_MEETING_STATUS"  ,  "STAGE2_POSTV3_FL_OPPS"."END_DATE_TIME"  ,  "STAGE2_POSTV3_FL_OPPS"."MITIGATION_MEASURES"  ,  "STAGE2_POSTV3_FL_OPPS"."MITIGATION_PLAN"  ,  "STAGE2_POSTV3_FL_OPPS"."NEW_BASELINE_VALUE"  ,  "STAGE2_POSTV3_FL_OPPS"."OCCURENCE_FREQUENCY"  ,  "STAGE2_POSTV3_FL_OPPS"."OPPORTUNITY_OWNER"  ,  "STAGE2_POSTV3_FL_OPPS"."OPPORTUNITY_TYPE"  ,  "STAGE2_POSTV3_FL_OPPS"."ORIGINAL_BASELINE_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."ORIGINAL_BASELINE_VALUE"  ,  "STAGE2_POSTV3_FL_OPPS"."ORIGINATING_COMPANY"  ,  "STAGE2_POSTV3_FL_OPPS"."ORIGINATING_ORGANIZATION"  ,  "STAGE2_POSTV3_FL_OPPS"."ORIGINATOR"  ,  "STAGE2_POSTV3_FL_OPPS"."RELATED_PROCESS"  ,  "STAGE2_POSTV3_FL_OPPS"."PLAN_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."PRICING_COMPLETED_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."PRIORITY"  ,  "STAGE2_POSTV3_FL_OPPS"."PROBABILITY"  ,  "STAGE2_POSTV3_FL_OPPS"."PROCESS"  ,  "STAGE2_POSTV3_FL_OPPS"."PROGRAM_DATE_1"  ,  "STAGE2_POSTV3_FL_OPPS"."PROGRAM_DATE_2"  ,  "STAGE2_POSTV3_FL_OPPS_FULLLOAD"."PROGRAM_DATE_3"  ,  "STAGE2_POSTV3_FL_OPPS"."PROGRAM_DATE_4"  ,  "STAGE2_POSTV3_FL_OPPS"."PROGRAM_DEFINED_1"  ,  "STAGE2_POSTV3_FL_OPPS"."PROGRAM_DEFINED_2"  ,  "STAGE2_POSTV3_FL_OPPS"."PROGRAM_DEFINED_3"  ,  "STAGE2_POSTV3_FL_OPPS"."PROGRAM_DEFINED_4"  ,  "STAGE2_POSTV3_FL_OPPS"."PROGRAM_DEFINED_5"  ,  "STAGE2_POSTV3_FL_OPPS"."PROGRAM_DEFINED_6"  ,  "STAGE2_POSTV3_FL_OPPS"."PROJECT_APPROVED_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."PROJECT_DEPENDENCIES"  ,  "STAGE2_POSTV3_FL_OPPS"."PROJECT_PLAN_AVAILABLE"  ,  "STAGE2_POSTV3_FL_OPPS"."PROJECTS_CONTROL_DATA_CLASS"  ,  "STAGE2_POSTV3_FL_OPPS"."PROJECTS_CONTROL_KEYWORD"  ,  "STAGE2_POSTV3_FL_OPPS"."PROPOSAL_COMPLETED"  ,  "STAGE2_POSTV3_FL_OPPS"."PROPOSAL_PLANNED"  ,  "STAGE2_POSTV3_FL_OPPS"."PROPOSAL_PLANNED_REVISION"  ,  "STAGE2_POSTV3_FL_OPPS"."PROPOSAL_REQUESTED"  ,  "STAGE2_POSTV3_FL_OPPS"."PROPOSAL_RESPONSE_ACCEPTED"  ,  "STAGE2_POSTV3_FL_OPPS"."PROPOSAL_RESPONSE_PLANNED"  ,  "STAGE2_POSTV3_FL_OPPS"."PROPOSAL_RESPONSE_REJECTED"  ,  "STAGE2_POSTV3_FL_OPPS"."QA2_COMPLETED"  ,  "STAGE2_POSTV3_FL_OPPS"."QA3_COMPLETED"  ,  "STAGE2_POSTV3_FL_OPPS"."QUALIFICATON_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."QUALIFIED"  ,  "STAGE2_POSTV3_FL_OPPS"."REASON_FOR_RECALCULATION"  ,  "STAGE2_POSTV3_FL_OPPS"."RECALCULATE_BASELINE"  ,  "STAGE2_POSTV3_FL_OPPS"."REGION"  ,  "STAGE2_POSTV3_FL_OPPS"."REJECTED_THE_RFS"  ,  "STAGE2_POSTV3_FL_OPPS"."REMARKS"  ,  "STAGE2_POSTV3_FL_OPPS"."REMEDIATION_PLAN"  ,  "STAGE2_POSTV3_FL_OPPS"."REMEDIATION_PLAN_REQUIRED"  ,  "STAGE2_POSTV3_FL_OPPS"."REPEAT_STATUS"  ,  "STAGE2_POSTV3_FL_OPPS"."REPEATING_DELIVERABLE"  ,  "STAGE2_POSTV3_FL_OPPS"."REPEATING_MEETING_END_DATE"  ,  "STAGE2_POSTV3_FL_OPPS_FULLLOAD"."REQUEST_ACCEPTED"  ,  "STAGE2_POSTV3_FL_OPPS"."REQUEST_SUBMITTED"  ,  "STAGE2_POSTV3_FL_OPPS"."REQUESTED_COMPLETION_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."REQUESTED_START_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."REQUIRED_FOR_BILLING"  ,  "STAGE2_POSTV3_FL_OPPS"."REQUIRED_FOR_SLA"  ,  "STAGE2_POSTV3_FL_OPPS"."REQUIREMENTS_AGREED"  ,  "STAGE2_POSTV3_FL_OPPS"."RESOLUTION"  ,  "STAGE2_POSTV3_FL_OPPS"."RESPONSE_DESCRIPTION"  ,  "STAGE2_POSTV3_FL_OPPS"."RISK_FACTORS"  ,  "STAGE2_POSTV3_FL_OPPS"."RISK_REVIEW_FREQUENCY"  ,  "STAGE2_POSTV3_FL_OPPS"."RISK_KEYWORD"  ,  "STAGE2_POSTV3_FL_OPPS"."RISK_RESPONSE"  ,  "STAGE2_POSTV3_FL_OPPS"."SEND_NOTIFICATION"  ,  "STAGE2_POSTV3_FL_OPPS"."SERVICE_PROVIDER_ORG"  ,  "STAGE2_POSTV3_FL_OPPS"."SOLUTION_ACCEPTED"  ,  "STAGE2_POSTV3_FL_OPPS"."SOLUTION_COMPLETED"  ,  "STAGE2_POSTV3_FL_OPPS"."SOLUTION_PLANNED"  ,  "STAGE2_POSTV3_FL_OPPS"."START_DATE_TIME"  ,  "STAGE2_POSTV3_FL_OPPS"."STATUS_REPORT_FREQUENCY"  ,  "STAGE2_POSTV3_FL_OPPS"."STATUS_REPORTING_REQ"  ,  "STAGE2_POSTV3_FL_OPPS"."SYSTEM"  ,  "STAGE2_POSTV3_FL_OPPS"."TIMEFRAME"  ,  "STAGE2_POSTV3_FL_OPPS"."TYPE_OF_BASELINE"  ,  "STAGE2_POSTV3_FL_OPPS"."TYPE_OF_PROJECTS_CONTROL"  ,  "STAGE2_POSTV3_FL_OPPS"."TYPE_OF_RISK"  ,  "STAGE2_POSTV3_FL_OPPS"."VARIATION_DESCRIPTION"  ,  "STAGE2_POSTV3_FL_OPPS"."VERSION"  ,  "STAGE2_POSTV3_FL_OPPS"."VERSION_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."BRIEF_DESCRIPTION"  ,  "STAGE2_POSTV3_FL_OPPS"."ACCEPTED_ASS_CHARGE_TEXT"  ,  "STAGE2_POSTV3_FL_OPPS"."ACTUAL_ASS_CHARGE_NUM_ORIG"  ,  "STAGE2_POSTV3_FL_OPPS"."ACTUAL_ASS_COST_NUM_ORIG"  ,  "STAGE2_POSTV3_FL_OPPS"."CONTINGENCY_COST_NUM_ORIG"  ,  "STAGE2_POSTV3_FL_OPPS"."COST_NUM_ORIG"  ,  "STAGE2_POSTV3_FL_OPPS"."ESTIMATED_ASS_CHARGE_NUM_ORIG"  ,  "STAGE2_POSTV3_FL_OPPS"."ESTIMATED_ASS_COST_NUM_ORIG"  ,  "STAGE2_POSTV3_FL_OPPS"."EXPOSURE_NUM_ORIG"  ,  "STAGE2_POSTV3_FL_OPPS"."LOCAL_CONTIN_COST_NUM_ORIG"  ,  "STAGE2_POSTV3_FL_OPPS"."LOCAL_COST_NUM_ORIG"  ,  "STAGE2_POSTV3_FL_OPPS"."LOCAL_EXPOSURE_NUM_ORIG"  ,  "STAGE2_POSTV3_FL_OPPS"."LOCAL_PRICE_NUM_ORIG"  ,  "STAGE2_POSTV3_FL_OPPS"."PRICE_NUM_ORIG"  ,  "STAGE2_POSTV3_FL_OPPS"."PROGRAM_DEFINED_FIN_NUM_ORIG"  ,  "STAGE2_POSTV3_FL_OPPS"."PLAN_START_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."TITLE"  ,  "STAGE2_POSTV3_FL_OPPS"."PGM_DEF_FIN_CRCYCD"  ,  "STAGE2_POSTV3_FL_OPPS"."PRICE_CRCYCD"  ,  "STAGE2_POSTV3_FL_OPPS"."LOCAL_PRICE_CRCYCD"  ,  "STAGE2_POSTV3_FL_OPPS"."COST_CRCYCD"  ,  "STAGE2_POSTV3_FL_OPPS"."LOCAL_COST_CRCYCD"  ,  "STAGE2_POSTV3_FL_OPPS"."EXPOSURE_CRCYCD"  ,  "STAGE2_POSTV3_FL_OPPS"."LOCAL_EXPOSURE_CRCYCD"  ,  "STAGE2_POSTV3_FL_OPPS"."CONTIN_COST_CRCYCD"  ,  "STAGE2_POSTV3_FL_OPPS"."LOCAL_CONTIN_COST_CRCYCD"  ,  "STAGE2_POSTV3_FL_OPPS"."EST_ASS_CHG_CRCYCD"  ,  "STAGE2_POSTV3_FL_OPPS"."EST_ASS_COST_CRCYCD"  ,  "STAGE2_POSTV3_FL_OPPS"."ACT_ASS_COST_CRCYCD"  ,  "STAGE2_POSTV3_FL_OPPS"."ACT_ASS_CHG_CRCYCD"  ,  "STAGE2_POSTV3_FL_OPPS"."PGM_DEF_FIN_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."PRICE_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."LOCAL_PRICE_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."COST_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."LOCAL_COST_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."EXPOSURE_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."LOCAL_EXPOSURE_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."CONTIN_COST_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."LOCAL_CONTIN_COST_DATE"  ,  "STAGE2_POSTV3_FL_OPPS"."SRC_SYS_CD"  ,  "STAGE2_POSTV3_FL_OPPS"."PUBLIC_TEXT_2"  ,  "STAGE2_POSTV3_FL_OPPS"."PUBLIC_TEXT_3"  ,  "STAGE2_POSTV3_FL_OPPS"."PUBLIC_TEXT_4"  ,  "STAGE2_POSTV3_FL_OPPS"."PUBLIC_DATE_1"  ,  "STAGE2_POSTV3_FL_OPPS"."PUBLIC_DATE_2"  ,  "STAGE2_POSTV3_FL_OPPS"."PUBLIC_DATE_3"  ,  "STAGE2_POSTV3_FL_OPPS"."PUBLIC_DATE_4"  ,  "STAGE2_POSTV3_FL_OPPS"."PUBLIC_DATE_5"  ,  "STAGE2_POSTV3_FL_OPPS"."POST_LEGACY_ID"  ,  "STAGE2_POSTV3_FL_OPPS"."PGMP_COMPLEXITY"
  3. FROM "IMT_ADMIN"."STAGE2_POSTV3_FL_OPPS_FULLLOAD" "STAGE2_POSTV3_FL_OPPS_FULLLOAD", "IMT_ADMIN"."STAGE2_POSTV3_FL_OPPS" "STAGE2_POSTV3_FL_OPPS"
  4.  where ( "STAGE2_POSTV3_FL_OPPS"."POST_LEGACY_ID"  =  "STAGE2_POSTV3_FL_OPPS_FULLLOAD"."RECORD_ID" ) AND ( "STAGE2_POSTV3_FL_OPPS"."POST_LEGACY_ID"  IS NOT NULL ) AND (length( "STAGE2_POSTV3_FL_OPPS"."POST_LEGACY_ID" ) <> 0) AND ( "STAGE2_POSTV3_FL_OPPS"."SRC_SYS_CD"  = 'PgMP')
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top