APPS.MSC_CL_BOM_PULL SQL Statements

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

Line: 51

' insert into MSC_ST_BOM_COMPONENTS'
||'( COMPONENT_SEQUENCE_ID,'
||'  BILL_SEQUENCE_ID,'
||'  DELETED_FLAG,'
||'  REFRESH_ID,'
||'  SR_INSTANCE_ID)'
||' select '
||'  x.COMPONENT_SEQUENCE_ID,'
||'  x.BILL_SEQUENCE_ID,'
||'  1,'
||'  :v_refresh_id,'
||'  :v_instance_id'
||'  from MRP_AD_BOM_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.RN> :v_lrn '
|| v_temp_sql;

Line: 96

||' select '
||'  x.COMPONENT_SEQUENCE_ID,'
||'  x.INVENTORY_ITEM_ID,'
||'  x.BILL_SEQUENCE_ID,'
||'  x.OPERATION_SEQ_NUM,'
||'  x.USAGE_QUANTITY,'
||'  x.COMPONENT_YIELD_FACTOR,'
||'  x.EFFECTIVITY_DATE- :v_dgmt,'
||'  x.DISABLE_DATE- :v_dgmt,'
||'  x.OPERATION_OFFSET_PERCENT,'
||'  x.OPTIONAL_COMPONENT,'
||'  x.WIP_SUPPLY_TYPE,'
||'  x.PLANNING_FACTOR,'
||'  x.REVISED_ITEM_SEQUENCE_ID,'
||'  x.ATP_FLAG,'
||'  x.STATUS_TYPE,'
||'  x.USE_UP_CODE,'
||'  x.CHANGE_NOTICE,'
||'  x.ORGANIZATION_ID,'
||'  x.USING_ASSEMBLY_ID,'
||'  x.FROM_UNIT_NUMBER,'
||'  x.TO_UNIT_NUMBER,'
||'  x.DRIVING_ITEM_ID,'
||'  2,'
||   v_rounding_sql
||   v_temp_sql1
||'  :v_refresh_id,'
||'  :v_instance_id'
||'  from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND ( x.RN2> :v_lrn )'
/* NCP
||' UNION '
||' select '
||'  x.COMPONENT_SEQUENCE_ID,'
||'  x.INVENTORY_ITEM_ID,'
||'  x.BILL_SEQUENCE_ID,'
||'  x.USAGE_QUANTITY,'
||'  x.COMPONENT_YIELD_FACTOR,'
||'  x.EFFECTIVITY_DATE- :v_dgmt,'
||'  x.DISABLE_DATE- :v_dgmt,'
||'  x.OPERATION_OFFSET_PERCENT,'
||'  x.OPTIONAL_COMPONENT,'
||'  x.WIP_SUPPLY_TYPE,'
||'  x.PLANNING_FACTOR,'
||'  x.REVISED_ITEM_SEQUENCE_ID,'
||'  x.ATP_FLAG,'
||'  x.STATUS_TYPE,'
||'  x.USE_UP_CODE,'
||'  x.CHANGE_NOTICE,'
||'  x.ORGANIZATION_ID,'
||'  x.USING_ASSEMBLY_ID,'
||'  x.FROM_UNIT_NUMBER,'
||'  x.TO_UNIT_NUMBER,'
||'  x.DRIVING_ITEM_ID,'
||'  2,'
||   v_rounding_sql
||'  :v_refresh_id,'
||'  :v_instance_id'
||'  from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')'
*/

||' UNION '
||' select '
||'  x.COMPONENT_SEQUENCE_ID,'
||'  x.INVENTORY_ITEM_ID,'
||'  x.BILL_SEQUENCE_ID,'
||'  x.OPERATION_SEQ_NUM,'
||'  x.USAGE_QUANTITY,'
||'  x.COMPONENT_YIELD_FACTOR,'
||'  x.EFFECTIVITY_DATE- :v_dgmt,'
||'  x.DISABLE_DATE- :v_dgmt,'
||'  x.OPERATION_OFFSET_PERCENT,'
||'  x.OPTIONAL_COMPONENT,'
||'  x.WIP_SUPPLY_TYPE,'
||'  x.PLANNING_FACTOR,'
||'  x.REVISED_ITEM_SEQUENCE_ID,'
||'  x.ATP_FLAG,'
||'  x.STATUS_TYPE,'
||'  x.USE_UP_CODE,'
||'  x.CHANGE_NOTICE,'
||'  x.ORGANIZATION_ID,'
||'  x.USING_ASSEMBLY_ID,'
||'  x.FROM_UNIT_NUMBER,'
||'  x.TO_UNIT_NUMBER,'
||'  x.DRIVING_ITEM_ID,'
||'  2,'
||   v_rounding_sql
||   v_temp_sql1
||'  :v_refresh_id,'
||'  :v_instance_id'
||'  from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND ( x.RN3> :v_lrn )'
||' UNION '
||' select '
||'  x.COMPONENT_SEQUENCE_ID,'
||'  x.INVENTORY_ITEM_ID,'
||'  x.BILL_SEQUENCE_ID,'
||'  x.OPERATION_SEQ_NUM,'
||'  x.USAGE_QUANTITY,'
||'  x.COMPONENT_YIELD_FACTOR,'
||'  x.EFFECTIVITY_DATE- :v_dgmt,'
||'  x.DISABLE_DATE- :v_dgmt,'
||'  x.OPERATION_OFFSET_PERCENT,'
||'  x.OPTIONAL_COMPONENT,'
||'  x.WIP_SUPPLY_TYPE,'
||'  x.PLANNING_FACTOR,'
||'  x.REVISED_ITEM_SEQUENCE_ID,'
||'  x.ATP_FLAG,'
||'  x.STATUS_TYPE,'
||'  x.USE_UP_CODE,'
||'  x.CHANGE_NOTICE,'
||'  x.ORGANIZATION_ID,'
||'  x.USING_ASSEMBLY_ID,'
||'  x.FROM_UNIT_NUMBER,'
||'  x.TO_UNIT_NUMBER,'
||'  x.DRIVING_ITEM_ID,'
||'  2,'
||   v_rounding_sql
||   v_temp_sql1
||'  :v_refresh_id,'
||'  :v_instance_id'
||'  from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND ( x.RN4> :v_lrn )';

Line: 226

||' select '
||'  x.COMPONENT_SEQUENCE_ID,'
||'  x.INVENTORY_ITEM_ID,'
||'  x.BILL_SEQUENCE_ID,'
||'  x.USAGE_QUANTITY,'
||'  x.COMPONENT_YIELD_FACTOR,'
||'  x.EFFECTIVITY_DATE- :v_dgmt,'
||'  x.DISABLE_DATE- :v_dgmt,'
||'  x.OPERATION_OFFSET_PERCENT,'
||'  x.OPTIONAL_COMPONENT,'
||'  x.WIP_SUPPLY_TYPE,'
||'  x.PLANNING_FACTOR,'
||'  x.REVISED_ITEM_SEQUENCE_ID,'
||'  x.ATP_FLAG,'
||'  x.STATUS_TYPE,'
||'  x.USE_UP_CODE,'
||'  x.CHANGE_NOTICE,'
||'  x.ORGANIZATION_ID,'
||'  x.USING_ASSEMBLY_ID,'
||'  x.FROM_UNIT_NUMBER,'
||'  x.TO_UNIT_NUMBER,'
||'  x.DRIVING_ITEM_ID,'
||'  2,'
||   v_rounding_sql
||'  :v_refresh_id,'
||'  :v_instance_id'
||'  from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND ( x.RN6>'||MSC_CL_PULL.v_lrn||')' ;

Line: 263

' insert into MSC_ST_BOM_COMPONENTS'
||'( COMPONENT_SEQUENCE_ID,'
||'  INVENTORY_ITEM_ID,'
||'  BILL_SEQUENCE_ID,'
||'  OPERATION_SEQ_NUM,'
||'  USAGE_QUANTITY,'
||'  COMPONENT_YIELD_FACTOR,'
||'  EFFECTIVITY_DATE,'
||'  DISABLE_DATE,'
||'  OPERATION_OFFSET_PERCENT,'
||'  OPTIONAL_COMPONENT,'
||'  WIP_SUPPLY_TYPE,'
||'  PLANNING_FACTOR,'
||'  REVISED_ITEM_SEQUENCE_ID,'
||'  ATP_FLAG,'
||'  STATUS_TYPE,'
||'  USE_UP_CODE,'
||'  CHANGE_NOTICE,'
||'  ORGANIZATION_ID,'
||'  USING_ASSEMBLY_ID,'
||'  FROM_UNIT_NUMBER,'
||'  TO_UNIT_NUMBER,'
||'  DRIVING_ITEM_ID,'
||'  DELETED_FLAG,'
||'  ROUNDING_DIRECTION,'
||'  SCALING_TYPE,'
||'  OLD_COMPONENT_SEQUENCE_ID,'
||'  REFRESH_ID,'
||'  SR_INSTANCE_ID)'
||' select '
||'  x.COMPONENT_SEQUENCE_ID,'
||'  x.INVENTORY_ITEM_ID,'
||'  x.BILL_SEQUENCE_ID,'
||'  x.OPERATION_SEQ_NUM,'
||'  x.USAGE_QUANTITY,'
||'  x.COMPONENT_YIELD_FACTOR,'
||'  x.EFFECTIVITY_DATE- :v_dgmt,'
||'  x.DISABLE_DATE- :v_dgmt,'
||'  x.OPERATION_OFFSET_PERCENT,'
||'  x.OPTIONAL_COMPONENT,'
||'  x.WIP_SUPPLY_TYPE,'
||'  x.PLANNING_FACTOR,'
||'  x.REVISED_ITEM_SEQUENCE_ID,'
||'  x.ATP_FLAG,'
||'  x.STATUS_TYPE,'
||'  x.USE_UP_CODE,'
||'  x.CHANGE_NOTICE,'
||'  x.ORGANIZATION_ID,'
||'  x.USING_ASSEMBLY_ID,'
||'  x.FROM_UNIT_NUMBER,'
||'  x.TO_UNIT_NUMBER,'
||'  x.DRIVING_ITEM_ID,'
||'  2,'
||   v_rounding_sql
||   v_temp_sql1
||'  :v_refresh_id,'
||'  :v_instance_id'
||'  from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
|| v_union_sql ;

Line: 358

' insert into MSC_ST_BOMS'
||' ( BILL_SEQUENCE_ID,'
||'   DELETED_FLAG,'
||'   REFRESH_ID,'
||'   SR_INSTANCE_ID)'
||' SELECT'
||'   x.BILL_SEQUENCE_ID,    '
||'   1,'
||'   :v_refresh_id,'
||'   :v_instance_id'
||'  FROM MRP_AD_BOMS_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.RN> :v_lrn '
|| v_temp_sql;

Line: 387

||' SELECT'
||'   x.BILL_SEQUENCE_ID,    '
||'   x.ORGANIZATION_ID,  '
||'   x.ASSEMBLY_ITEM_ID, '
||'   x.ASSEMBLY_TYPE,   '
||'   x.ALTERNATE_BOM_DESIGNATOR, '
||'   x.SPECIFIC_ASSEMBLY_COMMENT, '
||'   x.PENDING_FROM_ECN,    '
||'   x.COMMON_BILL_SEQUENCE_ID, '
||'   2,'
||'  :v_refresh_id,'
||'   :v_instance_id'
||'  FROM MRP_AP_BOMS_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND (x.RN2 > :v_lrn)';

Line: 410

' insert into MSC_ST_BOMS'
||' ( BILL_SEQUENCE_ID,'
||'   ORGANIZATION_ID,'
||'   ASSEMBLY_ITEM_ID,'
||'   ASSEMBLY_TYPE,'
||'   ALTERNATE_BOM_DESIGNATOR,'
||'   SPECIFIC_ASSEMBLY_COMMENT,'
||'   PENDING_FROM_ECN,'
||'   COMMON_BILL_SEQUENCE_ID,'
||'   DELETED_FLAG,'
||'   REFRESH_ID,'
||'   SR_INSTANCE_ID)'
||' SELECT'
||'   x.BILL_SEQUENCE_ID,    '
||'   x.ORGANIZATION_ID,  '
||'   x.ASSEMBLY_ITEM_ID, '
||'   x.ASSEMBLY_TYPE,   '
||'   x.ALTERNATE_BOM_DESIGNATOR, '
||'   x.SPECIFIC_ASSEMBLY_COMMENT, '
||'   x.PENDING_FROM_ECN,    '
||'   x.COMMON_BILL_SEQUENCE_ID, '
||'   2,'
||'  :v_refresh_id,'
||'   :v_instance_id'
||'  FROM MRP_AP_BOMS_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
|| v_union_sql;

Line: 459

' insert into MSC_ST_COMPONENT_SUBSTITUTES'
||' ( BILL_SEQUENCE_ID,'
||'   COMPONENT_SEQUENCE_ID,'
||'   SUBSTITUTE_ITEM_ID,'
||'   DELETED_FLAG,'
||'   REFRESH_ID,'
||'   SR_INSTANCE_ID)'
||' SELECT'
||'   x.BILL_SEQUENCE_ID,'
||'   x.COMPONENT_SEQUENCE_ID,'
||'   x.SUBSTITUTE_ITEM_ID,'
||'   1,'
||'   :v_refresh_id,'
||'   :v_instance_id'
||'  FROM MRP_AD_SUB_COMPS_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
||' AND x.RN > :v_lrn';

Line: 503

||' SELECT'
||'   x.BILL_SEQUENCE_ID,'
||'   x.COMPONENT_SEQUENCE_ID,'
||'   x.SUBSTITUTE_ITEM_ID,'
||'   x.USAGE_QUANTITY,'
||'   x.ORGANIZATION_ID,'
||'   NVL( TO_NUMBER(DECODE( :v_msc_bom_subst_priority,'
||'            1, x.Attribute1,'
||'            2, x.Attribute2,'
||'            3, x.Attribute3,'
||'            4, x.Attribute4,'
||'            5, x.Attribute5,'
||'            6, x.Attribute6,'
||'            7, x.Attribute7,'
||'            8, x.Attribute8,'
||'            9, x.Attribute9,'
||'            10, x.Attribute10,'
||'            11, x.Attribute11,'
||'            12, x.Attribute12,'
||'            13, x.Attribute13,'
||'            14, x.Attribute14,'
||'            15, x.Attribute15)),2),'
||'   2,'
||   v_rounding_sql
||'  :v_refresh_id,'
||'   :v_instance_id'
||'  FROM MRP_AP_COMPONENT_SUBSTITUTES_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.BILL_SEQUENCE_ID,'
||'   x.COMPONENT_SEQUENCE_ID,'
||'   x.SUBSTITUTE_ITEM_ID,'
||'   x.USAGE_QUANTITY,'
||'   x.ORGANIZATION_ID,'
||'   NVL( TO_NUMBER(DECODE( :v_msc_bom_subst_priority,'
||'            1, x.Attribute1,'
||'            2, x.Attribute2,'
||'            3, x.Attribute3,'
||'            4, x.Attribute4,'
||'            5, x.Attribute5,'
||'            6, x.Attribute6,'
||'            7, x.Attribute7,'
||'            8, x.Attribute8,'
||'            9, x.Attribute9,'
||'            10, x.Attribute10,'
||'            11, x.Attribute11,'
||'            12, x.Attribute12,'
||'            13, x.Attribute13,'
||'            14, x.Attribute14,'
||'            15, x.Attribute15)),2),'
||'   2,'
||   v_rounding_sql
||'  :v_refresh_id,'
||'   :v_instance_id'
||'  FROM MRP_AP_COMPONENT_SUBSTITUTES_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.BILL_SEQUENCE_ID,'
||'   x.COMPONENT_SEQUENCE_ID,'
||'   x.SUBSTITUTE_ITEM_ID,'
||'   x.USAGE_QUANTITY,'
||'   x.ORGANIZATION_ID,'
||'   NVL( TO_NUMBER(DECODE( :v_msc_bom_subst_priority,'
||'            1, x.Attribute1,'
||'            2, x.Attribute2,'
||'            3, x.Attribute3,'
||'            4, x.Attribute4,'
||'            5, x.Attribute5,'
||'            6, x.Attribute6,'
||'            7, x.Attribute7,'
||'            8, x.Attribute8,'
||'            9, x.Attribute9,'
||'            10, x.Attribute10,'
||'            11, x.Attribute11,'
||'            12, x.Attribute12,'
||'            13, x.Attribute13,'
||'            14, x.Attribute14,'
||'            15, x.Attribute15)),2),'
||'   2,'
||   v_rounding_sql
||'  :v_refresh_id,'
||'   :v_instance_id'
||'  FROM MRP_AP_COMPONENT_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND (x.RN4 > :v_lrn)';

Line: 597

||' SELECT'
||'   x.BILL_SEQUENCE_ID,'
||'   x.COMPONENT_SEQUENCE_ID,'
||'   x.SUBSTITUTE_ITEM_ID,'
||'   x.USAGE_QUANTITY,'
||'   x.ORGANIZATION_ID,'
||'   NVL( TO_NUMBER(DECODE( :v_msc_bom_subst_priority,'
||'            1, x.Attribute1,'
||'            2, x.Attribute2,'
||'            3, x.Attribute3,'
||'            4, x.Attribute4,'
||'            5, x.Attribute5,'
||'            6, x.Attribute6,'
||'            7, x.Attribute7,'
||'            8, x.Attribute8,'
||'            9, x.Attribute9,'
||'            10, x.Attribute10,'
||'            11, x.Attribute11,'
||'            12, x.Attribute12,'
||'            13, x.Attribute13,'
||'            14, x.Attribute14,'
||'            15, x.Attribute15)),2),'
||'   2,'
||   v_rounding_sql
||'  :v_refresh_id,'
||'   :v_instance_id'
||'  FROM MRP_AP_COMPONENT_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND (x.RN5 > :v_lrn)';

Line: 636

' INSERT INTO MSC_ST_COMPONENT_SUBSTITUTES'
||' ( BILL_SEQUENCE_ID,'
||'   COMPONENT_SEQUENCE_ID,'
||'   SUBSTITUTE_ITEM_ID,'
||'   USAGE_QUANTITY,'
||'   ORGANIZATION_ID,'
||'   PRIORITY,'
||'   DELETED_FLAG,'
||'   ROUNDING_DIRECTION,'
||'   REFRESH_ID,'
||'   SR_INSTANCE_ID)'
||' SELECT'
||'   x.BILL_SEQUENCE_ID,'
||'   x.COMPONENT_SEQUENCE_ID,'
||'   x.SUBSTITUTE_ITEM_ID,'
||'   x.USAGE_QUANTITY,'
||'   x.ORGANIZATION_ID,'
||'   NVL( TO_NUMBER(DECODE( :v_msc_bom_subst_priority,'
||'            1, x.Attribute1,'
||'            2, x.Attribute2,'
||'            3, x.Attribute3,'
||'            4, x.Attribute4,'
||'            5, x.Attribute5,'
||'            6, x.Attribute6,'
||'            7, x.Attribute7,'
||'            8, x.Attribute8,'
||'            9, x.Attribute9,'
||'            10, x.Attribute10,'
||'            11, x.Attribute11,'
||'            12, x.Attribute12,'
||'            13, x.Attribute13,'
||'            14, x.Attribute14,'
||'            15, x.Attribute15)),2),'
||'   2,'
||   v_rounding_sql
||'  :v_refresh_id,'
||'   :v_instance_id'
||'  FROM MRP_AP_COMPONENT_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
|| v_union_sql;

Line: 706

select instance_code into lv_icode from msc_apps_instances where instance_id = MSC_CL_PULL.v_instance_id;

Line: 760

' INSERT INTO MSC_ST_PROCESS_EFFECTIVITY'
||'  ( ITEM_ID,'
||'    ORGANIZATION_ID,'
||'    BILL_SEQUENCE_ID,'
||'    ROUTING_SEQUENCE_ID,'
||'    LINE_ID,'
||'    DELETED_FLAG,'
||'    REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  SELECT'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.BILL_SEQUENCE_ID,'
||'    x.ROUTING_SEQUENCE_ID,'
||'    x.LINE_ID,'
||'    1,'
||'    :v_refresh_id,'
||'    :v_instance_id'
||'  FROM MRP_AD_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

Line: 795

||'  SELECT'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.BILL_SEQUENCE_ID,'
||'    x.ROUTING_SEQUENCE_ID,'
||'    x.EFFECTIVITY_DATE,'
||'    x.LINE_ID,'
||'    x.PREFERENCE,'
||'    x.PRIMARY_LINE_FLAG,'
||'    x.PRODUCTION_LINE_RATE,'
||'    x.LOAD_DISTRIBUTION_PRIORITY,'
||'    NVL( TO_NUMBER(DECODE( :v_msc_alt_bom_cost,'
     ||'       1, x.Attribute1,'
     ||'       2, x.Attribute2,'
     ||'       3, x.Attribute3,'
     ||'       4, x.Attribute4,'
     ||'       5, x.Attribute5,'
     ||'       6, x.Attribute6,'
     ||'       7, x.Attribute7,'
     ||'       8, x.Attribute8,'
     ||'       9, x.Attribute9,'
     ||'       10, x.Attribute10,'
     ||'       11, x.Attribute11,'
     ||'       12, x.Attribute12,'
     ||'       13, x.Attribute13,'
     ||'       14, x.Attribute14,'
     ||'       15, x.Attribute15)),0),'
||'    2,'
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  FROM MRP_AP_PROCESS_EFFECTIVITY_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||')'
*/

||' UNION '
||'  SELECT'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.BILL_SEQUENCE_ID,'
||'    x.ROUTING_SEQUENCE_ID,'
||'    x.EFFECTIVITY_DATE,'
||'    x.LINE_ID,'
||'    x.PREFERENCE,'
||'    x.PRIMARY_LINE_FLAG,'
||'    x.PRODUCTION_LINE_RATE,'
||'    x.LOAD_DISTRIBUTION_PRIORITY,'
||'    NVL( TO_NUMBER(DECODE( :v_msc_alt_bom_cost,'
     ||'       1, x.Attribute1,'
     ||'       2, x.Attribute2,'
     ||'       3, x.Attribute3,'
     ||'       4, x.Attribute4,'
     ||'       5, x.Attribute5,'
     ||'       6, x.Attribute6,'
     ||'       7, x.Attribute7,'
     ||'       8, x.Attribute8,'
     ||'       9, x.Attribute9,'
     ||'       10, x.Attribute10,'
     ||'       11, x.Attribute11,'
     ||'       12, x.Attribute12,'
     ||'       13, x.Attribute13,'
     ||'       14, x.Attribute14,'
     ||'       15, x.Attribute15)),0),'
||'    2,'
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  FROM MRP_AP_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')'
||' UNION '
||'  SELECT'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.BILL_SEQUENCE_ID,'
||'    x.ROUTING_SEQUENCE_ID,'
||'    x.EFFECTIVITY_DATE,'
||'    x.LINE_ID,'
||'    x.PREFERENCE,'
||'    x.PRIMARY_LINE_FLAG,'
||'    x.PRODUCTION_LINE_RATE,'
||'    x.LOAD_DISTRIBUTION_PRIORITY,'
||'    NVL( TO_NUMBER(DECODE( :v_msc_alt_bom_cost,'
     ||'       1, x.Attribute1,'
     ||'       2, x.Attribute2,'
     ||'       3, x.Attribute3,'
     ||'       4, x.Attribute4,'
     ||'       5, x.Attribute5,'
     ||'       6, x.Attribute6,'
     ||'       7, x.Attribute7,'
     ||'       8, x.Attribute8,'
     ||'       9, x.Attribute9,'
     ||'       10, x.Attribute10,'
     ||'       11, x.Attribute11,'
     ||'       12, x.Attribute12,'
     ||'       13, x.Attribute13,'
     ||'       14, x.Attribute14,'
     ||'       15, x.Attribute15)),0),'
||'    2,'
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  FROM MRP_AP_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND ( x.RN4>'||MSC_CL_PULL.v_lrn||')';

Line: 900

||'  SELECT'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.BILL_SEQUENCE_ID,'
||'    x.ROUTING_SEQUENCE_ID,'
||'    x.EFFECTIVITY_DATE,'
||'    x.LINE_ID,'
||'    x.PREFERENCE,'
||'    x.PRIMARY_LINE_FLAG,'
||'    x.PRODUCTION_LINE_RATE,'
||'    x.LOAD_DISTRIBUTION_PRIORITY,'
||'    NVL( TO_NUMBER(DECODE( :v_msc_alt_bom_cost,'
     ||'       1, x.Attribute1,'
     ||'       2, x.Attribute2,'
     ||'       3, x.Attribute3,'
     ||'       4, x.Attribute4,'
     ||'       5, x.Attribute5,'
     ||'       6, x.Attribute6,'
     ||'       7, x.Attribute7,'
     ||'       8, x.Attribute8,'
     ||'       9, x.Attribute9,'
     ||'       10, x.Attribute10,'
     ||'       11, x.Attribute11,'
     ||'       12, x.Attribute12,'
     ||'       13, x.Attribute13,'
     ||'       14, x.Attribute14,'
     ||'       15, x.Attribute15)),0),'
||'    2,'
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  FROM MRP_AP_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
||'   AND ( x.RN5>'||MSC_CL_PULL.v_lrn||')' ;

Line: 944

' INSERT INTO MSC_ST_PROCESS_EFFECTIVITY'
||'  ( ITEM_ID,'
||'    ORGANIZATION_ID,'
||'    BILL_SEQUENCE_ID,'
||'    ROUTING_SEQUENCE_ID,'
||'    EFFECTIVITY_DATE,'
||'    LINE_ID,'
||'    PREFERENCE,'
||'    PRIMARY_LINE_FLAG,'
||'    PRODUCTION_LINE_RATE,'
||'    LOAD_DISTRIBUTION_PRIORITY,'
||'    ITEM_PROCESS_COST,'
||'    DELETED_FLAG,'
||'    REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  SELECT'
||'    x.INVENTORY_ITEM_ID,'
||'    x.ORGANIZATION_ID,'
||'    x.BILL_SEQUENCE_ID,'
||'    x.ROUTING_SEQUENCE_ID,'
||'    x.EFFECTIVITY_DATE,'
||'    x.LINE_ID,'
||'    x.PREFERENCE,'
||'    x.PRIMARY_LINE_FLAG,'
||'    x.PRODUCTION_LINE_RATE,'
||'    x.LOAD_DISTRIBUTION_PRIORITY,'
||'    NVL( TO_NUMBER(DECODE( :v_msc_alt_bom_cost,'
     ||'       1, x.Attribute1,'
     ||'       2, x.Attribute2,'
     ||'       3, x.Attribute3,'
     ||'       4, x.Attribute4,'
     ||'       5, x.Attribute5,'
     ||'       6, x.Attribute6,'
     ||'       7, x.Attribute7,'
     ||'       8, x.Attribute8,'
     ||'       9, x.Attribute9,'
     ||'       10, x.Attribute10,'
     ||'       11, x.Attribute11,'
     ||'       12, x.Attribute12,'
     ||'       13, x.Attribute13,'
     ||'       14, x.Attribute14,'
     ||'       15, x.Attribute15)),0),'
||'    2,'
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  FROM MRP_AP_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
|| v_union_sql ;

Line: 1035

' insert into MSC_ST_BILL_OF_RESOURCES'
||'  ( BILL_OF_RESOURCES,'
||'    ORGANIZATION_ID,'
||'    DESCRIPTION,'
||'    DISABLE_DATE,'
||'    ROLLUP_START_DATE,'
||'    ROLLUP_COMPLETION_DATE,'
||'    DELETED_FLAG,'
||'   REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  select'
||'    x.BILL_OF_RESOURCES,'
||'    x.ORGANIZATION_ID,'
||'    x.DESCRIPTION,'
||'    x.DISABLE_DATE- :v_dgmt,'
||'    x.ROLLUP_START_DATE- :v_dgmt,'
||'    x.ROLLUP_COMPLETION_DATE- :v_dgmt,'
||'    2,'
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AP_BILL_OF_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||')';

Line: 1068

' insert into MSC_ST_BOR_REQUIREMENTS'
||'  ( BILL_OF_RESOURCES,'
||'    ORGANIZATION_ID,'
||'    ASSEMBLY_ITEM_ID,'
||'    SOURCE_ITEM_ID,'
||'    RESOURCE_ID,'
||'    RESOURCE_DEPARTMENT_HOURS,'
||'    OPERATION_SEQUENCE_ID,'
||'    OPERATION_SEQ_NUM,'
||'    RESOURCE_SEQ_NUM,'
||'    SETBACK_DAYS,'
||'    DEPARTMENT_ID,'
||'    ASSEMBLY_USAGE,'
||'    ORIGINATION_TYPE,'
||'    RESOURCE_UNITS,'
||'    BASIS,'
||'    DELETED_FLAG,'
||'   REFRESH_ID,'
||'    SR_INSTANCE_ID)'
||'  select'
||'    x.BILL_OF_RESOURCES,'
||'    x.ORGANIZATION_ID,'
||'    x.ASSEMBLY_ITEM_ID,'
||'    x.SOURCE_ITEM_ID,'
||'    x.RESOURCE_ID,'
||'    x.RESOURCE_DEPARTMENT_HOURS,'
||'    x.OPERATION_SEQUENCE_ID,'
||'    x.OPERATION_SEQ_NUM,'
||'    x.RESOURCE_SEQ_NUM,'
||'    x.SETBACK_DAYS,'
||'    NVL(x.DEPARTMENT_ID, x.LINE_ID),'
||'    NVL(x.ASSEMBLY_USAGE,1),'
||'    x.ORIGINATION_TYPE,'
||'    NVL(x.RESOURCE_UNITS,1),'
||'    x.BASIS,'
||'    2,'
||'  :v_refresh_id,'
||'    :v_instance_id'
||'  from MRP_AP_CRP_RESOURCE_HOURS_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE DECODE( :WIP_ENABLED, 2, LINE_ID) IS NULL'
||'   AND 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: 1161

' insert into MSC_ST_DEPARTMENT_RESOURCES'
||' ( RESOURCE_ID,'
||'   DEPARTMENT_ID,'
||'   LINE_FLAG,'
||'   OWNING_DEPARTMENT_ID,'
||'   CAPACITY_UNITS,'
||'   RESOURCE_GROUP_NAME,'
||'   ORGANIZATION_ID,'
||'   DEPARTMENT_CODE,'
||'   DEPARTMENT_CLASS,'
||'   DEPARTMENT_DESCRIPTION,'
||'   RESOURCE_CODE,'
||'   RESOURCE_DESCRIPTION,'
||'   OVER_UTILIZED_PERCENT,'
||'   UNDER_UTILIZED_PERCENT,'
||'   RESOURCE_SHORTAGE_TYPE,'
||'   RESOURCE_EXCESS_TYPE,'
||'   PLANNING_EXCEPTION_SET,'
||'   USER_TIME_FENCE,'
||'   AGGREGATED_RESOURCE_FLAG,'
||'   AGGREGATED_RESOURCE_ID,'
||'   RESOURCE_TYPE,'
||'   DISABLE_DATE,'
||'   AVAILABLE_24_HOURS_FLAG,'
||'   CTP_FLAG,'
||'   UTILIZATION,'
||'   EFFICIENCY,'
||'   BATCHABLE_FLAG,'
||'   BATCHING_WINDOW,'
||'   MIN_CAPACITY,'
||'   MAX_CAPACITY,'
||'   UNIT_OF_MEASURE,'
||'   RESOURCE_COST,'
||'   RESOURCE_OVER_UTIL_COST,'
||'   DEPT_OVERHEAD_COST,'
||'   DELETED_FLAG,'
||'   REFRESH_ID,'
||'   ATP_RULE_ID,'
||'   SCHEDULE_TO_INSTANCE,'  /* ds change */
||'   BATCHING_PENALTY,'
||'   SETUP_TIME_PERCENT,'
||'   UTILIZATION_CHANGE_PERCENT,'
||'   SETUP_TIME_TYPE,'
||'   UTILIZATION_CHANGE_TYPE,'
||'   IDLE_TIME_TOLERANCE,'
||'   SDS_SCHEDULING_WINDOW,' /* ds change */
||'   SR_INSTANCE_ID)'
||'  select'
||'    x.RESOURCE_ID,'
||'    x.DEPARTMENT_ID,'
||'    x.LINE_FLAG,'
||'    x.OWNING_DEPARTMENT_ID,'
||'    x.CAPACITY_UNITS,'
||'    x.RESOURCE_GROUP_NAME,'
||'    x.ORGANIZATION_ID,'
||'    x.DEPARTMENT_CODE,'
||'    x.DEPARTMENT_CLASS,'
||'    x.DEPARTMENT_DESCRIPTION,'
||'    x.RESOURCE_CODE,'
||'    x.RESOURCE_DESCRIPTION,'
||'    x.OVER_UTILIZED_PERCENT,'
||'    x.UNDER_UTILIZED_PERCENT,'
||'    x.RESOURCE_SHORTAGE_TYPE,'
||'    x.RESOURCE_EXCESS_TYPE,'
||'    x.PLANNING_EXCEPTION_SET,'
||'    x.USER_TIME_FENCE,'
||'    DECODE( TO_NUMBER(DECODE( :v_msc_aggreg_res_name,'
                  ||'            1, x.Attribute1,'
                  ||'            2, x.Attribute2,'
                  ||'            3, x.Attribute3,'
                  ||'            4, x.Attribute4,'
                  ||'            5, x.Attribute5,'
                  ||'            6, x.Attribute6,'
                  ||'            7, x.Attribute7,'
                  ||'            8, x.Attribute8,'
                  ||'            9, x.Attribute9,'
                  ||'            10, x.Attribute10,'
                  ||'            11, x.Attribute11,'
                  ||'            12, x.Attribute12,'
                  ||'            13, x.Attribute13,'
                  ||'            14, x.Attribute14,'
                  ||'            15, x.Attribute15)*2),'
||'            x.RESOURCE_ID, 1,'
||'            2),'
||'    TO_NUMBER(DECODE( :v_msc_aggreg_res_name,'
||'            1, x.Attribute1,'
||'            2, x.Attribute2,'
||'            3, x.Attribute3,'
||'            4, x.Attribute4,'
||'            5, x.Attribute5,'
||'            6, x.Attribute6,'
||'            7, x.Attribute7,'
||'            8, x.Attribute8,'
||'            9, x.Attribute9,'
||'            10, x.Attribute10,'
||'            11, x.Attribute11,'
||'            12, x.Attribute12,'
||'            13, x.Attribute13,'
||'            14, x.Attribute14,'
||'            15, x.Attribute15)*2),'
||'    x.RESOURCE_TYPE,'
||'    x.DISABLE_DATE- :v_dgmt,'
||'    x.AVAILABLE_24_HOURS_FLAG,'
||'    x.CTP_FLAG,'
||'    x.UTILIZATION,'
||'    x.EFFICIENCY,'
||'    x.BATCHABLE,'
||'    x.BATCH_WINDOW,'
||'    x.MIN_BATCH_CAPACITY,'
||'    x.MAX_BATCH_CAPACITY,'
||'    x.BATCH_CAPACITY_UOM,'
||'    x.RESOURCE_COST,'
||'    TO_NUMBER(DECODE( :v_mso_res_penalty,'
||'            1, x.Attribute1,'
||'            2, x.Attribute2,'
||'            3, x.Attribute3,'
||'            4, x.Attribute4,'
||'            5, x.Attribute5,'
||'            6, x.Attribute6,'
||'            7, x.Attribute7,'
||'            8, x.Attribute8,'
||'            9, x.Attribute9,'
||'            10, x.Attribute10,'
||'            11, x.Attribute11,'
||'            12, x.Attribute12,'
||'            13, x.Attribute13,'
||'            14, x.Attribute14,'
||'            15, x.Attribute15)),'
||'    x.DEPT_OVERHEAD_COST,'
||'    2,'
||'  :v_refresh_id,'
||   v_temp_atp_rule_sql
||'    :v_instance_id'
||'  from MRP_AP_DEPARTMENT_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

Line: 1305

' insert into MSC_ST_DEPARTMENT_RESOURCES'
||' ( RESOURCE_ID,'
||'   DEPARTMENT_ID,'
||'   LINE_FLAG,'
||'   OWNING_DEPARTMENT_ID,'
||'   CAPACITY_UNITS,'
||'   RESOURCE_GROUP_NAME,'
||'   ORGANIZATION_ID,'
||'   DEPARTMENT_CODE,'
||'   DEPARTMENT_CLASS,'
||'   DEPARTMENT_DESCRIPTION,'
||'   RESOURCE_CODE,'
||'   RESOURCE_DESCRIPTION,'
||'   OVER_UTILIZED_PERCENT,'
||'   UNDER_UTILIZED_PERCENT,'
||'   RESOURCE_SHORTAGE_TYPE,'
||'   RESOURCE_EXCESS_TYPE,'
||'   PLANNING_EXCEPTION_SET,'
||'   USER_TIME_FENCE,'
||'   AGGREGATED_RESOURCE_FLAG,'
||'   AGGREGATED_RESOURCE_ID,'
||'   RESOURCE_TYPE,'
||'   DISABLE_DATE,'
||'   AVAILABLE_24_HOURS_FLAG,'
||'   CTP_FLAG,'
||'   UTILIZATION,'
||'   EFFICIENCY,'
||'   BATCHABLE_FLAG,'
||'   BATCHING_WINDOW,'
||'   MIN_CAPACITY,'
||'   MAX_CAPACITY,'
||'   UNIT_OF_MEASURE,'
||'   RESOURCE_COST,'
||'   RESOURCE_OVER_UTIL_COST,'
||'   DEPT_OVERHEAD_COST,'
||'   DELETED_FLAG,'
||'   REFRESH_ID,'
||'   ATP_RULE_ID,'
||'   SCHEDULE_TO_INSTANCE,' /* ds change */
||'   BATCHING_PENALTY,'
||'   SETUP_TIME_PERCENT,'
||'   UTILIZATION_CHANGE_PERCENT,'
||'   SETUP_TIME_TYPE,'
||'   UTILIZATION_CHANGE_TYPE,'
||'   IDLE_TIME_TOLERANCE,'
||'   SDS_SCHEDULING_WINDOW,' /* ds change */
||'   SR_INSTANCE_ID)'
||'  select'
||'    x.RESOURCE_ID,'
||'    x.DEPARTMENT_ID,'
||'    x.LINE_FLAG,'
||'    x.OWNING_DEPARTMENT_ID,'
||'    x.CAPACITY_UNITS,'
||'    x.RESOURCE_GROUP_NAME,'
||'    x.ORGANIZATION_ID,'
||'    x.DEPARTMENT_CODE,'
||'    x.DEPARTMENT_CLASS,'
||'    x.DEPARTMENT_DESCRIPTION,'
||'    x.RESOURCE_CODE,'
||'    x.RESOURCE_DESCRIPTION,'
||'    x.OVER_UTILIZED_PERCENT,'
||'    x.UNDER_UTILIZED_PERCENT,'
||'    x.RESOURCE_SHORTAGE_TYPE,'
||'    x.RESOURCE_EXCESS_TYPE,'
||'    x.PLANNING_EXCEPTION_SET,'
||'    x.USER_TIME_FENCE,'
||'    DECODE( TO_NUMBER(DECODE( :v_msc_aggreg_res_name,'
                  ||'            1, x.Attribute1,'
                  ||'            2, x.Attribute2,'
                  ||'            3, x.Attribute3,'
                  ||'            4, x.Attribute4,'
                  ||'            5, x.Attribute5,'
                  ||'            6, x.Attribute6,'
                  ||'            7, x.Attribute7,'
                  ||'            8, x.Attribute8,'
                  ||'            9, x.Attribute9,'
                  ||'            10, x.Attribute10,'
                  ||'            11, x.Attribute11,'
                  ||'            12, x.Attribute12,'
                  ||'            13, x.Attribute13,'
                  ||'            14, x.Attribute14,'
                  ||'            15, x.Attribute15)),'
||'            x.RESOURCE_ID, 1,'
||'            2),'
||'    TO_NUMBER(DECODE( :v_msc_aggreg_res_name,'
||'            1, x.Attribute1,'
||'            2, x.Attribute2,'
||'            3, x.Attribute3,'
||'            4, x.Attribute4,'
||'            5, x.Attribute5,'
||'            6, x.Attribute6,'
||'            7, x.Attribute7,'
||'            8, x.Attribute8,'
||'            9, x.Attribute9,'
||'            10, x.Attribute10,'
||'            11, x.Attribute11,'
||'            12, x.Attribute12,'
||'            13, x.Attribute13,'
||'            14, x.Attribute14,'
||'            15, x.Attribute15)),'
||'    x.RESOURCE_TYPE,'
||'    x.DISABLE_DATE- :v_dgmt,'
||'    x.AVAILABLE_24_HOURS_FLAG,'
||'    x.CTP_FLAG,'
||'    x.UTILIZATION,'
||'    x.EFFICIENCY,'
||'    TO_NUMBER(DECODE( :v_msc_batchable_flag,'
||'            1, x.Attribute1,'
||'            2, x.Attribute2,'
||'            3, x.Attribute3,'
||'            4, x.Attribute4,'
||'            5, x.Attribute5,'
||'            6, x.Attribute6,'
||'            7, x.Attribute7,'
||'            8, x.Attribute8,'
||'            9, x.Attribute9,'
||'            10, x.Attribute10,'
||'            11, x.Attribute11,'
||'            12, x.Attribute12,'
||'            13, x.Attribute13,'
||'            14, x.Attribute14,'
||'            15, x.Attribute15,Null)) ,'
||'    TO_NUMBER(DECODE( :v_msc_batching_window,'
||'            1, x.Attribute1,'
||'            2, x.Attribute2,'
||'            3, x.Attribute3,'
||'            4, x.Attribute4,'
||'            5, x.Attribute5,'
||'            6, x.Attribute6,'
||'            7, x.Attribute7,'
||'            8, x.Attribute8,'
||'            9, x.Attribute9,'
||'            10, x.Attribute10,'
||'            11, x.Attribute11,'
||'            12, x.Attribute12,'
||'            13, x.Attribute13,'
||'            14, x.Attribute14,'
||'            15, x.Attribute15,Null)) ,'
||'    TO_NUMBER(DECODE( :v_msc_min_capacity,'
||'            1, x.Attribute1,'
||'            2, x.Attribute2,'
||'            3, x.Attribute3,'
||'            4, x.Attribute4,'
||'            5, x.Attribute5,'
||'            6, x.Attribute6,'
||'            7, x.Attribute7,'
||'            8, x.Attribute8,'
||'            9, x.Attribute9,'
||'            10, x.Attribute10,'
||'            11, x.Attribute11,'
||'            12, x.Attribute12,'
||'            13, x.Attribute13,'
||'            14, x.Attribute14,'
||'            15, x.Attribute15,Null)) ,'
||'    TO_NUMBER(DECODE( :v_msc_max_capacity,'
||'            1, x.Attribute1,'
||'            2, x.Attribute2,'
||'            3, x.Attribute3,'
||'            4, x.Attribute4,'
||'            5, x.Attribute5,'
||'            6, x.Attribute6,'
||'            7, x.Attribute7,'
||'            8, x.Attribute8,'
||'            9, x.Attribute9,'
||'            10, x.Attribute10,'
||'            11, x.Attribute11,'
||'            12, x.Attribute12,'
||'            13, x.Attribute13,'
||'            14, x.Attribute14,'
||'            15, x.Attribute15,Null)) ,'
||'    DECODE( :v_msc_unit_of_measure,'
||'            1, x.Attribute1,'
||'            2, x.Attribute2,'
||'            3, x.Attribute3,'
||'            4, x.Attribute4,'
||'            5, x.Attribute5,'
||'            6, x.Attribute6,'
||'            7, x.Attribute7,'
||'            8, x.Attribute8,'
||'            9, x.Attribute9,'
||'            10, x.Attribute10,'
||'            11, x.Attribute11,'
||'            12, x.Attribute12,'
||'            13, x.Attribute13,'
||'            14, x.Attribute14,'
||'            15, x.Attribute15,Null) ,'
||'    x.RESOURCE_COST,'
||'    TO_NUMBER(DECODE( :v_mso_res_penalty,'
||'            1, x.Attribute1,'
||'            2, x.Attribute2,'
||'            3, x.Attribute3,'
||'            4, x.Attribute4,'
||'            5, x.Attribute5,'
||'            6, x.Attribute6,'
||'            7, x.Attribute7,'
||'            8, x.Attribute8,'
||'            9, x.Attribute9,'
||'            10, x.Attribute10,'
||'            11, x.Attribute11,'
||'            12, x.Attribute12,'
||'            13, x.Attribute13,'
||'            14, x.Attribute14,'
||'            15, x.Attribute15)),'
||'    x.DEPT_OVERHEAD_COST,'
||'    2,'
||'  :v_refresh_id,'
||   v_temp_atp_rule_sql
||'    :v_instance_id'
||'  FROM MRP_AP_DEPARTMENT_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

Line: 1550

' insert into MSC_ST_DEPARTMENT_RESOURCES'
||' (  ORGANIZATION_ID,'
||'    RESOURCE_ID,'
||'    DEPARTMENT_ID,'
||'    DEPARTMENT_CODE,'
||'    LINE_FLAG,'
||'    MAX_RATE,'
||'    MIN_RATE,'
||'    START_TIME,'
||'    STOP_TIME,'
||'    DEPARTMENT_DESCRIPTION,'
||'    AGGREGATED_RESOURCE_FLAG,'
||'    OVER_UTILIZED_PERCENT,'
||'    UNDER_UTILIZED_PERCENT,'
||'    RESOURCE_SHORTAGE_TYPE,'
||'    RESOURCE_EXCESS_TYPE,'
||'    PLANNING_EXCEPTION_SET,'
||'    USER_TIME_FENCE,'
||'    AVAILABLE_24_HOURS_FLAG,'
||'    CAPACITY_UNITS,'
||'    DISABLE_DATE,'
||'    DELETED_FLAG,'
||'    REFRESH_ID,'
||'    ATP_RULE_ID,'
||'    SETUP_TIME_PERCENT,'
||'    UTILIZATION_CHANGE_PERCENT,'
||'    SETUP_TIME_TYPE,'
||'    UTILIZATION_CHANGE_TYPE,'
||'    SR_INSTANCE_ID)'
||'  select'
||'    x.ORGANIZATION_ID,'
||'    -1,'
||'    x.DEPARTMENT_ID,'
||'    x.DEPARTMENT_CODE,'
||'    x.LINE_FLAG,'
||'    x.MAX_RATE,'
||'    x.MIN_RATE,'
||'    x.START_TIME,'
||'    x.STOP_TIME,'
||'    x.DEPARTMENT_DESCRIPTION,'
||'    2,'
||'    x.OVER_UTILIZED_PERCENT,'
||'    x.UNDER_UTILIZED_PERCENT,'
||'    x.RESOURCE_SHORTAGE_TYPE,'
||'    x.RESOURCE_EXCESS_TYPE,'
||'    x.PLANNING_EXCEPTION_SET,'
||'    x.USER_TIME_FENCE,'
||'    x.AVAILABLE_24_HOURS_FLAG,'
||'    x.CAPACITY_UNITS,'
||'    x.LINE_DISABLE_DATE- :v_dgmt,'
||'    2,'
||'  :v_refresh_id,'
||   v_temp_atp_rule_sql1
||'    :v_instance_id'
||'  from MRP_AP_LINE_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
|| v_union_sql;

Line: 1628

'insert into MSC_ST_SIMULATION_SETS'
||'   ( ORGANIZATION_ID,'
||'     SIMULATION_SET,'
||'     DESCRIPTION,'
||'     USE_IN_WIP_FLAG,'
||'     DELETED_FLAG,'
||'   REFRESH_ID,'
||'     SR_INSTANCE_ID)'
||'  select '
||'     x.ORGANIZATION_ID,'
||'     x.SIMULATION_SET,'
||'     x.DESCRIPTION,'
||'     x.USE_IN_WIP_FLAG,'
||'     2,'
||'     :v_refresh_id,'
||'     :v_instance_id'
||'  from MRP_AP_SIMULATION_SETS_V'||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

Line: 1657

'insert into MSC_ST_RESOURCE_GROUPS'
||'   ( GROUP_CODE,'
||'     MEANING,'
||'     DESCRIPTION,'
||'     FROM_DATE,'
||'     TO_DATE,'
||'     ENABLED_FLAG,'
||'     DELETED_FLAG,'
||'     REFRESH_ID,'
||'     SR_INSTANCE_ID)'
||'  select '
||'     x.GROUP_CODE,'
||'     x.MEANING,'
||'     x.DESCRIPTION,'
||'     x.FROM_DATE,'
||'     x.TO_DATE,'
||'     DECODE( x.ENABLED_FLAG, ''Y'', 1 , 2),'
||'     2,'
||'     :v_refresh_id,'
||'     :v_instance_id'
||'  from MRP_AP_RESOURCE_GROUPS_V'||MSC_CL_PULL.v_dblink||' x';

Line: 1718

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

Line: 1755

