APPS.MSC_CL_WIP_PULL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 49

' INSERT INTO MSC_ST_OPERATION_NETWORKS'
||'( FROM_OP_SEQ_ID, '
||' TO_OP_SEQ_ID, '
||' DELETED_FLAG, '
||' REFRESH_ID, '
||' SR_INSTANCE_ID) '
||' SELECT '
||' x.FROM_OP_SEQ_ID,'
||' x.TO_OP_SEQ_ID, '
||'   1,'
||'   :v_refresh_id,'
||'   :v_instance_id'
||'  FROM MRP_AD_OPER_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
|| v_temp_sql;

Line: 74

v_sql_stmt:= ' insert into MSC_ST_OPERATION_NETWORKS'
||'( FROM_OP_SEQ_ID, '
||'TO_OP_SEQ_ID, '
||'ROUTING_SEQUENCE_ID, '
||'ORGANIZATION_ID, '
||'TRANSITION_TYPE, '
||'PLANNING_PCT, '
||'CUMMULATIVE_PCT, '
||'EFECTIVITY_DATE, '
||'DISABLE_DATE, '
||'PLAN_ID, '
||'DEPENDENCY_TYPE, '
||'CREATED_BY, '
||'CREATION_DATE, '
||'DELETED_FLAG, '
||'LAST_UPDATED_BY, '
||'LAST_UPDATE_DATE, '
||'LAST_UPDATE_LOGIN, '
||'ATTRIBUTE_CATEGORY, '
||'ATTRIBUTE1, '
||'ATTRIBUTE2, '
||'ATTRIBUTE3, '
||'ATTRIBUTE4, '
||'ATTRIBUTE5, '
||'ATTRIBUTE6, '
||'ATTRIBUTE7, '
||'ATTRIBUTE8, '
||'ATTRIBUTE9, '
||'ATTRIBUTE10, '
||'ATTRIBUTE11, '
||'ATTRIBUTE12, '
||'ATTRIBUTE13, '
||'ATTRIBUTE14, '
||'ATTRIBUTE15, '
||'FROM_OP_SEQ_NUM,'
||'TO_OP_SEQ_NUM,'
||'REFRESH_ID, '
||'SR_INSTANCE_ID) '
||' select '
||' x.FROM_OP_SEQ_ID, '
||' x.TO_OP_SEQ_ID, '
||' x.routing_sequence_id, '
||' x.ORGANIZATION_ID, '
||' x.TRANSITION_TYPE, '
||' x.PLANNING_PCT, '
||' x.CUMMULATIVE_PCT, '
||' x.EFFECTIVITY_DATE, '
||' x.DISABLE_DATE, '
||' -1, '
||' to_number(null), '    /* ds change: dependency_type = null=> prior-next */
||' x.CREATED_BY, '
||' x.CREATION_DATE, '
||' 2, '
||' x.LAST_UPDATED_BY, '
||' x.LAST_UPDATE_DATE, '
||' x.LAST_UPDATE_LOGIN, '
||' x.ATTRIBUTE_CATEGORY, '
||' x.ATTRIBUTE1, '
||' x.ATTRIBUTE2, '
||' x.ATTRIBUTE3, '
||' x.ATTRIBUTE4, '
||' x.ATTRIBUTE5, '
||' x.ATTRIBUTE6, '
||' x.ATTRIBUTE7, '
||' x.ATTRIBUTE8, '
||' x.ATTRIBUTE9, '
||' x.ATTRIBUTE10, '
||' x.ATTRIBUTE11, '
||' x.ATTRIBUTE12, '
||' x.ATTRIBUTE13, '
||' x.ATTRIBUTE14, '
||' x.ATTRIBUTE15, '
||' x.FROM_SEQ_NUM,'
||' x.TO_SEQ_NUM, '
||' :v_refresh_id,'
||' :v_instance_id '
||'  from MRP_AP_OPER_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
||'   WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND (x.RN1>'||MSC_CL_PULL.v_lrn
||'    OR x.RN2>'||MSC_CL_PULL.v_lrn
||'    OR x.RN3>'||MSC_CL_PULL.v_lrn
||'    OR x.RN4>'||MSC_CL_PULL.v_lrn
||'    OR x.RN5>'||MSC_CL_PULL.v_lrn
||'    OR x.RN6>'||MSC_CL_PULL.v_lrn||')' ;

Line: 194

	select LBJ_DETAILS into lv_lbj_details from msc_apps_instances
                where instance_id = MSC_CL_PULL.v_instance_id ;

Line: 216

     'insert into MSC_ST_DEMANDS'
     ||'  ( WIP_ENTITY_ID,'
     ||'    OPERATION_SEQ_NUM,'
     ||'    INVENTORY_ITEM_ID,'
     ||'    ORGANIZATION_ID,'
     ||'    ORIGINATION_TYPE,'
     ||'    DELETED_FLAG,'
     ||'    REFRESH_ID,'
     ||'    SR_INSTANCE_ID)'
     ||'  select'
     ||'    x.WIP_ENTITY_ID,'
     ||     lv_op_seq_num
     ||'    x.INVENTORY_ITEM_ID,'
     ||'    x.ORGANIZATION_ID,'
     ||'    x.ORIGINATION_TYPE,'
     ||'    1,'
     ||'    :v_refresh_id,'
     ||'    :v_instance_id'
     ||'  from MRP_AD_NON_ERO_WIP_COMP_DEM_V'||MSC_CL_PULL.v_dblink||' x'
     ||'  where ( DECODE( :v_mps_consume_profile_value,'
     ||'                  1, x.WJS_MPS_NET_QTY_FLAG,'
     ||'                  x.WJS_NET_QTY_FLAG)=1'
     ||'       OR x.MRP_NET_FLAG= 1'
     ||'       OR DECODE( :v_mps_consume_profile_value,'
     ||'                  1, x.MPS_FLAG,'
     ||'                  x.NMPS_FLAG)= 1 )'
     ||'    AND x.RN> :v_lrn '
     ||'    AND x.ORGANIZATION_ID  '||MSC_UTIL.v_non_depot_org_str ;

Line: 251

     'insert into MSC_ST_DEMANDS'
     ||'  ( WIP_ENTITY_ID,'
     ||'    OPERATION_SEQ_NUM,'
     ||'    INVENTORY_ITEM_ID,'
     ||'    ORGANIZATION_ID,'
     ||'    ORIGINATION_TYPE,'
     ||'    DELETED_FLAG,'
     ||'    REFRESH_ID,'
     ||'    SR_INSTANCE_ID)'
     ||'  select'
     ||'    x.WIP_ENTITY_ID,'
     ||     lv_op_seq_num
     ||'    x.INVENTORY_ITEM_ID,'
     ||'    x.ORGANIZATION_ID,'
     ||'    x.ORIGINATION_TYPE,'
     ||'    1,'
     ||'    :v_refresh_id,'
     ||'    :v_instance_id'
     ||'  from MRP_AD_NON_RO_WIP_COMP_DEM_V'||MSC_CL_PULL.v_dblink||' x'
     ||'  where ( DECODE( :v_mps_consume_profile_value,'
     ||'                  1, x.WJS_MPS_NET_QTY_FLAG,'
     ||'                  x.WJS_NET_QTY_FLAG)=1'
     ||'       OR x.MRP_NET_FLAG= 1'
     ||'       OR DECODE( :v_mps_consume_profile_value,'
     ||'                  1, x.MPS_FLAG,'
     ||'                  x.NMPS_FLAG)= 1 )'
     ||'    AND x.RN> :v_lrn '
     ||'    AND x.ORGANIZATION_ID  '||MSC_UTIL.v_depot_org_str ;

Line: 306

     'insert into MSC_ST_DEMANDS'
     ||'  ( WIP_ENTITY_ID,'
     ||'    OPERATION_SEQ_NUM,'
     ||'    INVENTORY_ITEM_ID,'
     ||'    ORGANIZATION_ID,'
     ||'    ORIGINATION_TYPE,'
     ||'    DELETED_FLAG,'
     ||'    REFRESH_ID,'
     ||'    SR_INSTANCE_ID)'
     ||'  select'
     ||'    x.WIP_ENTITY_ID,'
     ||     lv_op_seq_num
     ||'    x.INVENTORY_ITEM_ID,'
     ||'    x.ORGANIZATION_ID,'
     ||'    x.ORIGINATION_TYPE,'
     ||'    1,'
     ||'    :v_refresh_id,'
     ||'    :v_instance_id'
     ||'  from MRP_AD_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
     ||'  where ( DECODE( :v_mps_consume_profile_value,'
     ||'                  1, x.WJS_MPS_NET_QTY_FLAG,'
     ||'                  x.WJS_NET_QTY_FLAG)=1'
     ||'       OR x.MRP_NET_FLAG= 1'
     ||'       OR DECODE( :v_mps_consume_profile_value,'
     ||'                  1, x.MPS_FLAG,'
     ||'                  x.NMPS_FLAG)= 1 )'
     ||'    AND x.RN> :v_lrn '
     || v_temp_sql;

