DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on MTL_PARAMETERS

Line 3944: FROM mtl_parameters mp,

3940: SELECT 0,
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

Line 3966: FROM mtl_parameters mp,

3962: CURSOR C4(p_line_id NUMBER, p_item_id NUMBER,
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