DBA Data[Home] [Help]

APPS.MST_AUDIT_REP_EXCP dependencies on BOM_SHIFT_TIMES

Line 1473: BOM_SHIFT_TIMES bshift,

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 (+)
1477: AND caldates.CALENDAR_DATE = sdates.SHIFT_DATE (+)

Line 1672: BOM_SHIFT_TIMES bshift,

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 (+)
1676: AND caldates.CALENDAR_DATE = sdates.SHIFT_DATE (+)