Line: 358

'insert into MSC_ST_DEMANDS'
||'  ( WIP_ENTITY_ID,'
||'    ORIGINATION_TYPE,'
||'    ORGANIZATION_ID,'
||'    DELETED_FLAG,'
||'    REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  select distinct'
||'    x.WIP_ENTITY_ID,'
||'    x.ORIGINATION_TYPE,'
||'    x.ORGANIZATION_ID,'
||'    1,'
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AD_WIP_FLOW_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
||'  where x.RN> :v_lrn '
|| v_temp_sql;

Line: 407

||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_NAME,'
||'    x.STATUS_CODE,'
||'    x.WIP_SUPPLY_TYPE,'
||     lv_op_seq_num
||'    x.NEW_REQUIRED_QUANTITY,'    -- Bug fix
||'    x.QUANTITY_ISSUED,'
||'    x.JOB_REFERENCE_ITEM_ID,'
||'    x.DEMAND_TYPE,'
||'    x.PROJECT_ID,'
||'    x.TASK_ID,'
||'    x.PLANNING_GROUP,'
||'    x.END_ITEM_UNIT_NUMBER,'
--||'    DECODE( x.DEMAND_CLASS,NULL,NULL,:V_ICODE||x.DEMAND_CLASS),'
||'    x.DEMAND_CLASS,'
||'    x.ORIGINATION_TYPE,'
||'    x.DATE_REQUIRED- :v_dgmt,'
||'    x.MPS_DATE_REQUIRED- :v_dgmt,'
||'    2,'
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
||'  WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')'
*/
||' UNION '
||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_NAME, '
||'    x.STATUS_CODE,'
||'    x.WIP_SUPPLY_TYPE,'
||     lv_op_seq_num
||'    x.NEW_REQUIRED_QUANTITY,'    -- Bug fix
||'    x.QUANTITY_ISSUED,'
||'    x.JOB_REFERENCE_ITEM_ID,'
||'    x.DEMAND_TYPE,'
||'    x.PROJECT_ID,'
||'    x.TASK_ID,'
||'    x.PLANNING_GROUP,'
||'    x.END_ITEM_UNIT_NUMBER,'
--||'    DECODE( x.DEMAND_CLASS,NULL,NULL,:V_ICODE||x.DEMAND_CLASS),'
||'    x.DEMAND_CLASS,'
||'    x.ORIGINATION_TYPE,'
||'    x.DATE_REQUIRED- :v_dgmt,'
||'    x.MPS_DATE_REQUIRED- :v_dgmt,'
||'    2,'
||     v_temp_sql
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
||'  WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND x.NEW_REQUIRED_QUANTITY > 0'
--||'   AND DECODE(:V_COLLECT_COMPLETED_JOBS,'
--||'       2 ,x.coll_completed_qty_ind,'
--||'       1) >0'
||'   AND DECODE(:v_collect_completed_jobs,'
||'       2,x.status_code,'
||'       1) <>4'    -- 5730031
||'   AND ( x.RN2> :v_lrn )'
||' UNION '
||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_NAME, '
||'    x.STATUS_CODE,'
||'    x.WIP_SUPPLY_TYPE,'
||     lv_op_seq_num
||'    x.NEW_REQUIRED_QUANTITY,'    -- Bug fix
||'    x.QUANTITY_ISSUED,'
||'    x.JOB_REFERENCE_ITEM_ID,'
||'    x.DEMAND_TYPE,'
||'    x.PROJECT_ID,'
||'    x.TASK_ID,'
||'    x.PLANNING_GROUP,'
||'    x.END_ITEM_UNIT_NUMBER,'
--||'    DECODE( x.DEMAND_CLASS,NULL,NULL,:V_ICODE||x.DEMAND_CLASS),'
||'    x.DEMAND_CLASS,'
||'    x.ORIGINATION_TYPE,'
||'    x.DATE_REQUIRED- :v_dgmt,'
||'    x.MPS_DATE_REQUIRED- :v_dgmt,'
||'    2,'
||     v_temp_sql
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
||'  WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND x.NEW_REQUIRED_QUANTITY > 0'
--||'   AND DECODE(:V_COLLECT_COMPLETED_JOBS,'
--||'       2 ,x.coll_completed_qty_ind,'
--||'       1) >0'
||'   AND DECODE(:v_collect_completed_jobs,'
||'       2,x.status_code,'
||'       1) <>4'    -- 5730031
||'   AND ( x.RN3> :v_lrn )';

Line: 516

'insert into MSC_ST_DEMANDS'
||'  ( INVENTORY_ITEM_ID,'
||'    SOURCE_INVENTORY_ITEM_ID,'
||'    ORGANIZATION_ID,'
||'    WIP_ENTITY_ID,'
||'    SOURCE_WIP_ENTITY_ID,'
||'    ORDER_NUMBER,'                    -- changes
||'    WIP_STATUS_CODE,'
||'    WIP_SUPPLY_TYPE,'
||'    OPERATION_SEQ_NUM,'
||'    USING_REQUIREMENT_QUANTITY,'
||'    QUANTITY_ISSUED,'
||'    USING_ASSEMBLY_ITEM_ID,'
||'    DEMAND_TYPE,'
||'    PROJECT_ID,'
||'    TASK_ID,'
||'    PLANNING_GROUP,'
||'    END_ITEM_UNIT_NUMBER,'
||'    DEMAND_CLASS,'
||'    ORIGINATION_TYPE,'
||'    USING_ASSEMBLY_DEMAND_DATE,'
||'    MPS_DATE_REQUIRED,'
||'    DELETED_FLAG,'
||'    QUANTITY_PER_ASSEMBLY,'
||'    ASSET_ITEM_ID,'     /* ds change */
||'    ASSET_SERIAL_NUMBER,'  /* ds change */
||'    COMPONENT_SCALING_TYPE,'
||'    COMPONENT_YIELD_FACTOR,'
||'    REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_NAME, '
||'    x.STATUS_CODE,'
||'    x.WIP_SUPPLY_TYPE,'
||     lv_op_seq_num
||'    x.NEW_REQUIRED_QUANTITY,'    -- Bug fix
||'    x.QUANTITY_ISSUED,'
||'    x.JOB_REFERENCE_ITEM_ID,'
||'    x.DEMAND_TYPE,'
||'    x.PROJECT_ID,'
||'    x.TASK_ID,'
||'    x.PLANNING_GROUP,'
||'    x.END_ITEM_UNIT_NUMBER,'
--||'    DECODE( x.DEMAND_CLASS,NULL,NULL,:V_ICODE||x.DEMAND_CLASS),'
||'    x.DEMAND_CLASS,'
||'    x.ORIGINATION_TYPE,'
||'    x.DATE_REQUIRED- :v_dgmt,'
||'    x.MPS_DATE_REQUIRED- :v_dgmt,'
||'    2,'
||     v_temp_sql
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from  ';

Line: 668

' insert into MSC_ST_DEMANDS'
||'  ( INVENTORY_ITEM_ID,'
||'    WIP_ENTITY_ID,'
||'    OPERATION_SEQ_NUM,'
||'    REPETITIVE_SCHEDULE_ID,'
||'    ORGANIZATION_ID,'
||'    ORIGINATION_TYPE,'
||'    DELETED_FLAG,'
||'    REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.OPERATION_SEQ_NUM,'
||'    x.REPETITIVE_SCHEDULE_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.ORIGINATION_TYPE,'
||'    1,'
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AD_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.RN> :v_lrn '
|| v_temp_sql;

Line: 707

||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.OPERATION_SEQ_NUM,'
||'    x.REPETITIVE_SCHEDULE_ID,'
||'    x.WIP_ENTITY_NAME, '
||'    x.REQUIRED_QUANTITY,'
||'    x.DATE_REQUIRED,'
||'    x.QUANTITY_ISSUED,'
||'    x.JOB_REFERENCE_ITEM_ID,'
||'    x.WIP_ENTITY_TYPE,'
||'    x.DEMAND_CLASS,'
||'    x.ORIGINATION_TYPE,'
||'    x.STATUS_CODE,'
||'    x.WIP_SUPPLY_TYPE,'
||'    2,'
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND ( x.RN2 > :v_lrn )'
||' UNION '
||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.OPERATION_SEQ_NUM,'
||'    x.REPETITIVE_SCHEDULE_ID,'
||'    x.WIP_ENTITY_NAME, '
||'    x.REQUIRED_QUANTITY,'
||'    x.DATE_REQUIRED,'
||'    x.QUANTITY_ISSUED,'
||'    x.JOB_REFERENCE_ITEM_ID,'
||'    x.WIP_ENTITY_TYPE,'
||'    x.DEMAND_CLASS,'
||'    x.ORIGINATION_TYPE,'
||'    x.STATUS_CODE,'
||'    x.WIP_SUPPLY_TYPE,'
||'    2,'
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND ( x.RN3 > :v_lrn )'
||' UNION '
||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.OPERATION_SEQ_NUM,'
||'    x.REPETITIVE_SCHEDULE_ID,'
||'    x.WIP_ENTITY_NAME, '
||'    x.REQUIRED_QUANTITY,'
||'    x.DATE_REQUIRED,'
||'    x.QUANTITY_ISSUED,'
||'    x.JOB_REFERENCE_ITEM_ID,'
||'    x.WIP_ENTITY_TYPE,'
||'    x.DEMAND_CLASS,'
||'    x.ORIGINATION_TYPE,'
||'    x.STATUS_CODE,'
||'    x.WIP_SUPPLY_TYPE,'
||'    2,'
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND ( x.RN4 > :v_lrn )'
||' UNION '
||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.OPERATION_SEQ_NUM,'
||'    x.REPETITIVE_SCHEDULE_ID,'
||'    x.WIP_ENTITY_NAME, '
||'    x.REQUIRED_QUANTITY,'
||'    x.DATE_REQUIRED,'
||'    x.QUANTITY_ISSUED,'
||'    x.JOB_REFERENCE_ITEM_ID,'
||'    x.WIP_ENTITY_TYPE,'
||'    x.DEMAND_CLASS,'
||'    x.ORIGINATION_TYPE,'
||'    x.STATUS_CODE,'
||'    x.WIP_SUPPLY_TYPE,'
||'    2,'
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND ( x.RN5 > :v_lrn )';

