[Home] [Help]
1862: /* set the MTQ , Firm Flag, Scheduled flag */
1863: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1864: IF lv_lbj_details =1 Then
1865: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,x.scheduled_flag, x.QUANTITY_IN_QUEUE, x.QUANTITY_RUNNING, x.QUANTITY_WAITING_TO_MOVE, x.QUANTITY_COMPLETED,'
1866: ||' decode(x.ENTITY_TYPE,5,x.COPY_YIELD, x.YIELD), x.USAGE_RATE, x.Copy_op_seq_num, decode(x.ENTITY_TYPE,5,copy_STANDARD_OPERATION_CODE,Standard_Operation_Code), x.ACTIVITY_GROUP_ID, x.ALTERNATE_NUM, x.PRINCIPLE_FLAG, ';
1867: v_temp_sql := v_temp_sql
1868: ||' (CASE WHEN x.maintenance_object_source in (1,2) THEN '
1869: ||' to_date(substr(x.WO_ACTUAL_DATES,1,instr(x.WO_ACTUAL_DATES,''#'')-1),''DD-MON-YYYY'')'
1870: ||' ELSE x.ACTUAL_START_DATE '
1872:
1873: v_temp_sql := v_temp_sql ||' x.ROUTING_SEQUENCE_ID,';
1874: ELSE
1875: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,x.scheduled_flag, x.QUANTITY_IN_QUEUE, x.QUANTITY_RUNNING, x.QUANTITY_WAITING_TO_MOVE, x.QUANTITY_COMPLETED,'
1876: ||' x.YIELD, x.USAGE_RATE, x.Operation_Seq_Num, x.Standard_Operation_Code, x.ACTIVITY_GROUP_ID, x.ALTERNATE_NUM, x.PRINCIPLE_FLAG, x.ACTUAL_START_DATE, x.ROUTING_SEQUENCE_ID,';
1877: lv_cond_sql := ' AND (x.ENTITY_TYPE <> 5 OR x.OPERATION_SEQUENCE_ID is not null) ';
1878: END IF;
1879: IF MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS121 THEN
1880: v_temp_sql := v_temp_sql||'x.description,';
1881: ELSE
1882: v_temp_sql := v_temp_sql||'NULL,';
1883: END IF;
1884: ELSIF MSC_CL_PULL.v_apps_ver= MSC_UTIL.G_APPS110 THEN
1885: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL,NULL, ';
1886: ELSE
1887: v_temp_sql := ' NULL ,NULL ,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL,NULL, ';
1888: END IF;
1889:
1883: END IF;
1884: ELSIF MSC_CL_PULL.v_apps_ver= MSC_UTIL.G_APPS110 THEN
1885: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL,NULL, ';
1886: ELSE
1887: v_temp_sql := ' NULL ,NULL ,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL,NULL, ';
1888: END IF;
1889:
1890: /*USAF starts*/
1891: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER and MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN
2814: ||' ( RESOURCE_ID,'
2815: ||' ORGANIZATION_ID,'
2816: ||' FROM_SETUP_ID,'
2817: ||' TO_SETUP_ID,'
2818: ||' STANDARD_OPERATION_ID,'
2819: ||' TRANSITION_TIME,'
2820: ||' TRANSITION_UOM,'
2821: ||' TRANSITION_PENALTY,'
2822: ||' DELETED_FLAG,'
2826: ||' x.RESOURCE_ID,'
2827: ||' x.ORGANIZATION_ID,'
2828: ||' x.FROM_SETUP_ID,'
2829: ||' x.TO_SETUP_ID,'
2830: ||' x.STANDARD_OPERATION_ID,'
2831: ||' x.TRANSITION_TIME,'
2832: ||' x.TRANSITION_UOM,'
2833: ||' x.TRANSITION_PENALTY,'
2834: ||' 2,'
2848: MSC_CL_PULL.v_view_name := 'MRP_AP_STD_OP_RESOURCES_V';
2849:
2850: v_sql_stmt:=
2851: ' insert into MSC_ST_STD_OP_RESOURCES'
2852: ||' ( STANDARD_OPERATION_ID,'
2853: ||' RESOURCE_ID,'
2854: ||' ORGANIZATION_ID,'
2855: ||' DEPARTMENT_ID,'
2856: ||' OPERATION_CODE,'
2864: ||' DELETED_FLAG,'
2865: ||' REFRESH_ID,'
2866: ||' SR_INSTANCE_ID)'
2867: ||' select'
2868: ||' x.STANDARD_OPERATION_ID,'
2869: ||' x.RESOURCE_ID,'
2870: ||' x.ORGANIZATION_ID,'
2871: ||' x.DEPARTMENT_ID,'
2872: ||' x.OPERATION_CODE,'