DBA Data[Home] [Help]

APPS.MST_AUDIT_REP_EXCP dependencies on BOM_SHIFT_DATES

Line 1472: BOM_SHIFT_DATES sdates,

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
1476: AND caldates.CALENDAR_CODE = sdates.CALENDAR_CODE (+)

Line 1671: BOM_SHIFT_DATES sdates,

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
1675: AND caldates.CALENDAR_CODE = sdates.CALENDAR_CODE (+)