DBA Data[Home] [Help]

APPS.MST_AUDIT_REP_EXCP dependencies on BOM_CALENDAR_DATES

Line 1471: FROM BOM_CALENDAR_DATES caldates,

1467: SELECT 2 INTO exceptionFlag --SYS_NO (no exception since there is at least one overlapping shift)
1468: FROM DUAL
1469: WHERE EXISTS
1470: ( SELECT caldates.CALENDAR_DATE
1471: FROM BOM_CALENDAR_DATES caldates,
1472: BOM_SHIFT_DATES sdates,
1473: BOM_SHIFT_TIMES bshift,
1474: MST_PLANS plan
1475: WHERE plan.plan_id = plan_idIn

Line 1670: FROM BOM_CALENDAR_DATES caldates,

1666: SELECT 2 INTO exceptionFlag --SYS_NO (no exception since there is at least one overlapping shift)
1667: FROM DUAL
1668: WHERE EXISTS
1669: ( SELECT caldates.CALENDAR_DATE
1670: FROM BOM_CALENDAR_DATES caldates,
1671: BOM_SHIFT_DATES sdates,
1672: BOM_SHIFT_TIMES bshift,
1673: MST_PLANS plan
1674: WHERE plan.plan_id = plan_idIn