[Home] [Help]
902: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
903: AND ORDER_TYPE IN (1,2,8,11,12,73,74,87)
904: AND SR_MTL_SUPPLY_ID= c_rec.SR_MTL_SUPPLY_ID;
905:
906: /*3 Discret Job, 7 Non STandard Job, 27 Flow schedule, 70 Eam supply: ds change change,86 External Repair Order */
907: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh and c_rec.ORDER_TYPE IN (3,7,27, 70,86)) or
908: (MSC_CL_COLLECTION.v_is_cont_refresh and (c_rec.ORDER_TYPE IN (3,7,27,70)) and
909: (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR)) THEN -- WIP_JOB
910: