DBA Data[Home] [Help]

APPS.WIP_INFRESSCHED_GRP dependencies on BOM_CALENDAR_DATES

Line 945: bom_calendar_dates bcd,

941: select -1 shiftNum,
942: bcd.calendar_date + wl.start_time/86400,
943: bcd.calendar_date + wl.stop_time/86400
944: from mtl_parameters mp,
945: bom_calendar_dates bcd,
946: wip_lines wl
947: where mp.organization_id = v_orgID
948: and mp.calendar_code = bcd.calendar_code
949: and mp.calendar_exception_set_id = bcd.exception_set_id

Line 962: bom_calendar_dates bcd

958: select -1,
959: bcd.calendar_date,
960: bcd.calendar_date + 1
961: from mtl_parameters mp,
962: bom_calendar_dates bcd
963: where mp.organization_id = v_orgID
964: and mp.calendar_code = bcd.calendar_code
965: and mp.calendar_exception_set_id = bcd.exception_set_id
966: and bcd.calendar_date between v_startDate and v_endDate

Line 1724: bom_calendar_dates bcd

1720: select -1,
1721: bcd.calendar_date,
1722: bcd.calendar_date + 1
1723: from mtl_parameters mp,
1724: bom_calendar_dates bcd
1725: where mp.organization_id = v_orgID
1726: and mp.calendar_code = bcd.calendar_code
1727: and mp.calendar_exception_set_id = bcd.exception_set_id
1728: and bcd.calendar_date between v_startDate and v_endDate

Line 1743: bom_calendar_dates bcd,

1739: select -1 shiftNum,
1740: bcd.calendar_date + wl.start_time/86400,
1741: bcd.calendar_date + wl.stop_time/86400
1742: from mtl_parameters mp,
1743: bom_calendar_dates bcd,
1744: wip_lines wl
1745: where mp.organization_id = v_orgID
1746: and mp.calendar_code = bcd.calendar_code
1747: and mp.calendar_exception_set_id = bcd.exception_set_id