Line: 807

' insert into MSC_ST_DEMANDS'
||'  ( INVENTORY_ITEM_ID,'
||'    ORGANIZATION_ID,'
||'    WIP_ENTITY_ID,'
||'    OPERATION_SEQ_NUM,'
||'    REPETITIVE_SCHEDULE_ID,'
||'    ORDER_NUMBER,'
||'    USING_REQUIREMENT_QUANTITY,'
||'    USING_ASSEMBLY_DEMAND_DATE,'
||'    QUANTITY_ISSUED,'
||'    USING_ASSEMBLY_ITEM_ID,'
||'    DEMAND_TYPE,'
||'    DEMAND_CLASS,'
||'    ORIGINATION_TYPE,'
||'    WIP_STATUS_CODE,'
||'    WIP_SUPPLY_TYPE,'
||'    DELETED_FLAG,'
||'   REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.OPERATION_SEQ_NUM,'
||'    x.REPETITIVE_SCHEDULE_ID,'
||'    x.WIP_ENTITY_NAME, '
||'    x.REQUIRED_QUANTITY,'
||'    x.DATE_REQUIRED,'
||'    x.QUANTITY_ISSUED,'
||'    x.JOB_REFERENCE_ITEM_ID,'
||'    x.WIP_ENTITY_TYPE,'
--||'    DECODE( x.DEMAND_CLASS, NULL, NULL, :V_ICODE||x.DEMAND_CLASS),'
||'    x.DEMAND_CLASS,'
||'    x.ORIGINATION_TYPE,'
||'    x.STATUS_CODE,'
||'    x.WIP_SUPPLY_TYPE,'
||'    2,'
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
|| v_union_sql;

Line: 894

||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_NAME, '
||'    x.STATUS_CODE,'
||'    x.WIP_SUPPLY_TYPE,'
||'    x.COPY_OP_SEQ_NUM, '
||'    x.NEW_REQUIRED_QUANTITY,'
||'    x.QUANTITY_ISSUED,'
||'    x.JOB_REFERENCE_ITEM_ID,'
||'    x.DEMAND_TYPE,'
||'    x.PROJECT_ID,'
||'    x.TASK_ID,'
||'    x.PLANNING_GROUP,'
||'    x.END_ITEM_UNIT_NUMBER,'
||'    x.DEMAND_CLASS,'
||'    x.ORIGINATION_TYPE,'
||'    x.DATE_REQUIRED- :v_dgmt,'
||'    x.MPS_DATE_REQUIRED- :v_dgmt,'
||'    2,'
||'    X.QUANTITY_PER_ASSEMBLY,'
||'    X.ASSET_ITEM_ID,'
||'    X.ASSET_SERIAL_NUMBER,'
||'    X.BASIS_TYPE,'
||'    X.COMPONENT_YIELD_FACTOR,'
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from  MRP_AP_CMRO_WIP_COMP_DMD_V'||MSC_CL_PULL.v_dblink||'  X'
||'  WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND DECODE(:v_collect_completed_jobs,'
||'       2,x.status_code,'
||'       1) <>4'
||'   AND x.NEW_REQUIRED_QUANTITY > 0'
||'   AND ( x.RN2> :v_lrn )'
||' UNION '
||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_NAME, '
||'    x.STATUS_CODE,'
||'    x.WIP_SUPPLY_TYPE,'
||'    x.COPY_OP_SEQ_NUM, '
||'    x.NEW_REQUIRED_QUANTITY,'
||'    x.QUANTITY_ISSUED,'
||'    x.JOB_REFERENCE_ITEM_ID,'
||'    x.DEMAND_TYPE,'
||'    x.PROJECT_ID,'
||'    x.TASK_ID,'
||'    x.PLANNING_GROUP,'
||'    x.END_ITEM_UNIT_NUMBER,'
||'    x.DEMAND_CLASS,'
||'    x.ORIGINATION_TYPE,'
||'    x.DATE_REQUIRED- :v_dgmt,'
||'    x.MPS_DATE_REQUIRED- :v_dgmt,'
||'    2,'
||'    X.QUANTITY_PER_ASSEMBLY,'
||'    X.ASSET_ITEM_ID,'
||'    X.ASSET_SERIAL_NUMBER,'
||'    X.BASIS_TYPE,'
||'    X.COMPONENT_YIELD_FACTOR,'
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from  MRP_AP_CMRO_WIP_COMP_DMD_V'||MSC_CL_PULL.v_dblink||'  X'
||'  WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND DECODE(:v_collect_completed_jobs,'
||'       2,x.status_code,'
||'       1) <>4'
||'   AND x.NEW_REQUIRED_QUANTITY > 0'
||'   AND ( x.RN3> :v_lrn )';

Line: 974

'insert into MSC_ST_DEMANDS'
||'  ( INVENTORY_ITEM_ID,'
||'    SOURCE_INVENTORY_ITEM_ID,'
||'    ORGANIZATION_ID,'
||'    WIP_ENTITY_ID,'
||'    SOURCE_WIP_ENTITY_ID,'
||'    ORDER_NUMBER,'
||'    WIP_STATUS_CODE,'
||'    WIP_SUPPLY_TYPE,'
||'    OPERATION_SEQ_NUM,'
||'    USING_REQUIREMENT_QUANTITY,'
||'    QUANTITY_ISSUED,'
||'    USING_ASSEMBLY_ITEM_ID,'
||'    DEMAND_TYPE,'
||'    PROJECT_ID,'
||'    TASK_ID,'
||'    PLANNING_GROUP,'
||'    END_ITEM_UNIT_NUMBER,'
||'    DEMAND_CLASS,'
||'    ORIGINATION_TYPE,'
||'    USING_ASSEMBLY_DEMAND_DATE,'
||'    MPS_DATE_REQUIRED,'
||'    DELETED_FLAG,'
||'    QUANTITY_PER_ASSEMBLY,'
||'    ASSET_ITEM_ID,'
||'    ASSET_SERIAL_NUMBER,'
||'    COMPONENT_SCALING_TYPE,'
||'    COMPONENT_YIELD_FACTOR,'
||'    REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_NAME, '
||'    x.STATUS_CODE,'
||'    x.WIP_SUPPLY_TYPE,'
||'    x.COPY_OP_SEQ_NUM, '
||'    x.NEW_REQUIRED_QUANTITY,'
||'    x.QUANTITY_ISSUED,'
||'    x.JOB_REFERENCE_ITEM_ID,'
||'    x.DEMAND_TYPE,'
||'    x.PROJECT_ID,'
||'    x.TASK_ID,'
||'    x.PLANNING_GROUP,'
||'    x.END_ITEM_UNIT_NUMBER,'
||'    x.DEMAND_CLASS,'
||'    x.ORIGINATION_TYPE,'
||'    x.DATE_REQUIRED- :v_dgmt,'
||'    x.MPS_DATE_REQUIRED- :v_dgmt,'
||'    2,'
||'    X.QUANTITY_PER_ASSEMBLY,'
||'    X.ASSET_ITEM_ID,'
||'    X.ASSET_SERIAL_NUMBER,'
||'    X.BASIS_TYPE,'
||'    X.COMPONENT_YIELD_FACTOR,'
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from  MRP_AP_CMRO_WIP_COMP_DMD_V'||MSC_CL_PULL.v_dblink||'  X'
||'  WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
;

Line: 1115

select LBJ_DETAILS into lv_lbj_details from msc_apps_instances
                where instance_id = MSC_CL_PULL.v_instance_id ;

Line: 1149

     'insert into MSC_ST_SUPPLIES'
     ||'  ( DISPOSITION_ID,'
     ||'    ORDER_TYPE,'
     ||'    DELETED_FLAG,'
     ||'    REFRESH_ID,'
     ||'    SR_INSTANCE_ID)'
     ||'  select'
     ||'    x.WIP_ENTITY_ID,'
     ||'    x.ORDER_TYPE,'
     ||'    1,'
     ||'    :v_refresh_id,'
     ||'    :v_instance_id'
     ||'  from MRP_AD_NON_ERO_WIP_JOB_SUP_V'||MSC_CL_PULL.v_dblink||' x'
     ||'  where DECODE( x.wip_job_type,'
     ||'                1, DECODE( :v_mps_consume_profile_value,'
     ||'                                    1, x.WJS_MPS_NET_QTY_FLAG,'
     ||'                                    x.WJS_NET_QTY_FLAG),'
     ||'                x.WJS_NET_QTY_FLAG)=1'
     ||'  AND x.RN> :v_lrn '
     ||'  AND x.ORGANIZATION_ID  '||MSC_UTIL.v_non_depot_org_str;

Line: 1175

     'insert into MSC_ST_SUPPLIES'
     ||'  ( DISPOSITION_ID,'
     ||'    ORDER_TYPE,'
     ||'    DELETED_FLAG,'
     ||'    REFRESH_ID,'
     ||'    SR_INSTANCE_ID)'
     ||'  select'
     ||'    x.WIP_ENTITY_ID,'
     ||'    x.ORDER_TYPE,'
     ||'    1,'
     ||'    :v_refresh_id,'
     ||'    :v_instance_id'
     ||'  from MRP_AD_NON_ERO_WIP_JOB_SUP_V'||MSC_CL_PULL.v_dblink||' x'
     ||'  where DECODE( x.wip_job_type,'
     ||'                1, DECODE( :v_mps_consume_profile_value,'
     ||'                                    1, x.WJS_MPS_NET_QTY_FLAG,'
     ||'                                    x.WJS_NET_QTY_FLAG),'
     ||'                x.WJS_NET_QTY_FLAG)=1'
     ||'  AND x.RN> :v_lrn '
     ||'  AND x.ORGANIZATION_ID  '||MSC_UTIL.v_depot_org_str;

Line: 1202

    MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_NON_ERO_WIP_JOB_SUP_V = '|| SQL%ROWCOUNT);

Line: 1210

    MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_NON_ERO_WIP_JOB_SUP_V = '|| SQL%ROWCOUNT);

Line: 1225

     'insert into MSC_ST_SUPPLIES'
     ||'  ( DISPOSITION_ID,'
     ||'    ORDER_TYPE,'
     ||'    DELETED_FLAG,'
     ||'    REFRESH_ID,'
     ||'    SR_INSTANCE_ID)'
     ||'  select'
     ||'    x.WIP_ENTITY_ID,'
     ||'    x.ORDER_TYPE,'
     ||'    1,'
     ||'    :v_refresh_id,'
     ||'    :v_instance_id'
     ||'  from MRP_AD_WIP_JOB_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
     ||'  where DECODE( x.wip_job_type,'
     ||'                1, DECODE( :v_mps_consume_profile_value,'
     ||'                                    1, x.WJS_MPS_NET_QTY_FLAG,'
     ||'                                    x.WJS_NET_QTY_FLAG),'
     ||'                x.WJS_NET_QTY_FLAG)=1'
     ||'  AND x.RN> :v_lrn '
     || v_temp_sql;

Line: 1251

    MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_WIP_JOB_SUPPLIES_V = '|| SQL%ROWCOUNT);

Line: 1273

'insert into MSC_ST_SUPPLIES'
||'  ( DISPOSITION_ID,'
||'    OPERATION_SEQ_NUM,'
||'    INVENTORY_ITEM_ID,'
||'    ORDER_TYPE,'
||'    DELETED_FLAG,'
||'    REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  select'
||'    x.WIP_ENTITY_ID,'
||     lv_op_seq_num
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORDER_TYPE,'
||'    1,'
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AD_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
||'  where ( DECODE( :v_mps_consume_profile_value,'
||'                  1, x.WJS_MPS_NET_QTY_FLAG,'
||'                  x.WJS_NET_QTY_FLAG)=1'
||'       OR x.MRP_NET_FLAG= 1'
||'       OR DECODE( :v_mps_consume_profile_value,'
||'                  1, x.MPS_FLAG,'
||'                  x.NMPS_FLAG)= 1 )'
||'    AND x.RN> :v_lrn '
|| v_temp_sql;

Line: 1320

' insert into MSC_ST_SUPPLIES'
||'   ( DISPOSITION_ID,'
||'     ORDER_TYPE,'
||'     ORGANIZATION_ID,'
||'     DELETED_FLAG,'
||'     REFRESH_ID,'
||'     SR_INSTANCE_ID)'
||'  select'
||'     x.REPETITIVE_SCHEDULE_ID,'
||'     x.ORDER_TYPE,'
||'     x.ORGANIZATION_ID,'
||'     1,'
||'     :v_refresh_id,'
||'     :v_instance_id'
||'  from MRP_AD_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.RN> :v_lrn '
|| v_temp_sql;

Line: 1400

/*Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS115,
	      ' DECODE( x.wip_job_type, 1,
			    DECODE( :v_mps_consume_profile_value,
				        1, x.mps_wip_start_quantity,
					   x.wip_start_quantity),
                            x.wip_start_quantity ), ',
              ' decode(:v_mps_consume_profile_value,1,NULL,null) ,')
into v_temp_sql1
from dual;*/

Line: 1417

||'  select'
||v_temp_sql7
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_NAME, '
||'    DECODE( x.wip_job_type, '
||'            1, DECODE( :v_mps_consume_profile_value,'
||'                                  1, decode(:lv_lbj_details,1,x.jd_mps_job_quantity,x.mps_job_quantity),'
||'                                  decode(:lv_lbj_details,1,x.jd_job_quantity,x.job_quantity)),'
||'            decode(:lv_lbj_details,1,x.jd_job_quantity,x.job_quantity)),'
||'    DECODE( x.wip_job_type,'
||'            1, DECODE( :v_mps_consume_profile_value,'
||'                                  1, x.mps_scheduled_completion_date,'
||'                                  x.scheduled_completion_date),'
||'            x.scheduled_completion_date)- :v_dgmt,'
||'    DECODE( x.wip_job_type,'
||'            1, DECODE( :v_mps_consume_profile_value,'
||'                                  1, x.mps_expected_scrap_quantity,'
||'                                  x.expected_scrap_quantity),'
||'            x.expected_scrap_quantity),'
||'    x.quantity_scrapped,'
||'    x.quantity_completed,'
||'    x.FIRM_PLANNED_STATUS_TYPE,'
||'    x.START_DATE- :v_dgmt,'
||'    x.REVISION,'
||'    x.ORDER_TYPE,'
||'    x.PROJECT_ID,'
||'    x.TASK_ID,'
||'    x.PLANNING_GROUP,'
||'    x.SCHEDULE_GROUP_ID,'
||'    x.BUILD_SEQUENCE,'
||'    x.LINE_ID,'
||'    x.ALTERNATE_BOM_DESIGNATOR,'
||'    x.ALTERNATE_ROUTING_DESIGNATOR,'
||'    x.END_ITEM_UNIT_NUMBER,'
||'    x.STATUS_CODE,'
||'    x.SCHEDULE_GROUP_NAME,'
||'    x.DEMAND_CLASS,'
||'    2,'
||     v_temp_sql
||     v_temp_sql1
||     v_temp_sql5
||     v_temp_sql6
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AP_WIP_JOB_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
||'  where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
/*Bug#4704457 ||'    AND DECODE( x.wip_job_type,'
               ||' 1, DECODE( :v_mps_consume_profile_value,'
                             ||' 1, x.mps_net_quantity,'
                             ||' x.net_quantity),'
               ||' x.net_quantity) > 0' */
|| lv_qty_sql_temp
||'  AND (( x.RN2 > :v_lrn ) OR '
||'       (x.ENTITY_TYPE = 5 '
||'       AND EXISTS '
||'       (SELECT NULL '
||'        FROM MRP_SN_WOPRS'||MSC_CL_PULL.v_dblink||' y '
||'        WHERE '
||'        x.WIP_ENTITY_ID = y.WIP_ENTITY_ID*2 '
||'        AND x.ORGANIZATION_ID = y.ORGANIZATION_ID '
||'        AND y.RN > :v_lrn )))';

Line: 1487

'insert into MSC_ST_SUPPLIES'
||'  ( INVENTORY_ITEM_ID,'
||'    ORGANIZATION_ID,'
||'    DISPOSITION_ID,'
||'    ORDER_NUMBER,'
||'    NEW_ORDER_QUANTITY,'
||'    NEW_SCHEDULE_DATE,'
||'    EXPECTED_SCRAP_QTY,'
||'    QTY_SCRAPPED,'
||'    QTY_COMPLETED,'
||'    FIRM_PLANNED_TYPE,'
||'    NEW_WIP_START_DATE,'
||'    REVISION,'
||'    ORDER_TYPE,'
||'    PROJECT_ID,'
||'    TASK_ID,'
||'    PLANNING_GROUP,'
||'    SCHEDULE_GROUP_ID,'
||'    BUILD_SEQUENCE,'
||'    LINE_ID,'
||'    ALTERNATE_BOM_DESIGNATOR,'
||'    ALTERNATE_ROUTING_DESIGNATOR,'
||'    UNIT_NUMBER,'
||'    WIP_STATUS_CODE,'
||'    SCHEDULE_GROUP_NAME,'
||'    DEMAND_CLASS,'
||'    DELETED_FLAG,'
||'    ROUTING_SEQUENCE_ID,'
||'    BILL_SEQUENCE_ID,'
||'    COPRODUCTS_SUPPLY,'
||'    OPERATION_SEQ_NUM,'
||'    JUMP_OP_SEQ_NUM,'
||'    JOB_OP_SEQ_NUM,'
||'    REQUESTED_START_DATE,'  /* ds change start */
||'    REQUESTED_COMPLETION_DATE,'
||'    SCHEDULE_PRIORITY,'
||'    ASSET_ITEM_ID,'
||'    ASSET_SERIAL_NUMBER,'   /* ds change start */
||'    ACTUAL_START_DATE,'   /* Discrete Mfg Enahancements Bug 4479276 */
||'    CFM_ROUTING_FLAG,'
||'    WIP_START_QUANTITY,'
||'    MAINTENANCE_OBJECT_SOURCE,'
||'    DESCRIPTION,'
||'    ASSET_NUMBER,'
||'    MAINTENANCE_OBJECT_ID,'
||'    MAINTENANCE_OBJECT_TYPE,'
||'    SCHEDULE_DESIGNATOR_ID,' /*???? need to confirm*/
||'    CLASS_CODE,'
||'    SHUTDOWN_TYPE,'
||'    ACTIVITY_TYPE,'
||'    ACTIVITY_ITEM_ID,'
||'    REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  select'
||v_temp_sql7
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_NAME, '
||'    DECODE( x.wip_job_type, '
||'            1, DECODE( :v_mps_consume_profile_value,'
||'                                  1, decode(:lv_lbj_details,1,x.jd_mps_job_quantity,x.mps_job_quantity),'
||'                                  decode(:lv_lbj_details,1,x.jd_job_quantity,x.job_quantity)),'
||'            decode(:lv_lbj_details,1,x.jd_job_quantity,x.job_quantity)),'
||'    DECODE( x.wip_job_type,'
||'            1, DECODE( :v_mps_consume_profile_value,'
||'                                  1, x.mps_scheduled_completion_date,'
||'                                  x.scheduled_completion_date),'
||'            x.scheduled_completion_date)- :v_dgmt,'
||'    DECODE( x.wip_job_type,'
||'            1, DECODE( :v_mps_consume_profile_value,'
||'                                  1, x.mps_expected_scrap_quantity,'
||'                                  x.expected_scrap_quantity),'
||'            x.expected_scrap_quantity),'
||'    x.quantity_scrapped,'
||'    x.quantity_completed,'
||'    x.FIRM_PLANNED_STATUS_TYPE,'
||'    x.START_DATE- :v_dgmt,'
||'    x.REVISION,'
||'    x.ORDER_TYPE,'
||'    x.PROJECT_ID,'
||'    x.TASK_ID,'
||'    x.PLANNING_GROUP,'
||'    x.SCHEDULE_GROUP_ID,'
||'    x.BUILD_SEQUENCE,'
||'    x.LINE_ID,'
||'    x.ALTERNATE_BOM_DESIGNATOR,'
||'    x.ALTERNATE_ROUTING_DESIGNATOR,'
||'    x.END_ITEM_UNIT_NUMBER,'
||'    x.STATUS_CODE,'
||'    x.SCHEDULE_GROUP_NAME,'
--||'    DECODE( x.DEMAND_CLASS,NULL,NULL,:V_ICODE||x.DEMAND_CLASS),'
||'    x.DEMAND_CLASS,'
||'    2,'
||     v_temp_sql
||     v_temp_sql1
||     v_temp_sql5
||     v_temp_sql6
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from  ';

Line: 1720

||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_NAME, '
||     lv_op_seq_num
||'    x.BY_PROD_QUANTITY,'        -- Bug fix
||'    x.ORDER_TYPE,'
||'    x.PROJECT_ID,'
||'    x.TASK_ID,'
||'    x.PLANNING_GROUP,'
||'    x.END_ITEM_UNIT_NUMBER,'
||'    DECODE( x.job_type, '
||'            1, NVL(x.mps_date_required, x.scheduled_start_date),'
||'             NVL(x.date_required, x.scheduled_start_date))- :v_dgmt,'
||'    2,'
||'    x.STATUS_CODE,'
||'    x.WIP_SUPPLY_TYPE,'
||'    x.SCHEDULE_GROUP_NAME,'
--||'    DECODE( x.DEMAND_CLASS,NULL,NULL,:V_ICODE||x.DEMAND_CLASS),'
||'    x.DEMAND_CLASS,'
||'    x.JOB_REFERENCE_ITEM_ID,'
||     v_temp_sql
||'    2,'
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AP_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
||'  WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND  x.BY_PROD_QUANTITY <> 0'
||    lv_cond_sql
--||'   AND DECODE(:V_COLLECT_COMPLETED_JOBS,'
--||'       2,x.coll_completed_qty_ind,'
--||'       1) >0'
||'   AND DECODE(:v_collect_completed_jobs,'
||'       2,x.status_code,'
||'       1) <>4'    -- 5730031
||'   AND ( x.RN2 > :v_lrn )'
||' UNION '
||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_NAME, '
||     lv_op_seq_num
||'    x.BY_PROD_QUANTITY,'        -- Bug fix
||'    x.ORDER_TYPE,'
||'    x.PROJECT_ID,'
||'    x.TASK_ID,'
||'    x.PLANNING_GROUP,'
||'    x.END_ITEM_UNIT_NUMBER,'
||'    DECODE( x.job_type, '
||'            1, NVL(x.mps_date_required, x.scheduled_start_date),'
||'             NVL(x.date_required, x.scheduled_start_date))- :v_dgmt,'
||'    2,'
||'    x.STATUS_CODE,'
||'    x.WIP_SUPPLY_TYPE,'
||'    x.SCHEDULE_GROUP_NAME,'
--||'    DECODE( x.DEMAND_CLASS,NULL,NULL,:V_ICODE||x.DEMAND_CLASS),'
||'    x.DEMAND_CLASS,'
||'    x.JOB_REFERENCE_ITEM_ID,'
||     v_temp_sql
||'    2,'
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AP_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
||'  WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND  x.BY_PROD_QUANTITY <> 0'
||    lv_cond_sql
--||'   AND DECODE(:V_COLLECT_COMPLETED_JOBS,'
--||'       2,x.coll_completed_qty_ind,'
--||'       1) >0'
||'   AND DECODE(:v_collect_completed_jobs,'
||'       2,x.status_code,'
||'       1) <>4'    -- 5730031
||'   AND ( x.RN3 > :v_lrn )';

Line: 1805

' insert into MSC_ST_SUPPLIES'
||'  ( INVENTORY_ITEM_ID,'
||'    ORGANIZATION_ID,'
||'    DISPOSITION_ID,'
||'    ORDER_NUMBER,'
||'    OPERATION_SEQ_NUM,'
||'    NEW_ORDER_QUANTITY,'
||'    ORDER_TYPE,'
||'    PROJECT_ID,'
||'    TASK_ID,'
||'    PLANNING_GROUP,'
||'    UNIT_NUMBER,'
||'    NEW_SCHEDULE_DATE,'
||'    FIRM_PLANNED_TYPE,'
||'    WIP_STATUS_CODE,'
||'    WIP_SUPPLY_TYPE,'
||'    SCHEDULE_GROUP_NAME,'
||'    DEMAND_CLASS,'
||'    BY_PRODUCT_USING_ASSY_ID,'
||'    QUANTITY_PER_ASSEMBLY,'
||'    QUANTITY_ISSUED,'
||'    ACTUAL_START_DATE,'  /* Discrete Mfg Enahancements Bug 4479276 */
||'    DELETED_FLAG,'
||'    REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  select'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.WIP_ENTITY_ID,'
||'    x.WIP_ENTITY_NAME, '
||     lv_op_seq_num
||'    x.BY_PROD_QUANTITY,'        -- Bug fix
||'    x.ORDER_TYPE,'
||'    x.PROJECT_ID,'
||'    x.TASK_ID,'
||'    x.PLANNING_GROUP,'
||'    x.END_ITEM_UNIT_NUMBER,'
||'    DECODE( x.job_type, '
||'            1, NVL(x.mps_date_required, x.scheduled_start_date),'
||'             NVL(x.date_required, x.scheduled_start_date))- :v_dgmt,'
||'    2,'
||'    x.STATUS_CODE,'
||'    x.WIP_SUPPLY_TYPE,'
||'    x.SCHEDULE_GROUP_NAME,'
--||'    DECODE( x.DEMAND_CLASS,NULL,NULL,:V_ICODE||x.DEMAND_CLASS),'
||'    x.DEMAND_CLASS,'
||'    x.JOB_REFERENCE_ITEM_ID,'
||     v_temp_sql
||'    2,'
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AP_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
||'  WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND  x.BY_PROD_QUANTITY <> 0'
||    lv_cond_sql
--||'   AND DECODE(:V_COLLECT_COMPLETED_JOBS,'
--||'       2,x.coll_completed_qty_ind,'
--||'       1) >0'
||'   AND DECODE(:v_collect_completed_jobs,'
||'       2,x.status_code,'
||'       1) <>4'    -- 5730031
|| v_union_sql;

