[Home] [Help]
901: || 'RECO_START_DATE,'
902: || 'RECO_COMPLETION_DATE,'
903: || 'OPERATION_SEQUENCE_ID,'
904: || 'ORGANIZATION_ID,'
905: || 'STANDARD_OPERATION_CODE,'
906: || 'DEPARTMENT_ID,'
907: || 'OPERATION_LEAD_TIME_PERCENT,'
908: || 'MINIMUM_TRANSFER_QUANTITY,'
909: || 'EFFECTIVITY_DATE,'
950: || 'RECO_START_DATE,'
951: || 'RECO_COMPLETION_DATE,'
952: || 'OPERATION_SEQUENCE_ID,'
953: || 'ORGANIZATION_ID,'
954: || 'STANDARD_OPERATION_CODE,'
955: || 'DEPARTMENT_ID,'
956: || 'OPERATION_LEAD_TIME_PERCENT,'
957: || 'MINIMUM_TRANSFER_QUANTITY,'
958: || 'EFFECTIVITY_DATE,'
8048: || 'NET_PLANNING_PERCENT,'
8049: || 'TEAR_DOWN_DURATION,'
8050: || 'SETUP_DURATION,'
8051: || 'UOM_CODE,'
8052: || 'STANDARD_OPERATION_CODE,'
8053: || 'ORGANIZATION_ID,'
8054: || 'DELETED_FLAG,'
8055: || 'LAST_UPDATE_DATE,'
8056: || 'LAST_UPDATED_BY,'
8105: || 'NET_PLANNING_PERCENT,'
8106: || 'TEAR_DOWN_DURATION,'
8107: || 'SETUP_DURATION,'
8108: || 'UOM_CODE,'
8109: || 'STANDARD_OPERATION_CODE,'
8110: || 'ORGANIZATION_ID,'
8111: || 'DELETED_FLAG,'
8112: || 'LAST_UPDATE_DATE,'
8113: || 'LAST_UPDATED_BY,'
10125: || 'BUILT_IN_WIP_FLAG,'
10126: || 'PURCHASING_ENABLED_FLAG,'
10127: || 'PLANNING_MAKE_BUY_CODE,'
10128: || 'REPETITIVE_TYPE,'
10129: || 'STANDARD_COST,'
10130: || 'CARRYING_COST,'
10131: || 'ORDER_COST,'
10132: || 'DMD_LATENESS_COST,'
10133: || 'SS_PENALTY_COST,'
10288: || 'BUILT_IN_WIP_FLAG,'
10289: || 'PURCHASING_ENABLED_FLAG,'
10290: || 'PLANNING_MAKE_BUY_CODE,'
10291: || 'REPETITIVE_TYPE,'
10292: || 'STANDARD_COST,'
10293: || 'CARRYING_COST,'
10294: || 'ORDER_COST,'
10295: || 'DMD_LATENESS_COST,'
10296: || 'SS_PENALTY_COST,'
12028: || 'RESOURCE_ID,'
12029: || 'ORGANIZATION_ID,'
12030: || 'FROM_SETUP_ID,'
12031: || 'TO_SETUP_ID,'
12032: || 'STANDARD_OPERATION_CODE,'
12033: || 'FROM_SETUP_CODE,'
12034: || 'TO_SETUP_CODE,'
12035: || 'TRANSITION_TIME,'
12036: || 'TRANSITION_UOM,'
12056: || 'REQUEST_ID,'
12057: || 'PROGRAM_APPLICATION_ID,'
12058: || 'PROGRAM_ID,'
12059: || 'PROGRAM_UPDATE_DATE,'
12060: || 'STANDARD_OPERATION_ID '
12061: || ')'
12062: ||'SELECT '
12063: || ':v_inst_rp_src_id,'
12064: || 'RESOURCE_ID,'
12064: || 'RESOURCE_ID,'
12065: || 'ORGANIZATION_ID,'
12066: || 'FROM_SETUP_ID,'
12067: || 'TO_SETUP_ID,'
12068: || 'STANDARD_OPERATION_CODE,'
12069: || 'FROM_SETUP_CODE,'
12070: || 'TO_SETUP_CODE,'
12071: || 'TRANSITION_TIME,'
12072: || 'TRANSITION_UOM,'
12092: || 'REQUEST_ID,'
12093: || 'PROGRAM_APPLICATION_ID,'
12094: || 'PROGRAM_ID,'
12095: || 'PROGRAM_UPDATE_DATE,'
12096: || 'STANDARD_OPERATION_ID '
12097: ||'FROM MSC_ST_SETUP_TRANSITIONS'|| v_dblink
12098: ||' WHERE '
12099: ||' sr_instance_id = ' || to_char(v_src_instance_id);
12100:
12248: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'COPY_STD_OP_RESOURCES');
12249: v_sql_stmt:=
12250: 'INSERT INTO MSC_ST_STD_OP_RESOURCES ('
12251: || 'SR_INSTANCE_ID,'
12252: || 'STANDARD_OPERATION_ID,'
12253: || 'RESOURCE_ID,'
12254: || 'ORGANIZATION_ID,'
12255: || 'DEPARTMENT_ID,'
12256: || 'RESOURCE_SEQ_NUM,'
12285: || 'PROGRAM_UPDATE_DATE '
12286: || ')'
12287: ||'SELECT '
12288: || ':v_inst_rp_src_id,'
12289: || 'STANDARD_OPERATION_ID,'
12290: || 'RESOURCE_ID,'
12291: || 'ORGANIZATION_ID,'
12292: || 'DEPARTMENT_ID,'
12293: || 'RESOURCE_SEQ_NUM,'