'insert into MSC_ST_RESOURCE_REQUIREMENTS'
||'   ( WIP_ENTITY_ID,'
||'     OPERATION_SEQ_NUM,'
||'     ORIG_RESOURCE_SEQ_NUM,'
||'     DELETED_FLAG,'
||'     REFRESH_ID,'
||'     SR_INSTANCE_ID)'
||'  select'
||'     x.WIP_ENTITY_ID,'
||      lv_op_seq_num
||      v_temp_sql1
||'     1,'
||'     :v_refresh_id,'
||'     :v_instance_id'
||'  from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
||' WHERE x.RN> :v_lrn '
||'   AND DECODE( x.operation_seq_num,'
||'               NULL, 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_MPS_NET_QTY_FLAG),'
||'               1)= 1'
|| v_temp_sql;

Line: 1794

'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_DJOB_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: 1915

||'  select /*+ first_rows  leading(x.wo) index(x.wo WIP_WOPRS_SN_N1) index(x.wor wip_wopr_ress_sn_n2) use_nl(x.wo x.wor x.wor1) */ '
||'     x.DEPARTMENT_ID,'
||'     x.RESOURCE_ID,'
||'     x.ORGANIZATION_ID,'
||'     x.INVENTORY_ITEM_ID,'
||'     x.WIP_ENTITY_ID,'
||'     x.WIP_ENTITY_ID,'
||'     x.WIP_JOB_TYPE,'
||'     x.OPERATION_SEQUENCE_ID,'
||'     x.RESOURCE_SEQ_NUM,'
||'     x.FIRST_UNIT_START_DATE- :v_dgmt,'
||      v_res_hrs_sql
||'     x.HOURS_EXPENDED,'
||'    x.DEMAND_CLASS,'
||'     x.BASIS_TYPE,'
||'     x.RESOURCE_UNITS,'
||'     x.COMPLETION_DATE- :v_dgmt,'
||'     x.WIP_JOB_TYPE,'
||'     x.SCHEDULED_COMPLETION_DATE- :v_dgmt,'
||'     x.SCHEDULED_QUANTITY,'
||'     2,'
||     v_temp_eam_sql
||     v_temp_sql
||'  :v_refresh_id,'
||      v_temp_parent_seq
||'     x.OPERATION_HOURS_REQUIRED,'
||      v_touch_time
||      v_temp_sql1
||'     :v_instance_id'
||'  from '||MSC_CL_PULL.v_view_name||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 nvl(x.uom_code,:v_hour_uom) = :v_hour_uom'
||   v_res_hrs_left
||   lv_cond_sql
||'  AND ( x.RN2> :v_lrn )'
||' UNION '
||'  select /*+ first_rows  leading(x.wo) index(x.wo WIP_WOPRS_SN_N1) index(x.wor wip_wopr_ress_sn_n2) use_nl(x.wo x.wor x.wor1) */ '
||'     x.DEPARTMENT_ID,'
||'     x.RESOURCE_ID,'
||'     x.ORGANIZATION_ID,'
||'     x.INVENTORY_ITEM_ID,'
||'     x.WIP_ENTITY_ID,'
||'     x.WIP_ENTITY_ID,'
||'     x.WIP_JOB_TYPE,'
||'     x.OPERATION_SEQUENCE_ID,'
||'     x.RESOURCE_SEQ_NUM,'
||'     x.FIRST_UNIT_START_DATE- :v_dgmt,'
||      v_res_hrs_sql
||'     x.HOURS_EXPENDED,'
||'    x.DEMAND_CLASS,'
||'     x.BASIS_TYPE,'
||'     x.RESOURCE_UNITS,'
||'     x.COMPLETION_DATE- :v_dgmt,'
||'     x.WIP_JOB_TYPE,'
||'     x.SCHEDULED_COMPLETION_DATE- :v_dgmt,'
||'     x.SCHEDULED_QUANTITY,'
||'     2,'
||     v_temp_eam_sql
||     v_temp_sql
||'  :v_refresh_id,'
||      v_temp_parent_seq
||'     x.OPERATION_HOURS_REQUIRED,'
||      v_touch_time
||      v_temp_sql1
||'     :v_instance_id'
||'  from '||MSC_CL_PULL.v_view_name||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 nvl(x.uom_code,:v_hour_uom) = :v_hour_uom'
||   v_res_hrs_left
||   lv_cond_sql
||'  AND ( x.RN3> :v_lrn )';

Line: 2008

'insert into MSC_ST_RESOURCE_REQUIREMENTS'
||'   ( DEPARTMENT_ID,'
||'     RESOURCE_ID,'
||'     ORGANIZATION_ID,'
||'     INVENTORY_ITEM_ID,'
||'     SUPPLY_ID,'
||'     WIP_ENTITY_ID,'
||'     SUPPLY_TYPE,'
||'     OPERATION_SEQUENCE_ID,'
||'     RESOURCE_SEQ_NUM,'
||'     START_DATE,'
||'     OPERATION_HOURS_REQUIRED,'
||'     HOURS_EXPENDED,'
||'     DEMAND_CLASS,'
||'     BASIS_TYPE,'
||'     ASSIGNED_UNITS,'
||'     END_DATE,'
||'     WIP_JOB_TYPE,'
||'     SCHEDULED_COMPLETION_DATE,'
||'     SCHEDULED_QUANTITY,'
||'     DELETED_FLAG,'
||'     SHUTDOWN_TYPE,'
||'     MINIMUM_TRANSFER_QUANTITY,'
||'     FIRM_FLAG,'
||'     SCHEDULE_FLAG,'
||'     QUANTITY_IN_QUEUE,'
||'     QUANTITY_RUNNING,'
||'     QUANTITY_WAITING_TO_MOVE,'
||'     QUANTITY_COMPLETED,'
||'     YIELD,'
||'     USAGE_RATE,'
||'     OPERATION_SEQ_NUM,'
||'     STD_OP_CODE,'
||'     ACTIVITY_GROUP_ID,'
||'     ALTERNATE_NUMBER,'
||'     PRINCIPAL_FLAG,'
||'     ACTUAL_START_DATE,'    /* Discrete Mfg Enahancements Bug 4479276 */
||'     ROUTING_SEQUENCE_ID,'
||'     OPERATION_NAME,'
||'   REFRESH_ID,'
||'     PARENT_SEQ_NUM,'
||'     SETUP_ID,'
||'     ORIG_RESOURCE_SEQ_NUM,'
||'     GROUP_SEQUENCE_ID,'
||'     GROUP_SEQUENCE_NUMBER,'
||'     BATCH_NUMBER,'
||'     MAXIMUM_ASSIGNED_UNITS,'
||'     UNADJUSTED_RESOURCE_HOURS,'
||'     TOUCH_TIME,'
||'     Operation_Code,'
||'     ACTUAL_END_DATE,'
||'     SR_INSTANCE_ID)'
||'  select '|| lv_hint
||'     x.DEPARTMENT_ID,'
||'     x.RESOURCE_ID,'
||'     x.ORGANIZATION_ID,'
||'     x.INVENTORY_ITEM_ID,'
||'     x.WIP_ENTITY_ID,'
||'     x.WIP_ENTITY_ID,'
||'     x.WIP_JOB_TYPE,'
||'     x.OPERATION_SEQUENCE_ID,'
||'     x.RESOURCE_SEQ_NUM,'
||'     x.FIRST_UNIT_START_DATE- :v_dgmt,'
||      v_res_hrs_sql
||'     x.HOURS_EXPENDED,'
||'    x.DEMAND_CLASS,'
||'     x.BASIS_TYPE,'
||'     x.RESOURCE_UNITS,'
||'     x.COMPLETION_DATE- :v_dgmt,'
||'     x.WIP_JOB_TYPE,'
||'     x.SCHEDULED_COMPLETION_DATE- :v_dgmt,'
||'     x.SCHEDULED_QUANTITY,'
||'     2,'
||     v_temp_eam_sql
||     v_temp_sql
||'  :v_refresh_id,'
||      v_temp_parent_seq
||'     x.OPERATION_HOURS_REQUIRED,'
||      v_touch_time
||      v_temp_sql1
||'     :v_instance_id'
||'  from '||MSC_CL_PULL.v_view_name||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 nvl(x.uom_code,:v_hour_uom) = :v_hour_uom'
|| v_res_hrs_left
|| lv_cond_sql
|| v_union_sql ;

Line: 2141

'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,'
||'    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,'
||'    ''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,'
||'    2,'
||'    :v_refresh_id'
||'    FROM MRP_AP_DJOB_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: 2224

     ' insert into MSC_ST_DEPT_RES_INSTANCES'
     ||' ( RESOURCE_ID,'
     ||'   DEPARTMENT_ID,'
     ||'   RES_INSTANCE_ID,'
     ||'   SERIAL_NUMBER,'
     ||'   EQUIPMENT_ITEM_ID,'
     ||'   DEPARTMENT_CODE,'
     ||'   ORGANIZATION_ID,'
     ||'   RESOURCE_CODE,'
     ||'   LAST_KNOWN_SETUP,'
     ||'   DELETED_FLAG,'
     ||'   REFRESH_ID,'
     ||'   SR_INSTANCE_ID)'
     ||'  select'
     ||'    x.RESOURCE_ID,'
     ||'    x.DEPARTMENT_ID,'
     ||'    x.RES_INSTANCE_ID,'
     ||'    x.SERIAL_NUMBER,'
     ||'   x.EQUIPMENT_ITEM_ID,'
     ||'   x.DEPARTMENT_CODE,'
     ||'   x.ORGANIZATION_ID,'
     ||'   x.RESOURCE_CODE,'
     ||'   x.LAST_KNOWN_SETUP,'
     ||'    2,'
     ||'  :v_refresh_id,'
     ||'  :v_instance_id'
     ||'  from MRP_AP_DEPT_RES_INSTANCES_V'||MSC_CL_PULL.v_dblink||' x'
     ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

