eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_FMP_EFFECTIVITY_DTL_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 212


SELECT  DECODE( relationship_id, null,
                                 inventory_item_id,
                                 position_inventory_item_id ),
        DECODE( relationship_id, null,
                                 item_number,
                                 position_item_number ),
        relationship_id,
        position_ref_meaning
FROM    AHL_MR_EFFECTIVITIES_V
WHERE   mr_effectivity_id = c_mr_effectivity_id;

Line: 325


  p_x_effectivity_detail_rec.last_update_date := SYSDATE;

Line: 326


  p_x_effectivity_detail_rec.last_updated_by := FND_GLOBAL.user_id;

Line: 327


  p_x_effectivity_detail_rec.last_update_login := FND_GLOBAL.login_id;

Line: 456


SELECT  exclude_flag,
        serial_number_from,
        serial_number_to,
        manufacturer_id,
        manufacturer,
        manufacture_date_from,
        manufacture_date_to,
        country_code,
        country,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15
FROM    AHL_MR_EFFECTIVITY_DTLS_V
WHERE   mr_effectivity_detail_id = c_mr_effectivity_detail_id;

Line: 819


SELECT   serial_number_from,
         serial_number_to,
         manufacturer,
         manufacture_date_from,
         manufacture_date_to,
         country
FROM     AHL_MR_EFFECTIVITY_DTLS_V
WHERE    mr_effectivity_id = c_mr_effectivity_id
GROUP BY serial_number_from,
         serial_number_to,
         manufacturer,
         manufacture_date_from,
         manufacture_date_to,
         country
HAVING   count(*) > 1;

Line: 887


SELECT   serial_number_from,
         serial_number_to,
         MR_EFFECTIVITY_DETAIL_ID
FROM     AHL_MR_EFFECTIVITY_DTLS_V
WHERE    mr_effectivity_id = c_mr_effectivity_id;

Line: 896


select distinct MIN(CSI.serial_number) , MAX(CSI.serial_number)
from csi_item_instances CSI,
AHL_MR_EFFECTIVITIES EFF
where
EFF.MR_EFFECTIVITY_ID  = c_mr_effectivity_id and
CSI.inventory_item_id = EFF.inventory_item_id
UNION
select distinct MIN(CSI.serial_number) , MAX(CSI.serial_number)
from csi_item_instances CSI,
ahl_position_alternates_v PA,
AHL_MR_EFFECTIVITIES EFF
where
EFF.MR_EFFECTIVITY_ID  = c_mr_effectivity_id  and
EFF.RELATIONSHIP_ID = PA.relationship_id and
CSI.inventory_item_id = PA.inventory_item_id;

Line: 1108


      INSERT INTO AHL_MR_EFFECTIVITY_DTLS
      (
        MR_EFFECTIVITY_DETAIL_ID,
        OBJECT_VERSION_NUMBER,
        MR_EFFECTIVITY_ID,
        EXCLUDE_FLAG,
        SERIAL_NUMBER_FROM,
        SERIAL_NUMBER_TO,
        MANUFACTURER_ID,
        MANUFACTURE_DATE_FROM,
        MANUFACTURE_DATE_TO,
        COUNTRY_CODE,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_LOGIN
      ) VALUES
      (
        AHL_MR_EFFECTIVITY_DTLS_S.NEXTVAL,
        p_x_effectivity_detail_tbl(i).object_version_number,
        p_mr_effectivity_id,
        p_x_effectivity_detail_tbl(i).exclude_flag,
        p_x_effectivity_detail_tbl(i).serial_number_from,
        p_x_effectivity_detail_tbl(i).serial_number_to,
        p_x_effectivity_detail_tbl(i).manufacturer_id,
        p_x_effectivity_detail_tbl(i).manufacture_date_from,
        p_x_effectivity_detail_tbl(i).manufacture_date_to,
        p_x_effectivity_detail_tbl(i).country_code,
        p_x_effectivity_detail_tbl(i).attribute_category,
        p_x_effectivity_detail_tbl(i).attribute1,
        p_x_effectivity_detail_tbl(i).attribute2,
        p_x_effectivity_detail_tbl(i).attribute3,
        p_x_effectivity_detail_tbl(i).attribute4,
        p_x_effectivity_detail_tbl(i).attribute5,
        p_x_effectivity_detail_tbl(i).attribute6,
        p_x_effectivity_detail_tbl(i).attribute7,
        p_x_effectivity_detail_tbl(i).attribute8,
        p_x_effectivity_detail_tbl(i).attribute9,
        p_x_effectivity_detail_tbl(i).attribute10,
        p_x_effectivity_detail_tbl(i).attribute11,
        p_x_effectivity_detail_tbl(i).attribute12,
        p_x_effectivity_detail_tbl(i).attribute13,
        p_x_effectivity_detail_tbl(i).attribute14,
        p_x_effectivity_detail_tbl(i).attribute15,
        p_x_effectivity_detail_tbl(i).last_update_date,
        p_x_effectivity_detail_tbl(i).last_updated_by,
        p_x_effectivity_detail_tbl(i).creation_date,
        p_x_effectivity_detail_tbl(i).created_by,
        p_x_effectivity_detail_tbl(i).last_update_login
      ) RETURNING mr_effectivity_detail_id INTO l_mr_effectivity_detail_id;

