[Home] [Help]
2267: be.line_id , -- 2897132
2268: nvl(bic.wip_supply_type, msi2.wip_supply_type), -- 3254039 , 3298244
2269: xGrpId
2270: from
2271: bom_calendar_dates cal,
2272: mtl_system_items msi, /* PARENT */
2273: mtl_system_items msi2, /* CHILD */
2274: bom_inventory_components bic,
2275: eng_revised_items eri,
2293: and cal.calendar_code = mp.calendar_code
2294: and cal.exception_set_id = mp.calendar_exception_set_id
2295: and cal.calendar_date =
2296: ( select c.calendar_date
2297: from bom_calendar_dates C
2298: where C.calendar_code = mp.calendar_code
2299: and c.exception_set_id = mp.calendar_exception_set_id
2300: and C.seq_num =
2301: (select c2.prior_seq_num -
2301: (select c2.prior_seq_num -
2302: ceil( nvl( v_msi_fixed_lead_time,0)+
2303: (be.extended_quantity *
2304: v_msi_variable_lead_time ))
2305: from bom_calendar_dates c2
2306: where c2.calendar_code = mp.calendar_code
2307: and c2.exception_set_id = mp.calendar_exception_set_id
2308: and c2.calendar_date = trunc(pReqDate)
2309: )
2674: be.line_id ,
2675: nvl(bic.wip_supply_type, msi2.wip_supply_type),
2676: xGrpId
2677: from
2678: bom_calendar_dates cal,
2679: mtl_system_items msi,
2680: mtl_system_items msi2,
2681: bom_inventory_components bic,
2682: eng_revised_items eri,
2700: and cal.calendar_code = mp.calendar_code
2701: and cal.exception_set_id = mp.calendar_exception_set_id
2702: and cal.calendar_date =
2703: ( select c.calendar_date
2704: from bom_calendar_dates C
2705: where C.calendar_code = mp.calendar_code
2706: and c.exception_set_id = mp.calendar_exception_set_id
2707: and C.seq_num =
2708: (select c2.prior_seq_num -
2708: (select c2.prior_seq_num -
2709: ceil( nvl( v_msi_fixed_lead_time,0)+
2710: (be.extended_quantity *
2711: v_msi_variable_lead_time ))
2712: from bom_calendar_dates c2
2713: where c2.calendar_code = mp.calendar_code
2714: and c2.exception_set_id = mp.calendar_exception_set_id
2715: and c2.calendar_date = trunc(pReqDate)
2716: )
3207: msi.bom_item_type,
3208: NULL,
3209: xGrpId
3210: from
3211: bom_calendar_dates cal,
3212: mtl_system_items msi, /* PARENT */
3213: mtl_system_items msi2, /* CHILD [BUG#1518894] */
3214: bom_inventory_components bic,
3215: eng_revised_items eri,
3233: and cal.calendar_code = mp.calendar_code
3234: and cal.exception_set_id = mp.calendar_exception_set_id
3235: and cal.calendar_date =
3236: ( select c.calendar_date
3237: from bom_calendar_dates C
3238: where C.calendar_code = mp.calendar_code
3239: and c.exception_set_id = mp.calendar_exception_set_id
3240: and C.seq_num =
3241: (select c2.prior_seq_num -
3241: (select c2.prior_seq_num -
3242: ceil(nvl(v_msi_fixed_lead_time,0)+
3243: (be.extended_quantity *
3244: nvl(v_msi_variable_lead_time,0)))
3245: from bom_calendar_dates c2
3246: where c2.calendar_code = mp.calendar_code
3247: and c2.exception_set_id = mp.calendar_exception_set_id
3248: and c2.calendar_date = trunc(pReqDate)
3249: )
3621: msi.bom_item_type,
3622: NULL,
3623: xGrpId
3624: from
3625: bom_calendar_dates cal,
3626: mtl_system_items msi,
3627: mtl_system_items msi2,
3628: bom_inventory_components bic,
3629: eng_revised_items eri,
3647: and cal.calendar_code = mp.calendar_code
3648: and cal.exception_set_id = mp.calendar_exception_set_id
3649: and cal.calendar_date =
3650: ( select c.calendar_date
3651: from bom_calendar_dates C
3652: where C.calendar_code = mp.calendar_code
3653: and c.exception_set_id = mp.calendar_exception_set_id
3654: and C.seq_num =
3655: (select c2.prior_seq_num -
3655: (select c2.prior_seq_num -
3656: ceil(nvl(v_msi_fixed_lead_time,0)+
3657: (be.extended_quantity *
3658: nvl(v_msi_variable_lead_time,0)))
3659: from bom_calendar_dates c2
3660: where c2.calendar_code = mp.calendar_code
3661: and c2.exception_set_id = mp.calendar_exception_set_id
3662: and c2.calendar_date = trunc(pReqDate)
3663: )