DBA Data[Home] [Help]

APPS.AHL_FMP_EFFECTIVITY_DTL_PVT dependencies on AHL_MR_EFFECTIVITY_DTLS_V

Line 854: FROM AHL_MR_EFFECTIVITY_DTLS_V

850: attribute12,
851: attribute13,
852: attribute14,
853: attribute15
854: FROM AHL_MR_EFFECTIVITY_DTLS_V
855: WHERE mr_effectivity_detail_id = c_mr_effectivity_detail_id;
856:
857: BEGIN
858:

Line 1547: FROM AHL_MR_EFFECTIVITY_DTLS_V

1543: manufacturer,
1544: manufacture_date_from,
1545: manufacture_date_to,
1546: country
1547: FROM AHL_MR_EFFECTIVITY_DTLS_V
1548: WHERE mr_effectivity_id = c_mr_effectivity_id
1549: GROUP BY serial_number_from,
1550: serial_number_to,
1551: manufacturer,

Line 1734: FROM AHL_MR_EFFECTIVITY_DTLS_V

1730: IS
1731: SELECT serial_number_from,
1732: serial_number_to,
1733: MR_EFFECTIVITY_DETAIL_ID
1734: FROM AHL_MR_EFFECTIVITY_DTLS_V
1735: WHERE mr_effectivity_id = c_mr_effectivity_id;
1736:
1737:
1738: Cursor find_min_max_serials ( c_mr_effectivity_id NUMBER )