[Home] [Help]
1518:
1519:
1520: /*---------------------------------------------------------------+
1521: Second:
1522: All the standard component items associated
1523: with the new configuration items will be loaded into the
1524: BOM_INVENTORY_COMPS_INTERFACE table.
1525: +----------------------------------------------------------------*/
1526:
2672: and ( ic1.disable_date is null or
2673: (ic1.disable_date is not null and ic1.disable_date >= sysdate )) /* New Approach for Effectivity Dates */
2674: and si2.inventory_item_id = ic1.component_item_id
2675: and si2.organization_id = b1.organization_id
2676: and si2.bom_item_type = 4 /* standard */
2677: and os1.option_dependent_flag = 1
2678: and ((os1.operation_seq_num = ic1.operation_seq_num)
2679: or (os1.operation_seq_num in
2680: (select bco.operation_seq_num
2813: last_updated_by,
2814: creation_date,
2815: created_by,
2816: last_update_login,
2817: standard_operation_id,
2818: department_id ,
2819: operation_lead_time_percent,
2820: minimum_transfer_quantity,
2821: count_point_type ,
2870: gUserId, /* last updated by */
2871: sysdate, /* creation date */
2872: gUserId, /* created by */
2873: gLoginId, /* last update login */
2874: os1.standard_operation_id,
2875: os1.department_id,
2876: os1.operation_lead_time_percent,
2877: os1.minimum_transfer_quantity,
2878: os1.count_point_type,
3088: and ( ic1.disable_date is null or
3089: (ic1.disable_date is not null and ic1.disable_date >= sysdate )) /* New Approach for Effectivity Dates */
3090: and si2.inventory_item_id = ic1.component_item_id
3091: and si2.organization_id = b1.organization_id
3092: and si2.bom_item_type = 4 /* standard */
3093: and or1.assembly_item_id = b1.assembly_item_id
3094: and or1.organization_id = b1.organization_id
3095: and or1.alternate_routing_designator is null
3096: and nvl(or1.cfm_routing_flag,2) = lCfmRtgFlag
3228: last_updated_by,
3229: creation_date,
3230: created_by,
3231: last_update_login,
3232: standard_operation_id,
3233: department_id ,
3234: operation_lead_time_percent,
3235: minimum_transfer_quantity,
3236: count_point_type ,
3285: gUserId, /* last updated by */
3286: sysdate, /* creation date */
3287: gUserID, /* created by */
3288: gLoginId, /* last update login */
3289: os1.standard_operation_id,
3290: os1.department_id,
3291: os1.operation_lead_time_percent,
3292: os1.minimum_transfer_quantity,
3293: os1.count_point_type,
5434: operation_sequence_id,
5435: resource_seq_num,
5436: resource_id ,
5437: activity_id,
5438: standard_rate_flag,
5439: assigned_units ,
5440: usage_rate_or_amount,
5441: usage_rate_or_amount_inverse,
5442: basis_type,
5477: osi.operation_sequence_id, /* operation sequence id */
5478: bor.resource_seq_num,
5479: bor.resource_id, /* resource id */
5480: bor.activity_id,
5481: bor.standard_rate_flag,
5482: bor.assigned_units,
5483: bor.usage_rate_or_amount,
5484: bor.usage_rate_or_amount_inverse,
5485: bor.basis_type,
5552: --scheduling_seq_num,
5553: schedule_seq_num,
5554: replacement_group_num,
5555: activity_id,
5556: standard_rate_flag,
5557: assigned_units,
5558: usage_rate_or_amount,
5559: usage_rate_or_amount_inverse,
5560: basis_type,
5597: --bsor.scheduling_seq_num,
5598: bsor.schedule_seq_num,
5599: bsor.replacement_group_num,
5600: bsor.activity_id,
5601: bsor.standard_rate_flag,
5602: bsor.assigned_units,
5603: bsor.usage_rate_or_amount,
5604: bsor.usage_rate_or_amount_inverse,
5605: bsor.basis_type,