Line: 2273

      'insert into MSC_ST_RESOURCE_INSTANCE_REQS'
      ||'   ( WIP_ENTITY_ID,'
      ||'     OPERATION_SEQ_NUM,'
      ||'     RESOURCE_SEQ_NUM,'
      ||'     RES_INSTANCE_ID,'
      ||'     SERIAL_NUMBER,'
      ||'     DELETED_FLAG,'
      ||'     REFRESH_ID,'
      ||'     SR_INSTANCE_ID)'
      ||'  select'
      ||'     x.WIP_ENTITY_ID,'
      ||'     x.OPERATION_SEQ_NUM,'
      ||'     x.RESOURCE_SEQ_NUM,'
      ||'     x.RES_INSTANCE_ID,'
      ||'     x.SERIAL_NUMBER,'
      ||'     1,'
      ||'     :v_refresh_id,'
      ||'     :v_instance_id'
      ||'  from MRP_AD_RES_INSTANCE_REQS_V'||MSC_CL_PULL.v_dblink||' x'
      ||' WHERE x.RN > :v_lrn '
      || v_temp_sql;

Line: 2309

      'insert into MSC_ST_JOB_OP_RES_INSTANCES'
      ||'   ( WIP_ENTITY_ID,'
      ||'     OPERATION_SEQ_NUM,'
      ||'     RESOURCE_SEQ_NUM,'
      ||'     RES_INSTANCE_ID,'
      ||'     SERIAL_NUMBER,'
      ||'     DELETED_FLAG,'
      ||'     REFRESH_ID,'
      ||'     SR_INSTANCE_ID)'
      ||'  select'
      ||'     x.WIP_ENTITY_ID,'
      ||'     x.OPERATION_SEQ_NUM,'
      ||'     x.RESOURCE_SEQ_NUM,'
      ||'     x.RES_INSTANCE_ID,'
      ||'     x.SERIAL_NUMBER,'
      ||'     1,'
      ||'     :v_refresh_id,'
      ||'     :v_instance_id'
      ||'  from MRP_AD_LJ_OPR_RES_INSTS_V'||MSC_CL_PULL.v_dblink||' x'
      ||' WHERE x.RN > :v_lrn '
      || v_temp_sql;

Line: 2353

      ||'  select   '
      ||'     x.DEPARTMENT_ID,'
      ||'     x.RESOURCE_ID,'
      ||'     x.RES_INSTANCE_ID,'
      ||'     x.ORGANIZATION_ID,'
      --||'     x.OPERATION_SEQUENCE_ID,'
      ||'     x.OPERATION_SEQ_NUM,'
      ||'     x.RESOURCE_SEQ_NUM,'
      ||'     x.ORIG_RESOURCE_SEQ_NUM,'
      ||'     x.SERIAL_NUMBER,'
      ||'     x.EQUIPMENT_ITEM_ID,'
      ||'     x.WIP_ENTITY_ID,'
      ||'     x.WIP_ENTITY_ID,'
      ||'     x.START_DATE - :v_dgmt,'
      ||'     x.COMPLETION_DATE - :v_dgmt,'
      ||'     2,'
      ||'     :v_refresh_id,'
      ||'     :v_instance_id'
      ||'  from MRP_AP_RES_INSTANCE_REQS_V'  ||MSC_CL_PULL.v_dblink  ||' x'
      ||'  where x.ORGANIZATION_ID'  ||MSC_UTIL.v_in_org_str
      ||   lv_cond_sql
      ||'  AND ( x.RN2> :v_lrn )'
      ||' UNION '
      ||'  select   '
      ||'     x.DEPARTMENT_ID,'
      ||'     x.RESOURCE_ID,'
      ||'     x.RES_INSTANCE_ID,'
      ||'     x.ORGANIZATION_ID,'
      --||'     x.OPERATION_SEQUENCE_ID,'
      ||'     x.OPERATION_SEQ_NUM,'
      ||'     x.RESOURCE_SEQ_NUM,'
      ||'     x.ORIG_RESOURCE_SEQ_NUM,'
      ||'     x.SERIAL_NUMBER,'
      ||'     x.EQUIPMENT_ITEM_ID,'
      ||'     x.WIP_ENTITY_ID,'
      ||'     x.WIP_ENTITY_ID,'
      ||'     x.START_DATE - :v_dgmt,'
      ||'     x.COMPLETION_DATE- :v_dgmt,'
      ||'     2,'
      ||'     :v_refresh_id,'
      ||'     :v_instance_id'
      ||'  from MRP_AP_RES_INSTANCE_REQS_V'  ||MSC_CL_PULL.v_dblink  ||' x'
      ||'  where x.ORGANIZATION_ID'  ||MSC_UTIL.v_in_org_str
      ||   lv_cond_sql
      ||'  AND ( x.RN3> :v_lrn )'
      ||' UNION '
      ||'  select   '
      ||'     x.DEPARTMENT_ID,'
      ||'     x.RESOURCE_ID,'
      ||'     x.RES_INSTANCE_ID,'
      ||'     x.ORGANIZATION_ID,'
      --||'     x.OPERATION_SEQUENCE_ID,'
      ||'     x.OPERATION_SEQ_NUM,'
      ||'     x.RESOURCE_SEQ_NUM,'
      ||'     x.ORIG_RESOURCE_SEQ_NUM,'
      ||'     x.SERIAL_NUMBER,'
      ||'     x.EQUIPMENT_ITEM_ID,'
      ||'     x.WIP_ENTITY_ID,'
      ||'     x.WIP_ENTITY_ID,'
      ||'     x.START_DATE - :v_dgmt,'
      ||'     x.COMPLETION_DATE - :v_dgmt,'
      ||'     2,'
      ||'     :v_refresh_id,'
      ||'     :v_instance_id'
      ||'  from MRP_AP_RES_INSTANCE_REQS_V'  ||MSC_CL_PULL.v_dblink  ||' x'
      ||'  where x.ORGANIZATION_ID'  ||MSC_UTIL.v_in_org_str
      ||   lv_cond_sql
      ||'  AND ( x.RN4> :v_lrn )';

Line: 2429

      'insert into MSC_ST_RESOURCE_INSTANCE_REQS'
    ||'   ( DEPARTMENT_ID,'
    ||'     RESOURCE_ID,'
    ||'     RES_INSTANCE_ID,'
    ||'     ORGANIZATION_ID,'
    --||'     OPERATION_SEQUENCE_ID,'
    ||'     OPERATION_SEQ_NUM,'
    ||'     RESOURCE_SEQ_NUM,'
    ||'     ORIG_RESOURCE_SEQ_NUM,'
    ||'     SERIAL_NUMBER,'
    ||'     EQUIPMENT_ITEM_ID,'
    ||'     SUPPLY_ID,'
    ||'     WIP_ENTITY_ID,'
    ||'     START_DATE,'
    ||'     END_DATE,'
    ||'     DELETED_FLAG,'
    ||'     REFRESH_ID,'
    ||'     SR_INSTANCE_ID)'
    ||'  select '		/*	|| lv_hint */
    ||'     x.DEPARTMENT_ID,'
    ||'     x.RESOURCE_ID,'
    ||'     x.RES_INSTANCE_ID,'
    ||'     x.ORGANIZATION_ID,'
    --||'     x.OPERATION_SEQUENCE_ID,'
    ||'     x.OPERATION_SEQ_NUM,'
    ||'     x.RESOURCE_SEQ_NUM,'
    ||'     x.ORIG_RESOURCE_SEQ_NUM,'
    ||'     x.SERIAL_NUMBER,'
    ||'     x.EQUIPMENT_ITEM_ID,'
    ||'     x.WIP_ENTITY_ID,'
    ||'     x.WIP_ENTITY_ID,'
    ||'     x.START_DATE - :v_dgmt,'
    ||'     x.COMPLETION_DATE - :v_dgmt,'
    ||'     2,'
    ||'     :v_refresh_id,'
    ||'     :v_instance_id'
    ||'  from MRP_AP_RES_INSTANCE_REQS_V'||MSC_CL_PULL.v_dblink||' x'
    ||'  where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
    || lv_cond_sql
    || v_union_sql ;

Line: 2494

    'insert into MSC_ST_JOB_OP_RES_INSTANCES'
    ||'   (WIP_ENTITY_ID,'
    ||'    SR_INSTANCE_ID,'
    ||'    ORGANIZATION_ID,'
    ||'    OPERATION_SEQ_NUM,'
    ||'    RESOURCE_SEQ_NUM,'
    ||'    RESOURCE_ID,'
    ||'    RES_INSTANCE_ID,'
    ||'    DEPARTMENT_ID,'
    ||'    SERIAL_NUMBER,'
    ||'    EQUIPMENT_ITEM_ID,'
    ||'    START_DATE,'
    ||'    COMPLETION_DATE,'
    ||'    BATCH_NUMBER,'
    ||'    DELETED_FLAG,'
    ||'    REFRESH_ID )'
    ||'    select '
    ||'    x.WIP_ENTITY_ID,'
    ||'    :v_instance_id,'
    ||'    x.ORGANIZATION_ID,'
    ||'    x.OPERATION_SEQ_NUM,'
    ||'    x.RESOURCE_SEQ_NUM,'
    ||'    x.RESOURCE_ID,'
    ||'    x.RES_INSTANCE_ID,'
    ||'    x.DEPARTMENT_ID,'
    ||'    x.SERIAL_NUMBER,'
    ||'    x.EQUIPMENT_ITEM_ID,'
    ||'    x.START_DATE - :v_dgmt,'
    ||'    x.COMPLETION_DATE - :v_dgmt,'
    ||'    x.BATCH_NUMBER,'
    ||'    2,'
    ||'    :v_refresh_id'
    ||'    FROM MRP_AP_JOB_RES_INSTANCES_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: 2585

v_wsm_split_table_qry := 'select count(*)  from all_tables'||MSC_CL_PULL.v_dblink||
                         ' where owner=:v_wsm_schema and table_name = ''WSM_COPRODUCT_SPLIT_PERC''';

Line: 2595

   v_query_str := 'Select bill_sequence_id*2,co_product_id,split,' ||
                  'effectivity_date, disable_date, decode(nvl(primary_flag,''N''),''N'',2,1) primary_flag' ||
                  'from wsm_co_products'||MSC_CL_PULL.v_dblink||  -- Edited for BUG 14133049 (FP of SUN BUG 13530488)
                  ' where bill_sequence_id <>:v_bill_seq_id and  bill_sequence_id is not null
                   and co_product_group_id = :v_co_prd_grp_id
                   and perc.effectivity_date = :v_effectivity_date_var
                   and split > 0';