Line: 1182


      UPDATE AHL_MR_EFFECTIVITY_DTLS SET
        object_version_number = object_version_number + 1,
        exclude_flag          = p_x_effectivity_detail_tbl(i).exclude_flag,
        serial_number_from    = p_x_effectivity_detail_tbl(i).serial_number_from,
        serial_number_to      = p_x_effectivity_detail_tbl(i).serial_number_to,
        manufacturer_id       = p_x_effectivity_detail_tbl(i).manufacturer_id,
        manufacture_date_from = p_x_effectivity_detail_tbl(i).manufacture_date_from,
        manufacture_date_to   = p_x_effectivity_detail_tbl(i).manufacture_date_to,
        country_code          = p_x_effectivity_detail_tbl(i).country_code,
        attribute_category    = p_x_effectivity_detail_tbl(i).attribute_category,
        attribute1            = p_x_effectivity_detail_tbl(i).attribute1,
        attribute2            = p_x_effectivity_detail_tbl(i).attribute2,
        attribute3            = p_x_effectivity_detail_tbl(i).attribute3,
        attribute4            = p_x_effectivity_detail_tbl(i).attribute4,
        attribute5            = p_x_effectivity_detail_tbl(i).attribute5,
        attribute6            = p_x_effectivity_detail_tbl(i).attribute6,
        attribute7            = p_x_effectivity_detail_tbl(i).attribute7,
        attribute8            = p_x_effectivity_detail_tbl(i).attribute8,
        attribute9            = p_x_effectivity_detail_tbl(i).attribute9,
        attribute10           = p_x_effectivity_detail_tbl(i).attribute10,
        attribute11           = p_x_effectivity_detail_tbl(i).attribute11,
        attribute12           = p_x_effectivity_detail_tbl(i).attribute12,
        attribute13           = p_x_effectivity_detail_tbl(i).attribute13,
        attribute14           = p_x_effectivity_detail_tbl(i).attribute14,
        attribute15           = p_x_effectivity_detail_tbl(i).attribute15,
        last_update_date      = p_x_effectivity_detail_tbl(i).last_update_date,
        last_updated_by       = p_x_effectivity_detail_tbl(i).last_updated_by,
        last_update_login     = p_x_effectivity_detail_tbl(i).last_update_login
      WHERE mr_effectivity_detail_id  = p_x_effectivity_detail_tbl(i).mr_effectivity_detail_id
      AND   object_version_number     = p_x_effectivity_detail_tbl(i).object_version_number;

Line: 1227


      DELETE AHL_MR_EFFECTIVITY_DTLS
      WHERE mr_effectivity_detail_id = p_x_effectivity_detail_tbl(i).mr_effectivity_detail_id
      AND   object_version_number    = p_x_effectivity_detail_tbl(i).object_version_number;