[Home] [Help]
1459:
1460:
1461: /*---------------------------------------------------------------+
1462: Second:
1463: All the standard component items associated
1464: with the new configuration items will be loaded into the
1465: BOM_INVENTORY_COMPS_INTERFACE table.
1466: +----------------------------------------------------------------*/
1467:
2583: and ( ic1.disable_date is null or
2584: (ic1.disable_date is not null and ic1.disable_date >= sysdate )) /* New Approach for Effectivity Dates */
2585: and si2.inventory_item_id = ic1.component_item_id
2586: and si2.organization_id = b1.organization_id
2587: and si2.bom_item_type = 4 /* standard */
2588: and os1.option_dependent_flag = 1
2589: and ((os1.operation_seq_num = ic1.operation_seq_num)
2590: or (os1.operation_seq_num in
2591: (select bco.operation_seq_num
2724: last_updated_by,
2725: creation_date,
2726: created_by,
2727: last_update_login,
2728: standard_operation_id,
2729: department_id ,
2730: operation_lead_time_percent,
2731: minimum_transfer_quantity,
2732: count_point_type ,
2781: gUserId, /* last updated by */
2782: sysdate, /* creation date */
2783: gUserId, /* created by */
2784: gLoginId, /* last update login */
2785: os1.standard_operation_id,
2786: os1.department_id,
2787: os1.operation_lead_time_percent,
2788: os1.minimum_transfer_quantity,
2789: os1.count_point_type,
2999: and ( ic1.disable_date is null or
3000: (ic1.disable_date is not null and ic1.disable_date >= sysdate )) /* New Approach for Effectivity Dates */
3001: and si2.inventory_item_id = ic1.component_item_id
3002: and si2.organization_id = b1.organization_id
3003: and si2.bom_item_type = 4 /* standard */
3004: and or1.assembly_item_id = b1.assembly_item_id
3005: and or1.organization_id = b1.organization_id
3006: and or1.alternate_routing_designator is null
3007: and nvl(or1.cfm_routing_flag,2) = lCfmRtgFlag
3139: last_updated_by,
3140: creation_date,
3141: created_by,
3142: last_update_login,
3143: standard_operation_id,
3144: department_id ,
3145: operation_lead_time_percent,
3146: minimum_transfer_quantity,
3147: count_point_type ,
3196: gUserId, /* last updated by */
3197: sysdate, /* creation date */
3198: gUserID, /* created by */
3199: gLoginId, /* last update login */
3200: os1.standard_operation_id,
3201: os1.department_id,
3202: os1.operation_lead_time_percent,
3203: os1.minimum_transfer_quantity,
3204: os1.count_point_type,
5225: operation_sequence_id,
5226: resource_seq_num,
5227: resource_id ,
5228: activity_id,
5229: standard_rate_flag,
5230: assigned_units ,
5231: usage_rate_or_amount,
5232: usage_rate_or_amount_inverse,
5233: basis_type,
5268: osi.operation_sequence_id, /* operation sequence id */
5269: bor.resource_seq_num,
5270: bor.resource_id, /* resource id */
5271: bor.activity_id,
5272: bor.standard_rate_flag,
5273: bor.assigned_units,
5274: bor.usage_rate_or_amount,
5275: bor.usage_rate_or_amount_inverse,
5276: bor.basis_type,
5343: --scheduling_seq_num,
5344: schedule_seq_num,
5345: replacement_group_num,
5346: activity_id,
5347: standard_rate_flag,
5348: assigned_units,
5349: usage_rate_or_amount,
5350: usage_rate_or_amount_inverse,
5351: basis_type,
5388: --bsor.scheduling_seq_num,
5389: bsor.schedule_seq_num,
5390: bsor.replacement_group_num,
5391: bsor.activity_id,
5392: bsor.standard_rate_flag,
5393: bsor.assigned_units,
5394: bsor.usage_rate_or_amount,
5395: bsor.usage_rate_or_amount_inverse,
5396: bsor.basis_type,