Line: 2603

   v_query_str1 := 'select wsc.co_product_group_id,
       wsc.bill_Sequence_id*2,
       co_product_id,
       bom.common_bill_Sequence_id,
       wsc.usage_rate,
       wsc.split,
       perc.effectivity_date,    -- Added for BUG 14133049/13530488
       decode(nvl(wsc.primary_flag,''N''),''N'',2,1) primary_flag,
       bom.rowid
       from wsm_Co_products'||MSC_CL_PULL.v_dblink||' wsc,
            msc_st_boms bom
       where wsc.bill_sequence_id is not null
       and   wsc.split > 0    -- Added this for bug:2208074
       and   wsc.bill_Sequence_id*2 = bom.bill_Sequence_id';

Line: 2621

   v_query_str := 'Select wsc.bill_sequence_id*2,
                   wsc.co_product_id,
                   perc.split,
                   perc.effectivity_date,     -- Added for BUG 14133049/13530488
                   perc.disable_date,          -- Added for BUG 14133049/13530488
                   decode(nvl(wsc.primary_flag,''N''),''N'',2,1) primary_flag
                   from wsm_co_products'||MSC_CL_PULL.v_dblink|| ' wsc,
                   wsm_coproduct_split_perc'||MSC_CL_PULL.v_dblink||' perc
                   where wsc.bill_sequence_id <>:v_bill_seq_id
                   and   wsc.bill_sequence_id is not null
                   and   wsc.co_product_group_id = :v_co_prd_grp_id
                   and   perc.co_product_group_id = wsc.co_product_group_id
                   and   perc.co_product_id = wsc.co_product_id
                   and   sysdate < nvl(perc.disable_date,sysdate + 1)
                   and   perc.effectivity_date = :v_effectivity_date_var   -- Added for BUG 14133049/13530488
                   and   perc.split > 0';

Line: 2638

   v_query_str1 := 'select wsc.co_product_group_id,
       wsc.bill_Sequence_id*2,
       wsc.co_product_id,
       bom.common_bill_Sequence_id,
       wsc.usage_rate,
       perc.split,
       perc.effectivity_date, -- Added for BUG 14133049/13530488
       decode(nvl(wsc.primary_flag,''N''),''N'',2,1) primary_flag,
       bom.rowid
       from wsm_Co_products'||MSC_CL_PULL.v_dblink||' wsc,
       wsm_coproduct_split_perc'||MSC_CL_PULL.v_dblink||' perc,
       msc_st_boms bom
       where wsc.bill_sequence_id is not null
       and   wsc.bill_Sequence_id*2 = bom.bill_Sequence_id
       and   perc.co_product_group_id = wsc.co_product_group_id
       and   perc.co_product_id = wsc.co_product_id
       and   sysdate < nvl(perc.disable_date,sysdate + 1)
       and   perc.split>0';

Line: 2677

    'update MSC_ST_BOM_COMPONENTS x
    set x.primary_flag = 2
    WHERE x.bill_Sequence_id='||l_BILL_SEQuence_ID ||
    ' and x.primary_flag is null
      and nvl(x.component_type,0) != 10
      and x.usage_quantity > 0
      and x.inventory_item_id in
     (select wsm.component_id from wsm_co_products' ||MSC_CL_PULL.v_dblink||' wsm
                              where wsm.bill_sequence_id ='|| l_bill_sequence_id/2||')';

Line: 2690

    insert into MSC_ST_BOM_COMPONENTS
  ( COMPONENT_SEQUENCE_ID,
    INVENTORY_ITEM_ID,
    BILL_SEQUENCE_ID,
    OPERATION_SEQ_NUM,
    COMPONENT_TYPE,
    USAGE_QUANTITY,
    COMPONENT_YIELD_FACTOR,
    EFFECTIVITY_DATE,
    DISABLE_DATE,
    OPERATION_OFFSET_PERCENT,
    OPTIONAL_COMPONENT,
    WIP_SUPPLY_TYPE,
    PLANNING_FACTOR,
    REVISED_ITEM_SEQUENCE_ID,
    ATP_FLAG,
    STATUS_TYPE,
    USE_UP_CODE,
    CHANGE_NOTICE,
    ORGANIZATION_ID,
    USING_ASSEMBLY_ID,
    FROM_UNIT_NUMBER,
    TO_UNIT_NUMBER,
    DRIVING_ITEM_ID,
    DELETED_FLAG,
    REFRESH_ID,
    SR_INSTANCE_ID,
    PRIMARY_FLAG,
    ROUNDING_DIRECTION)
    select
    BOM_INVENTORY_COMPONENTS_S.NEXTVAL,
    v_co_product_id,
    l_BILL_SEQuence_ID,
    x.OPERATION_SEQ_NUM,
    10,
    -(v_split/100),
    x.COMPONENT_YIELD_FACTOR,
    v_effectivity_date1,    -- Added for BUG 14133049/13530488
    v_disable_date1,
    x.OPERATION_OFFSET_PERCENT,
    x.OPTIONAL_COMPONENT,
    decode(x.WIP_SUPPLY_TYPE,6,1,x.WIP_SUPPLY_TYPE), -- Bug 14133049 -FP of SUN bug 13459310
    x.PLANNING_FACTOR,
    x.REVISED_ITEM_SEQUENCE_ID,
    x.ATP_FLAG,
    x.STATUS_TYPE,
    x.USE_UP_CODE,
    x.CHANGE_NOTICE,
    x.ORGANIZATION_ID,
    v_assembly_id,
    x.FROM_UNIT_NUMBER,
    x.TO_UNIT_NUMBER,
    x.DRIVING_ITEM_ID,
    2,
    refresh_id,
    sr_instance_id,
    v_primary_flag,
    3
    from MSC_ST_BOM_COMPONENTS x
    WHERE x.bill_Sequence_id = l_BILL_SEQuence_ID
    and   x.sr_instance_id = MSC_CL_PULL.v_instance_id
    and rownum = 1;

Line: 2755

    update msc_st_boms
    set assembly_quantity = (l_split/100)
    where rowid = l_rowid;

Line: 2779

	' insert into MSC_ST_RESOURCE_SETUPS'
	||' ( RESOURCE_ID,'
	||'   ORGANIZATION_ID,'
	--||'   DEPARTMENT_ID,'
	||'   SETUP_ID,'
	||'   SETUP_CODE,'
	||'   SETUP_DESCRIPTION,'
 	||'   DELETED_FLAG,'
 	||'   REFRESH_ID,'
 	||'   SR_INSTANCE_ID)'
 	||'  select'
 	||'    x.RESOURCE_ID,'
 	||'    x.ORGANIZATION_ID,'
 	--||'    x.DEPARTMENT_ID,'
 	||'    x.SETUP_ID,'
 	||'    x.SETUP_CODE,'
 	||'    x.SETUP_DESCRIPTION,'
 	||'    2,'
 	||'  :v_refresh_id,'
 	||'  :v_instance_id'
 	||'  from MRP_AP_RESOURCE_SETUPS_V'||MSC_CL_PULL.v_dblink||' x'
 	||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

Line: 2813

        ' insert into MSC_ST_SETUP_TRANSITIONS'
        ||' ( RESOURCE_ID,'
        ||'   ORGANIZATION_ID,'
        ||'   FROM_SETUP_ID,'
        ||'   TO_SETUP_ID,'
        ||'   STANDARD_OPERATION_ID,'
        ||'   TRANSITION_TIME,'
        ||'   TRANSITION_UOM,'
        ||'   TRANSITION_PENALTY,'
        ||'   DELETED_FLAG,'
        ||'   REFRESH_ID,'
        ||'   SR_INSTANCE_ID)'
        ||'  select'
        ||'    x.RESOURCE_ID,'
        ||'    x.ORGANIZATION_ID,'
        ||'    x.FROM_SETUP_ID,'
        ||'    x.TO_SETUP_ID,'
        ||'    x.STANDARD_OPERATION_ID,'
        ||'    x.TRANSITION_TIME,'
        ||'    x.TRANSITION_UOM,'
        ||'    x.TRANSITION_PENALTY,'
        ||'    2,'
        ||'  :v_refresh_id,'
        ||'  :v_instance_id'
        ||'  from MRP_AP_SETUP_TRANSITIONS_V'||MSC_CL_PULL.v_dblink||' x'
        ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

Line: 2851

        ' insert into MSC_ST_STD_OP_RESOURCES'
        ||' ( STANDARD_OPERATION_ID,'
        ||'   RESOURCE_ID,'
        ||'   ORGANIZATION_ID,'
        ||'   DEPARTMENT_ID,'
        ||'   OPERATION_CODE,'
        ||'   RESOURCE_SEQ_NUM,'
        ||'   RESOURCE_USAGE,'
        ||'   BASIS_TYPE,'
        ||'   RESOURCE_UNITS,'
        ||'   SUBSTITUTE_GROUP_NUM,'
        ||'   UOM_CODE,'
        ||'   SCHEDULE_FLAG,'
        ||'   DELETED_FLAG,'
        ||'   REFRESH_ID,'
        ||'   SR_INSTANCE_ID)'
        ||'  select'
        ||'    x.STANDARD_OPERATION_ID,'
        ||'    x.RESOURCE_ID,'
        ||'    x.ORGANIZATION_ID,'
        ||'    x.DEPARTMENT_ID,'
        ||'    x.OPERATION_CODE,'
        ||'    x.RESOURCE_SEQ_NUM,'
        ||'    x.RESOURCE_USAGE,'
        ||'    x.BASIS_TYPE,'
        ||'    x.RESOURCE_UNITS,'
        ||'    x.SUBSTITUTE_GROUP_NUM,'
        ||'    x.UOM_CODE,'
        ||'    x.SCHEDULE_FLAG,'
        ||'    2,'
        ||'  :v_refresh_id,'
        ||'  :v_instance_id'
        ||'  from MRP_AP_STD_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
        ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;