Line: 1904

'insert into MSC_ST_JOB_OPERATION_NETWORKS'
||'  ( WIP_ENTITY_ID,'
||'    FROM_OP_SEQ_NUM,'
||'    TO_OP_SEQ_NUM,'
||'    DELETED_FLAG,'
||'    REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  select'
||'    x.WIP_ENTITY_ID,'
||'    x.FROM_OP_SEQ_NUM,'
||'    x.TO_OP_SEQ_NUM,'
||'    1,'
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AD_JOB_OP_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
||'  where x.RN> '||MSC_CL_PULL.v_lrn
||'   AND DECODE( x.from_op_seq_num,'
||'               NULL, DECODE( :v_mps_consume_profile_value,'
||'                                        1, x.WJS_MPS_NET_QTY_FLAG,'
||'                                        x.WJS_NET_QTY_FLAG), '
||'               1)= 1'
|| v_temp_sql;

Line: 1931

    MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);

Line: 1941

    'insert into MSC_ST_JOB_OPERATION_NETWORKS'
    ||'  ( WIP_ENTITY_ID,'
    ||'    FROM_OP_SEQ_NUM,'
    ||'    TO_OP_SEQ_NUM,'
    ||'    DELETED_FLAG,'
    ||'    REFRESH_ID,'
    ||'    SR_INSTANCE_ID)'
    ||'  select'
    ||'    x.WIP_ENTITY_ID,'
    ||'    x.FROM_OP_SEQ_NUM,'
    ||'    x.TO_OP_SEQ_NUM,'
    ||'    1,'
    ||'    :v_refresh_id,'
    ||'    :v_instance_id'
    ||'  from MRP_AD_WOPR_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
    ||'  where x.RN> '||MSC_CL_PULL.v_lrn;

Line: 1962

        MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_WOPR_NETWORKS = '|| SQL%ROWCOUNT);

Line: 1969

    'insert into MSC_ST_JOB_OPERATION_NETWORKS'
    ||'  ( WIP_ENTITY_ID,'
    ||'    TO_WIP_ENTITY_ID,'
    --||'    RELATIONSHIP_TYPE,'
    ||'    DELETED_FLAG,'
    ||'    REFRESH_ID,'
    ||'    SR_INSTANCE_ID)'
    ||'  select'
    ||'    x.WIP_ENTITY_ID,'
    ||'    x.TO_WIP_ENTITY_ID,'
    --||'    x.RELATIONSHIP_TYPE,'
    ||'    1,'
    ||'    :v_refresh_id,'
    ||'    :v_instance_id'
    ||'  from MRP_AD_EAM_WO_RELSHIPS_V'||MSC_CL_PULL.v_dblink||' x'
    ||'  where x.RN> '||MSC_CL_PULL.v_lrn;

Line: 1990

        MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_EAM_WO_RELSHIPS_V = '|| SQL%ROWCOUNT);

Line: 2003

'insert into MSC_ST_JOB_OPERATIONS'
||'  ( WIP_ENTITY_ID,'
||'    OPERATION_SEQ_NUM,'
||'    DELETED_FLAG,'
||'    REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  select'
||'    x.WIP_ENTITY_ID,'
||'    x.OPERATION_SEQ_NUM,'
||'    1,'
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AD_JOB_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
||'  where x.RN> '||MSC_CL_PULL.v_lrn
||'   AND DECODE( x.operation_seq_num,'
||'               NULL, DECODE( :v_mps_consume_profile_value,'
||'                                        1, x.WJS_MPS_NET_QTY_FLAG,'
||'                                        x.WJS_NET_QTY_FLAG), '
||'               1)= 1'
|| v_temp_sql;

Line: 2028

    MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OPERATIONS_V = '|| SQL%ROWCOUNT);

Line: 2036

'insert into MSC_ST_JOB_REQUIREMENT_OPS'
||'  ( WIP_ENTITY_ID,'
||'    OPERATION_SEQ_NUM,'
||'    COMPONENT_ITEM_ID,'
||'    PRIMARY_COMPONENT_ID,'
||'    SOURCE_PHANTOM_ID,'
||'    DELETED_FLAG,'
||'    REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  select'
||'    x.WIP_ENTITY_ID,'
||'    x.OPERATION_SEQ_NUM,'
||'    x.COMPONENT_ITEM_ID,'
||'    x.PRIMARY_COMPONENT_ID,'
||'    x.SOURCE_PHANTOM_ID,'
||'    1,'
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AD_REQUIREMENT_OPS_V'||MSC_CL_PULL.v_dblink||' x'
||'  where x.RN> '||MSC_CL_PULL.v_lrn
||'   AND DECODE( x.operation_seq_num,'
||'               NULL, DECODE( :v_mps_consume_profile_value,'
||'                                        1, x.WJS_MPS_NET_QTY_FLAG,'
||'                                        x.WJS_NET_QTY_FLAG), '
||'               1)= 1'
|| v_temp_sql;

Line: 2067

    MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_REQUIREMENT_OPS_V = '|| SQL%ROWCOUNT);

Line: 2074

'insert into MSC_ST_JOB_OP_RESOURCES'
||'  ( WIP_ENTITY_ID,'
||'    OPERATION_SEQ_NUM,'
||'    RESOURCE_SEQ_NUM,'
||'    DELETED_FLAG,'
||'    REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  select'
||'    x.WIP_ENTITY_ID,'
||'    x.OPERATION_SEQ_NUM,'
||'    x.RESOURCE_SEQ_NUM,'
||'    1,'
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AD_JOB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
||'  where x.RN> '||MSC_CL_PULL.v_lrn
||'   AND DECODE( x.operation_seq_num,'
||'               NULL, DECODE( :v_mps_consume_profile_value,'
||'                                        1, x.WJS_MPS_NET_QTY_FLAG,'
||'                                        x.WJS_NET_QTY_FLAG), '
||'               1)= 1'
|| v_temp_sql;

Line: 2100

MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);

Line: 2107

'insert into MSC_ST_JOB_OP_RESOURCES'
||'  ( WIP_ENTITY_ID,'
||'    OPERATION_SEQ_NUM,'
||'    RESOURCE_SEQ_NUM,'
||'    DELETED_FLAG,'
||'    REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  select'
||'    x.WIP_ENTITY_ID,'
||'    x.OPERATION_SEQ_NUM,'
||'    x.RESOURCE_SEQ_NUM,'
||'    1,'
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AD_LJ_SUB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
||'  where x.RN> '||MSC_CL_PULL.v_lrn
||'   AND DECODE( x.operation_seq_num,'
||'               NULL, DECODE( :v_mps_consume_profile_value,'
||'                                        1, x.WJS_MPS_NET_QTY_FLAG,'
||'                                        x.WJS_NET_QTY_FLAG), '
||'               1)= 1'
|| v_temp_sql;

Line: 2134

MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_LJ_SUB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);

Line: 2143

