DBA Data[Home] [Help]

APPS.INV_SHORTCHECKEXEC_PVT dependencies on BOM_CALENDAR_DATES

Line 1038: , bom_calendar_dates bcd1

1034: + 1
1035: )
1036: INTO l_num_days
1037: FROM mtl_parameters mp
1038: , bom_calendar_dates bcd1
1039: , bom_calendar_dates bcd2
1040: WHERE mp.organization_id = p_organization_id
1041: AND bcd1.calendar_code = mp.calendar_code
1042: AND bcd1.exception_set_id = mp.calendar_exception_set_id

Line 1039: , bom_calendar_dates bcd2

1035: )
1036: INTO l_num_days
1037: FROM mtl_parameters mp
1038: , bom_calendar_dates bcd1
1039: , bom_calendar_dates bcd2
1040: WHERE mp.organization_id = p_organization_id
1041: AND bcd1.calendar_code = mp.calendar_code
1042: AND bcd1.exception_set_id = mp.calendar_exception_set_id
1043: AND bcd1.calendar_date = TRUNC(p_first_unit_start_date)