[Home] [Help]
2174: be.line_id , -- 2897132
2175: nvl(bic.wip_supply_type, msi2.wip_supply_type), -- 3254039 , 3298244
2176: xGrpId
2177: from
2178: bom_calendar_dates cal,
2179: mtl_system_items msi, /* PARENT */
2180: mtl_system_items msi2, /* CHILD */
2181: bom_inventory_components bic,
2182: eng_revised_items eri,
2200: and cal.calendar_code = mp.calendar_code
2201: and cal.exception_set_id = mp.calendar_exception_set_id
2202: and cal.calendar_date =
2203: ( select c.calendar_date
2204: from bom_calendar_dates C
2205: where C.calendar_code = mp.calendar_code
2206: and c.exception_set_id = mp.calendar_exception_set_id
2207: and C.seq_num =
2208: (select c2.prior_seq_num -
2208: (select c2.prior_seq_num -
2209: ceil( nvl( v_msi_fixed_lead_time,0)+
2210: (be.extended_quantity *
2211: v_msi_variable_lead_time ))
2212: from bom_calendar_dates c2
2213: where c2.calendar_code = mp.calendar_code
2214: and c2.exception_set_id = mp.calendar_exception_set_id
2215: and c2.calendar_date = trunc(pReqDate)
2216: )
2581: be.line_id ,
2582: nvl(bic.wip_supply_type, msi2.wip_supply_type),
2583: xGrpId
2584: from
2585: bom_calendar_dates cal,
2586: mtl_system_items msi,
2587: mtl_system_items msi2,
2588: bom_inventory_components bic,
2589: eng_revised_items eri,
2607: and cal.calendar_code = mp.calendar_code
2608: and cal.exception_set_id = mp.calendar_exception_set_id
2609: and cal.calendar_date =
2610: ( select c.calendar_date
2611: from bom_calendar_dates C
2612: where C.calendar_code = mp.calendar_code
2613: and c.exception_set_id = mp.calendar_exception_set_id
2614: and C.seq_num =
2615: (select c2.prior_seq_num -
2615: (select c2.prior_seq_num -
2616: ceil( nvl( v_msi_fixed_lead_time,0)+
2617: (be.extended_quantity *
2618: v_msi_variable_lead_time ))
2619: from bom_calendar_dates c2
2620: where c2.calendar_code = mp.calendar_code
2621: and c2.exception_set_id = mp.calendar_exception_set_id
2622: and c2.calendar_date = trunc(pReqDate)
2623: )
3114: msi.bom_item_type,
3115: NULL,
3116: xGrpId
3117: from
3118: bom_calendar_dates cal,
3119: mtl_system_items msi, /* PARENT */
3120: mtl_system_items msi2, /* CHILD [BUG#1518894] */
3121: bom_inventory_components bic,
3122: eng_revised_items eri,
3140: and cal.calendar_code = mp.calendar_code
3141: and cal.exception_set_id = mp.calendar_exception_set_id
3142: and cal.calendar_date =
3143: ( select c.calendar_date
3144: from bom_calendar_dates C
3145: where C.calendar_code = mp.calendar_code
3146: and c.exception_set_id = mp.calendar_exception_set_id
3147: and C.seq_num =
3148: (select c2.prior_seq_num -
3148: (select c2.prior_seq_num -
3149: ceil(nvl(v_msi_fixed_lead_time,0)+
3150: (be.extended_quantity *
3151: nvl(v_msi_variable_lead_time,0)))
3152: from bom_calendar_dates c2
3153: where c2.calendar_code = mp.calendar_code
3154: and c2.exception_set_id = mp.calendar_exception_set_id
3155: and c2.calendar_date = trunc(pReqDate)
3156: )
3528: msi.bom_item_type,
3529: NULL,
3530: xGrpId
3531: from
3532: bom_calendar_dates cal,
3533: mtl_system_items msi,
3534: mtl_system_items msi2,
3535: bom_inventory_components bic,
3536: eng_revised_items eri,
3554: and cal.calendar_code = mp.calendar_code
3555: and cal.exception_set_id = mp.calendar_exception_set_id
3556: and cal.calendar_date =
3557: ( select c.calendar_date
3558: from bom_calendar_dates C
3559: where C.calendar_code = mp.calendar_code
3560: and c.exception_set_id = mp.calendar_exception_set_id
3561: and C.seq_num =
3562: (select c2.prior_seq_num -
3562: (select c2.prior_seq_num -
3563: ceil(nvl(v_msi_fixed_lead_time,0)+
3564: (be.extended_quantity *
3565: nvl(v_msi_variable_lead_time,0)))
3566: from bom_calendar_dates c2
3567: where c2.calendar_code = mp.calendar_code
3568: and c2.exception_set_id = mp.calendar_exception_set_id
3569: and c2.calendar_date = trunc(pReqDate)
3570: )