'insert into MSC_ST_JOB_OPERATION_NETWORKS'
||'   (WIP_ENTITY_ID,'
||'    SR_INSTANCE_ID,'
||'    ORGANIZATION_ID,'
||'    FROM_OP_SEQ_NUM,'
||'    TO_OP_SEQ_NUM,'
||'    FROM_OP_SEQ_ID,'
||'    TO_OP_SEQ_ID ,'
||'    RECOMMENDED,'
||'    TRANSITION_TYPE ,'
||'    PLANNING_PCT,'
||'    ROUTING_SEQUENCE_ID,'
||'    DEPENDENCY_TYPE,'     /* ds change start */
||'    TO_WIP_ENTITY_ID,'
||'    TOP_WIP_ENTITY_ID,'  /* ds change end */
||'    DELETED_FLAG,'
||'    REFRESH_ID )'
||'    select '
||'    x.WIP_ENTITY_ID,'
||'    :v_instnace_id,'
||'    x.ORGANIZATION_ID,'
||'    x.FROM_OP_SEQ_NUM,'
||'    x.TO_OP_SEQ_NUM,'
||'    x.FROM_OP_SEQ_ID,'
||'    x.TO_OP_SEQ_ID,'
||'    x.RECOMMENDED,'
||'    x.TRANSITION_TYPE,'
||'    x.PLANNING_PCT,'
||'    x.ROUTING_SEQUENCE_ID,'
||'    x.DEPENDENCY_TYPE,'   /* ds change start */
||'    x.TO_WIP_ENTITY_ID,'
||'    x.TOP_WIP_ENTITY_ID,'  /*ds change end */
||'    2,'
||'    :v_refresh_id'
||'    FROM MRP_AP_JOB_OP_NETWORKS_V '||MSC_CL_PULL.v_dblink||' x '
||'    WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'    AND (x.RN >' ||MSC_CL_PULL.v_lrn
||'    OR x.RN1 >' ||MSC_CL_PULL.v_lrn
||'    OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';

Line: 2193

'insert into MSC_ST_JOB_OPERATIONS'
||'   (WIP_ENTITY_ID,'
||'    SR_INSTANCE_ID,'
||'    ORGANIZATION_ID,'
||'    OPERATION_SEQ_NUM,'
||'    RECOMMENDED,'
||'    RECO_START_DATE,'
||'    RECO_COMPLETION_DATE,'
||'    OPERATION_SEQUENCE_ID,'
||'    STANDARD_OPERATION_CODE,'
||'    NETWORK_START_END,'
||'    DEPARTMENT_ID,'
||'    OPERATION_LEAD_TIME_PERCENT,'
||'    MINIMUM_TRANSFER_QUANTITY,'
||'    EFFECTIVITY_DATE,'
||'    DISABLE_DATE,'
||'    OPERATION_TYPE,'
||'    YIELD,'
||'    CUMULATIVE_YIELD,'
||'    REVERSE_CUMULATIVE_YIELD,'
||'    NET_PLANNING_PERCENT,'
||'    DELETED_FLAG,'
||'    REFRESH_ID';

Line: 2224

||')   select '
||'    x.WIP_ENTITY_ID,'
||'    :v_instance_id,'
||'    x.ORGANIZATION_ID,'
||'    x.OPERATION_SEQ_NUM,'
||'    x.RECOMMENDED,'
||'    x.RECO_START_DATE - :v_dgmt,'
||'    x.RECO_COMPLETION_DATE - :v_dgmt,'
||'    x.OPERATION_SEQUENCE_ID,'
||'    x.STANDARD_OPERATION_CODE,'
||'    x.NETWORK_START_END,'
||'    x.DEPARTMENT_ID,'
||'    x.OPERATION_LEAD_TIME_PERCENT,'
||'    x.MINIMUM_TRANSFER_QUANTITY,'
||'    x.EFFECTIVITY_DATE - :v_dgmt,'
||'    x.DISABLE_DATE - :v_dgmt,'
||'    x.OPERATION_TYPE,'
||'    x.YIELD,'
||'    x.CUMULATIVE_YIELD,'
||'    x.REVERSE_CUMULATIVE_YIELD,'
||'    x.NET_PLANNING_PERCENT,'
||'    2,'
||'    :v_refresh_id';

Line: 2276

'insert into MSC_ST_JOB_REQUIREMENT_OPS'
||'   (WIP_ENTITY_ID,'
||'    SR_INSTANCE_ID,'
||'    ORGANIZATION_ID,'
||'    OPERATION_SEQ_NUM,'
||'    COMPONENT_ITEM_ID,'
||'    WIP_SUPPLY_TYPE,'
||'    PRIMARY_COMPONENT_ID,'
||'    SOURCE_PHANTOM_ID,'
||'    RECOMMENDED,'
||'    RECO_DATE_REQUIRED,'
||'    COMPONENT_SEQUENCE_ID,'
||'    COMPONENT_PRIORITY,'
||'    DEPARTMENT_ID,'
||'    QUANTITY_PER_ASSEMBLY,'
||'    COMPONENT_YIELD_FACTOR,'
||'    EFFECTIVITY_DATE,'
||'    DISABLE_DATE,'
||'    PLANNING_FACTOR,'
||'    LOW_QUANTITY,'
||'    HIGH_QUANTITY,'
||'    OPERATION_LEAD_TIME_PERCENT,'
||'    FROM_END_ITEM_UNIT_NUMBER,'
||'    TO_END_ITEM_UNIT_NUMBER,'
||'    COMPONENT_SCALING_TYPE,'
||'    DELETED_FLAG,'
||'    REFRESH_ID )'
||'    select '
||'    x.WIP_ENTITY_ID,'
||'    :v_instance_id,'
||'    x.ORGANIZATION_ID,'
||'    x.OPERATION_SEQ_NUM,'
||'    x.COMPONENT_ITEM_ID,'
||'    x.WIP_SUPPLY_TYPE,'
||'    x.PRIMARY_COMPONENT_ID,'
||'    x.SOURCE_PHANTOM_ID,'
||'    x.RECOMMENDED,'
||'    x.RECO_DATE_REQUIRED - :v_dgmt,'
||'    x.COMPONENT_SEQUENCE_ID,'
||'    x.COMPONENT_PRIORITY,'
||'    x.DEPARTMENT_ID,'
||'    x.QUANTITY_PER_ASSEMBLY,'
||'    x.COMPONENT_YIELD_FACTOR,'
||'    x.EFFECTIVITY_DATE - :v_dgmt,'
||'    x.DISABLE_DATE - :v_dgmt,'
||'    x.PLANNING_FACTOR,'
||'    x.LOW_QUANTITY,'
||'    x.HIGH_QUANTITY,'
||'    x.OPERATION_LEAD_TIME_PERCENT,'
||'    x.FROM_END_ITEM_UNIT_NUMBER,'
||'    x.TO_END_ITEM_UNIT_NUMBER,'
||     v_temp_sql1
||'    2,'
||'    :v_refresh_id'
||'    FROM MRP_AP_JOB_REQUIREMENT_OPS_V'||MSC_CL_PULL.v_dblink||' x'
||'    WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'    AND (x.RN >' ||MSC_CL_PULL.v_lrn
||'    OR x.RN1>' ||MSC_CL_PULL.v_lrn
||'    OR x.RN2>' ||MSC_CL_PULL.v_lrn || ' )';

Line: 2346

'insert into MSC_ST_JOB_OP_RESOURCES'
||'   (WIP_ENTITY_ID,'
||'    SR_INSTANCE_ID,'
||'    ORGANIZATION_ID,'
||'    OPERATION_SEQ_NUM,'
||'    RESOURCE_SEQ_NUM,'
||'    ALTERNATE_NUM,'
||'    RECOMMENDED,'
||'    RECO_START_DATE,'
||'    RECO_COMPLETION_DATE,'
||'    RESOURCE_ID,'
||'    ASSIGNED_UNITS,'
||'    USAGE_RATE_OR_AMOUNT,'
||'    UOM_CODE,'
||'    BASIS_TYPE,'
||'    RESOURCE_OFFSET_PERCENT,'
||'    SCHEDULE_SEQ_NUM,'
||'    PRINCIPAL_FLAG,'
||'    DEPARTMENT_ID,'
||'    ACTIVITY_GROUP_ID,'
||'    SCHEDULE_FLAG,'
||'    GROUP_SEQUENCE_ID,'	 /* ds change start */
||'    GROUP_SEQUENCE_NUMBER,'
||'    BATCH_NUMBER,'
||'    FIRM_FLAG,'
||'    SETUP_ID,'
||'    PARENT_SEQ_NUM,'
||'    MAXIMUM_ASSIGNED_UNITS,'	 /* ds change end */
||'    DELETED_FLAG,'
||'    REFRESH_ID )'
||'    select '
||'    x.WIP_ENTITY_ID,'
||'    :v_instance_id,'
||'    x.ORGANIZATION_ID,'
||'    x.OPERATION_SEQ_NUM,'
||'    x.RESOURCE_SEQ_NUM,'
||'    x.ALTERNATE_NUM,'
||'    x.RECOMMENDED,'
||'    x.RECO_START_DATE - :v_dgmt,'
||'    x.RECO_COMPLETION_DATE - :v_dgmt,'
||'    x.RESOURCE_ID,'
||'    x.ASSIGNED_UNITS,'
||'    x.USAGE_RATE_OR_AMOUNT,'
||'    x.UOM_CODE,'
||'    x.BASIS_TYPE,'
||'    x.RESOURCE_OFFSET_PERCENT,'
||'    x.SCHEDULE_SEQ_NUM,'
||'    x.PRINCIPLE_FLAG,'
||'    x.DEPARTMENT_ID,'
||'    x.ACTIVITY_GROUP_ID,'
||'    x.SCHEDULE_FLAG,'
||'    x.GROUP_SEQUENCE_ID,'
||'    x.GROUP_SEQUENCE_NUMBER,'
||'    x.BATCH_NUMBER,'
||'    x.FIRM_FLAG,'
||'    x.SETUP_ID,'
||'    x.PARENT_RESOURCE_SEQ,'
||'    x.MAXIMUM_ASSIGNED_UNITS,'
||'    2,'
||'    :v_refresh_id'
||'    FROM MRP_AP_JOB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
||'    WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'    AND (x.RN >' ||MSC_CL_PULL.v_lrn
||'    OR x.RN1>' ||MSC_CL_PULL.v_lrn
||'    OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';

Line: 2423

'insert into MSC_ST_JOB_OP_RESOURCES'
||'   (WIP_ENTITY_ID,'
||'    SR_INSTANCE_ID,'
||'    ORGANIZATION_ID,'
||'    OPERATION_SEQ_NUM,'
||'    RESOURCE_SEQ_NUM,'
||'    ALTERNATE_NUM,'
||'    RECOMMENDED,'
||'    RECO_START_DATE,'
||'    RECO_COMPLETION_DATE,'
||'    RESOURCE_ID,'
||'    ASSIGNED_UNITS,'
||'    USAGE_RATE_OR_AMOUNT,'
||'    UOM_CODE,'
||'    BASIS_TYPE,'
||'    RESOURCE_OFFSET_PERCENT,'
||'    SCHEDULE_SEQ_NUM,'
||'    PRINCIPAL_FLAG,'
||'    DEPARTMENT_ID,'
||'    ACTIVITY_GROUP_ID,'
||'    SCHEDULE_FLAG,'
||'    SETUP_ID,'    /* ds change */
||'    DELETED_FLAG,'
||'    REFRESH_ID )'
||'    select '
||'    x.WIP_ENTITY_ID,'
||'    :v_instance_id,'
||'    x.ORGANIZATION_ID,'
||'    x.copy_op_seq_num,'
||'    x.RESOURCE_SEQ_NUM,'
||'    x.ALTERNATE_NUM,'
||'    ''Y'' ,'
||'    NULL,'
||'    NULL,'
||'    x.RESOURCE_ID,'
||'    x.ASSIGNED_UNITS,'
||'    x.USAGE_RATE_OR_AMOUNT,'
||'    x.UOM_CODE,'
||'    x.BASIS_TYPE,'
||'    x.RESOURCE_OFFSET_PERCENT,'
||'    x.SCHEDULE_SEQ_NUM,'
||'    x.PRINCIPLE_FLAG,'
||'    x.DEPARTMENT_ID,'
||'    x.ACTIVITY_GROUP_ID,'
||'    x.SCHEDULE_FLAG,'
||'    x.SETUP_ID,'	/* ds change */
||'    2,'
||'    :v_refresh_id'
||'    FROM MRP_AP_LJ_SUB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
||'    WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'    AND (x.RN1>' || MSC_CL_PULL.v_lrn
||'    OR x.RN2>' ||MSC_CL_PULL.v_lrn
||'    OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';

Line: 2497

||'  select'
||'     x.PRIMARY_ITEM_ID,'
||'     x.ORGANIZATION_ID,'
||'     x.REPETITIVE_SCHEDULE_ID,'
||'     x.WIP_ENTITY_NAME, '
||'     x.LINE_ID,'
||'     x.FIRST_UNIT_COMPLETION_DATE- :v_dgmt,'
||'     x.FIRST_UNIT_START_DATE- :v_dgmt,'
||'     x.FIRST_UNIT_COMPLETION_DATE- :v_dgmt,'
||'     x.LAST_UNIT_START_DATE- :v_dgmt,'
||'     x.LAST_UNIT_COMPLETION_DATE- :v_dgmt,'
||'     x.PROCESSING_WORK_DAYS,'
||'     x.DAILY_PRODUCTION_RATE,'
||'     x.DAILY_PRODUCTION_RATE,'
||'     x.STATUS_CODE,'
||'     x.FIRM_PLANNED_FLAG,'
||'     x.QUANTITY_COMPLETED,'
||'     x.QUANTITY_SCRAPPED,'
--||'     DECODE( x.DEMAND_CLASS,NULL,NULL,:V_ICODE||x.DEMAND_CLASS),'
||'    x.DEMAND_CLASS,'
||'     30,'
||'     2,'
||'     :v_refresh_id,'
||'     :v_instance_id'
||'  from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND (x.RN2 > :v_lrn)'
||' UNION '
||'  select'
||'     x.PRIMARY_ITEM_ID,'
||'     x.ORGANIZATION_ID,'
||'     x.REPETITIVE_SCHEDULE_ID,'
||'    x.WIP_ENTITY_NAME, '
||'     x.LINE_ID,'
||'     x.FIRST_UNIT_COMPLETION_DATE- :v_dgmt,'
||'     x.FIRST_UNIT_START_DATE- :v_dgmt,'
||'     x.FIRST_UNIT_COMPLETION_DATE- :v_dgmt,'
||'     x.LAST_UNIT_START_DATE- :v_dgmt,'
||'     x.LAST_UNIT_COMPLETION_DATE- :v_dgmt,'
||'     x.PROCESSING_WORK_DAYS,'
||'     x.DAILY_PRODUCTION_RATE,'
||'     x.DAILY_PRODUCTION_RATE,'
||'     x.STATUS_CODE,'
||'     x.FIRM_PLANNED_FLAG,'
||'     x.QUANTITY_COMPLETED,'
||'     x.QUANTITY_SCRAPPED,'
--||'     DECODE( x.DEMAND_CLASS,NULL,NULL,:V_ICODE||x.DEMAND_CLASS),'
||'    x.DEMAND_CLASS,'
||'     30,'
||'     2,'
||'     :v_refresh_id,'
||'     :v_instance_id'
||'  from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND (x.RN3 > :v_lrn)'
||' UNION '
||'  select'
||'     x.PRIMARY_ITEM_ID,'
||'     x.ORGANIZATION_ID,'
||'     x.REPETITIVE_SCHEDULE_ID,'
||'     x.WIP_ENTITY_NAME, '
||'     x.LINE_ID,'
||'     x.FIRST_UNIT_COMPLETION_DATE- :v_dgmt,'
||'     x.FIRST_UNIT_START_DATE- :v_dgmt,'
||'     x.FIRST_UNIT_COMPLETION_DATE- :v_dgmt,'
||'     x.LAST_UNIT_START_DATE- :v_dgmt,'
||'     x.LAST_UNIT_COMPLETION_DATE- :v_dgmt,'
||'     x.PROCESSING_WORK_DAYS,'
||'     x.DAILY_PRODUCTION_RATE,'
||'     x.DAILY_PRODUCTION_RATE,'
||'     x.STATUS_CODE,'
||'     x.FIRM_PLANNED_FLAG,'
||'     x.QUANTITY_COMPLETED,'
||'     x.QUANTITY_SCRAPPED,'
--||'     DECODE( x.DEMAND_CLASS,NULL,NULL,:V_ICODE||x.DEMAND_CLASS),'
||'    x.DEMAND_CLASS,'
||'     30,'
||'     2,'
||'     :v_refresh_id,'
||'     :v_instance_id'
||'  from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND (x.RN4 > :v_lrn)';

Line: 2589

' insert into MSC_ST_SUPPLIES'
||'   ( INVENTORY_ITEM_ID,'
||'     ORGANIZATION_ID,'
||'     DISPOSITION_ID,'
||'     ORDER_NUMBER,'
||'     LINE_ID,'
||'     NEW_SCHEDULE_DATE,'
||'     FIRST_UNIT_START_DATE,'
||'     FIRST_UNIT_COMPLETION_DATE,'
||'     LAST_UNIT_START_DATE,'
||'     LAST_UNIT_COMPLETION_DATE,'
||'     NEW_PROCESSING_DAYS,'
||'     DAILY_RATE,'
||'     NEW_ORDER_QUANTITY,'
||'     WIP_STATUS_CODE,'
||'     FIRM_PLANNED_TYPE,'
||'     QTY_COMPLETED,'
||'     QTY_SCRAPPED,'
||'     DEMAND_CLASS,'
||'     ORDER_TYPE,'
||'     DELETED_FLAG,'
||'     REFRESH_ID,'
||'     SR_INSTANCE_ID)'
||'  select'
||'     x.PRIMARY_ITEM_ID,'
||'     x.ORGANIZATION_ID,'
||'     x.REPETITIVE_SCHEDULE_ID,'
||'     x.WIP_ENTITY_NAME, '
||'     x.LINE_ID,'
||'     x.FIRST_UNIT_COMPLETION_DATE- :v_dgmt,'
||'     x.FIRST_UNIT_START_DATE- :v_dgmt,'
||'     x.FIRST_UNIT_COMPLETION_DATE- :v_dgmt,'
||'     x.LAST_UNIT_START_DATE- :v_dgmt,'
||'     x.LAST_UNIT_COMPLETION_DATE- :v_dgmt,'
||'     x.PROCESSING_WORK_DAYS,'
||'     x.DAILY_PRODUCTION_RATE,'
||'     x.DAILY_PRODUCTION_RATE,'
||'     x.STATUS_CODE,'
||'     x.FIRM_PLANNED_FLAG,'
||'     x.QUANTITY_COMPLETED,'
||'     x.QUANTITY_SCRAPPED,'
--||'     DECODE( x.DEMAND_CLASS,NULL,NULL,:V_ICODE||x.DEMAND_CLASS),'
||'    x.DEMAND_CLASS,'
||'     30,'
||'     2,'
||'     :v_refresh_id,'
||'     :v_instance_id'
||'  from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
|| v_union_sql;