DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on BOM_CALENDAR_DATES

Line 3945: bom_calendar_dates bom

3941: flm_timezone.calendar_to_server(calendar_date), --TZ Bug 3832684
3942: 0,
3943: 0
3944: FROM mtl_parameters mp,
3945: bom_calendar_dates bom
3946: WHERE mp.organization_id = p_organization_id
3947: AND mp.calendar_exception_set_id = bom.exception_set_id
3948: AND mp.calendar_code = bom.calendar_code
3949: AND bom.seq_num IS NOT NULL

Line 3967: bom_calendar_dates bom

3963: p_to_start_date DATE, p_to_end_date DATE) --fix bug#3170105
3964: IS
3965: SELECT count(bom.calendar_date)
3966: FROM mtl_parameters mp,
3967: bom_calendar_dates bom
3968: WHERE mp.calendar_exception_set_id = bom.exception_set_id
3969: AND mp.calendar_code = bom.calendar_code
3970: AND mp.organization_id = p_organization_id
3971: AND bom.calendar_date BETWEEN flm_timezone.server_to_calendar(p_to_start_date) --fix bug#3170105