APPS.EGO_ITEM_LC_IMP_PC_PUB SQL Statements

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

Line: 55

  SELECT change.organization_id
  FROM  eng_revised_items change
  WHERE change.revised_item_id = cp_item_id
    AND change.organization_id = cp_org_id
    AND nvl(change.current_item_revision_id, -1) = nvl(cp_rev_id, nvl(change.current_item_revision_id,-1))
    AND change.status_type NOT IN (5, -- CANCELLED
                                   6  -- IMPLEMENTED
                                  )
    AND
      ( EXISTS
        (SELECT 'X'
        FROM  ego_mfg_part_num_chgs
        WHERE change_line_id = change.revised_item_sequence_id )
      OR EXISTS
        (SELECT 'X'
        FROM  ego_items_attrs_changes_vl
        WHERE change_line_id = change.revised_item_sequence_id )
      OR EXISTS
        (SELECT 'X'
        FROM  eng_attachment_changes
        WHERE revised_item_sequence_id = change.revised_item_sequence_id )
      );

Line: 82

  SELECT organization_id
  FROM  eng_revised_items change
  WHERE revised_item_id = cp_item_id
    AND organization_id IN
             (SELECT P2.ORGANIZATION_ID
              FROM   MTL_PARAMETERS P1,
                     MTL_PARAMETERS P2
              WHERE  P1.ORGANIZATION_ID = cp_org_id
              AND    P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID
              )
    AND nvl(current_item_revision_id, -1) = nvl(cp_rev_id, nvl(current_item_revision_id,-1))
    AND status_type NOT IN (5, -- CANCELLED
                            6  -- IMPLEMENTED
                           )
    AND
      ( EXISTS
        (SELECT 'X'
        FROM  ego_mfg_part_num_chgs
        WHERE change_line_id = change.revised_item_sequence_id )
      OR EXISTS
        (SELECT 'X'
        FROM  ego_items_attrs_changes_vl
        WHERE change_line_id = change.revised_item_sequence_id )
      OR EXISTS
        (SELECT 'X'
        FROM  eng_attachment_changes
        WHERE revised_item_sequence_id = change.revised_item_sequence_id )
      );

Line: 191

    SELECT concatenated_segments
    INTO l_item_number
    FROM mtl_system_items_kfv
    WHERE inventory_item_id = p_inventory_item_id
      AND organization_id = l_organization_id;

Line: 199

    SELECT organization_name
    INTO  l_org_name
    FROM  org_organization_definitions
    WHERE organization_id = l_organization_id;

Line: 262

    SELECT lifecycle_id, current_phase_id, inventory_item_status_code
    FROM   mtl_system_items_b
    WHERE  inventory_item_id = cp_inventory_item_id
      AND  organization_id = cp_organization_id;

Line: 270

    SELECT rev.lifecycle_id, rev.current_phase_id, itm.inventory_item_status_code
    FROM  mtl_system_items_b itm, mtl_item_revisions_b rev
    WHERE itm.inventory_item_id = cp_inventory_item_id
      AND itm.organization_id = cp_organization_id
      AND rev.inventory_item_id = itm.inventory_item_id
      AND rev.organization_id = rev.organization_id
      AND rev.revision_id = rev.revision_id;

Line: 279

    SELECT display_sequence
    FROM   pa_proj_element_versions
    WHERE  proj_element_id = cp_phase_id;

Line: 373

  SELECT
    inventory_item_id
   ,revision_id
   ,organization_id
   ,phase_id
   ,lifecycle_id
   ,status_code
   ,effective_date
  FROM
    MTL_PENDING_ITEM_STATUS
  WHERE inventory_item_id = p_inventory_item_id
    AND organization_id = p_organization_id
    AND revision_id = p_revision_id
    AND pending_flag = 'Y'
    AND implemented_date IS NULL
    AND effective_date <= SYSDATE
    AND NVL(change_id,-1) = NVL(p_change_id, NVL(change_id,-1))
    AND NVL(change_line_id,-1) = NVL(p_change_line_id, NVL(change_line_id,-1))
  ORDER BY effective_date ASC
  FOR UPDATE OF IMPLEMENTED_DATE, PENDING_FLAG;

Line: 395

    SELECT lifecycle_id, phase_id, status_code
    FROM MTL_PENDING_ITEM_STATUS
    WHERE INVENTORY_ITEM_ID = p_inventory_item_id
      AND ORGANIZATION_ID = p_organization_id
      AND REVISION_ID IS NULL
      AND PENDING_FLAG = 'Y'
      AND IMPLEMENTED_DATE IS NULL
      AND STATUS_CODE IS NOT NULL
      AND EFFECTIVE_DATE <= SYSDATE
      AND NVL(change_id,-1) = NVL(p_change_id, NVL(change_id,-1))
      AND NVL(change_line_id,-1) = NVL(p_change_line_id, NVL(change_line_id,-1))
      ORDER BY EFFECTIVE_DATE, LAST_UPDATE_DATE, ROWID;

Line: 409

    SELECT pending_status.phase_id
    FROM MTL_PENDING_ITEM_STATUS pending_status, mtl_system_items_b item
    WHERE pending_status.INVENTORY_ITEM_ID = p_inventory_item_id
      AND pending_status.ORGANIZATION_ID = p_organization_id
      AND pending_status.PENDING_FLAG = 'Y'
      AND pending_status.IMPLEMENTED_DATE IS NULL
      AND pending_status.EFFECTIVE_DATE <= SYSDATE
      AND pending_status.inventory_item_id = item.inventory_item_id
      AND pending_status.organization_id = item.organization_id
      AND ( NVL(pending_status.lifecycle_id,NVL(item.lifecycle_id,-1)) <> NVL(item.lifecycle_id,-1)
            OR
            NVL(pending_status.phase_id,NVL(item.current_phase_id,-1)) <> NVL(item.current_phase_id,-1)
           );

Line: 425

    SELECT pending_status.phase_id
    FROM MTL_PENDING_ITEM_STATUS pending_status, mtl_item_revisions_b rev
    WHERE pending_status.INVENTORY_ITEM_ID = p_inventory_item_id
      AND pending_status.ORGANIZATION_ID = p_organization_id
      AND pending_status.PENDING_FLAG = 'Y'
      AND pending_status.IMPLEMENTED_DATE IS NULL
      AND pending_status.EFFECTIVE_DATE <= SYSDATE
      AND pending_status.inventory_item_id = rev.inventory_item_id
      AND pending_status.organization_id = rev.organization_id
      AND pending_status.revision_id = rev.revision_id
      AND ( NVL(pending_status.lifecycle_id,NVL(rev.lifecycle_id,-1)) <> NVL(rev.lifecycle_id,-1)
            OR
            NVL(pending_status.phase_id,NVL(rev.current_phase_id,-1)) <> NVL(rev.current_phase_id,-1)
           );

Line: 444

    SELECT   MSI.organization_id,
             MSI.description,
             MSI.concatenated_segments,
             MP.ORGANIZATION_CODE
     FROM MTL_SYSTEM_ITEMS_KFV MSI,
          MTL_PARAMETERS    MP
     WHERE
          MSI.INVENTORY_ITEM_ID   = p_inventory_item_id
          AND MSI.ORGANIZATION_ID = p_organization_id
          AND MSI.Organization_ID = MP.Organization_ID;

Line: 456

  l_phase_update          VARCHAR2(1);

Line: 475

  l_phase_update         := NULL;

Line: 641

          UPDATE MTL_SYSTEM_ITEMS_B
          SET CURRENT_PHASE_ID = NVL(l_phase_id.PHASE_ID,current_phase_id)
          WHERE
            INVENTORY_ITEM_ID = p_inventory_item_id
            AND ORGANIZATION_ID IN
                 (SELECT P2.ORGANIZATION_ID
                  FROM   MTL_PARAMETERS P1, MTL_PARAMETERS P2
                  WHERE  P1.ORGANIZATION_ID = p_organization_id
                  AND    P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID);

Line: 650

          l_phase_update := 'Y';

Line: 710

          UPDATE MTL_SYSTEM_ITEMS_B
          SET CURRENT_PHASE_ID = NVL(l_phase_id.PHASE_ID, current_phase_id)
          WHERE INVENTORY_ITEM_ID = p_inventory_item_id
          AND ORGANIZATION_ID = p_organization_id;

Line: 714

          l_phase_update := 'Y';

Line: 722

      SELECT inventory_item_status_code INTO l_old_status
      FROM  mtl_system_items_b msi
      WHERE msi.inventory_item_id = p_inventory_item_id
      AND msi.organization_id = p_organization_id
      AND    rownum < 2;

Line: 729

      INV_ITEM_STATUS_PUB.Update_Pending_Status (1.0
                                                ,p_organization_id
                                                ,p_inventory_item_id
                                                ,NULL
                                                ,NULL
                                                ,x_return_status
                                                ,x_msg_count
                                                ,x_msg_data
                                                );

Line: 746

      SELECT inventory_item_status_code INTO l_new_status
      FROM  mtl_system_items_b msi
      WHERE msi.inventory_item_id = p_inventory_item_id
      AND msi.organization_id = p_organization_id
      AND    rownum < 2;

Line: 752

      IF l_phase_update = 'Y' OR
         NVL(l_old_status,-1) <> NVL(l_new_status,-1) THEN
          FOR Item_Rec IN c_get_item_details(p_inventory_item_id
	                                    ,p_organization_id) LOOP
             EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event(
                  p_event_name        => EGO_WF_WRAPPER_PVT.G_ITEM_UPDATE_EVENT
                 ,p_organization_id   => p_organization_id
                 ,p_organization_code => Item_Rec.organization_code
                 ,p_item_number       => Item_Rec.concatenated_segments
                 ,p_item_description  => Item_Rec.DESCRIPTION
                 ,p_inventory_item_id => p_inventory_item_id
                 ,x_msg_data          => l_msg_data
                 ,x_return_status     => l_event_return_status);

Line: 770

                     ,p_dml_type          => 'UPDATE'
                     ,p_inventory_item_id => p_inventory_item_id
                     ,p_item_number       => Item_Rec.concatenated_segments
                     ,p_item_description  => Item_Rec.DESCRIPTION
                     ,p_organization_id   => p_organization_id
                     ,p_organization_code => Item_Rec.organization_code );

Line: 835

          SELECT REVISION INTO l_current_revision
          FROM MTL_ITEM_REVISIONS_B
          WHERE
            INVENTORY_ITEM_ID = l_pending_record.INVENTORY_ITEM_ID
            AND REVISION_ID = l_pending_record.REVISION_ID
            AND ORGANIZATION_ID = l_pending_record.ORGANIZATION_ID;

Line: 863

          UPDATE MTL_ITEM_REVISIONS_B
          SET CURRENT_PHASE_ID = l_pending_record.PHASE_ID
          WHERE
            INVENTORY_ITEM_ID = l_pending_record.INVENTORY_ITEM_ID
            AND REVISION = l_current_revision
            AND ORGANIZATION_ID IN
                            (SELECT P2.ORGANIZATION_ID
                             FROM   MTL_PARAMETERS P1,
                                    MTL_PARAMETERS P2
                             WHERE  P1.ORGANIZATION_ID = p_organization_id
                             AND    P1.MASTER_ORGANIZATION_ID = P2.MASTER_ORGANIZATION_ID);

Line: 898

          UPDATE MTL_ITEM_REVISIONS_B
          SET CURRENT_PHASE_ID = l_pending_record.PHASE_ID
          WHERE
            INVENTORY_ITEM_ID = l_pending_record.INVENTORY_ITEM_ID
            AND REVISION_ID = l_pending_record.REVISION_ID
            AND ORGANIZATION_ID = l_pending_record.ORGANIZATION_ID;

Line: 911

          UPDATE MTL_PENDING_ITEM_STATUS
          SET
            PENDING_FLAG = 'N'
           ,IMPLEMENTED_DATE = SYSDATE
          WHERE CURRENT OF l_pending_revision_statuses;

Line: 974

  SELECT DECODE(LOOKUP_CODE2,
                1, FND_API.G_TRUE,
                2, FND_API.G_FALSE,
                FND_API.G_FALSE)
  INTO l_status_master_controlled
  FROM MTL_ITEM_ATTRIBUTES_V
  WHERE ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';

Line: 995

  SELECT DECODE(MP.ORGANIZATION_ID,
                MP.MASTER_ORGANIZATION_ID, FND_API.G_TRUE,
                FND_API.G_FALSE)
  INTO l_is_master_org
  FROM MTL_PARAMETERS MP
  WHERE MP.ORGANIZATION_ID = p_organization_id;

Line: 1018

  SELECT REVISION_ID
  INTO   l_revision_id
  FROM   MTL_ITEM_REVISIONS
  WHERE  INVENTORY_ITEM_ID = p_inventory_item_id
    AND  ORGANIZATION_ID = p_organization_id
    AND  revision = p_revision;

Line: 1083

  SELECT rev.current_phase_id, rev.lifecycle_id, rev.revision, rev.revision_id, item.approval_status
  FROM mtl_item_revisions_b rev, mtl_system_items_b item
  WHERE rev.inventory_item_id = cp_item_id
    AND rev.organization_id = cp_org_id
    AND rev.revision = NVL(cp_revision, rev.revision)
    AND rev.revision_id = NVL(cp_revision_id, rev.revision_id)
    AND item.inventory_item_id = rev.inventory_item_id
    AND item.organization_id = rev.organization_id;

Line: 1094

  SELECT current_phase_id, lifecycle_id, inventory_item_status_code, approval_status
  FROM mtl_system_items_b
  WHERE inventory_item_id = cp_item_id
    AND organization_id = cp_org_id;

Line: 1100

  SELECT status.item_status_code
  FROM   ego_lcphase_item_status status, pa_proj_elements lc_phases
  WHERE  lc_phases.proj_element_id = cp_phase_id
    AND  status.phase_code = lc_phases.phase_code
    AND  status.default_flag = 'Y'
    AND  lc_phases.PROJECT_ID = 0 AND lc_phases.OBJECT_TYPE = 'PA_TASKS';

Line: 1109

  SELECT status.item_status_code
  FROM   ego_lcphase_item_status status, pa_ego_phases_v lc_phases
  WHERE  lc_phases.proj_element_id = cp_phase_id
    AND  status.phase_code = lc_phases.phase_code
    AND  status.item_status_code = cp_status_code;

Line: 1192

    SELECT CONCATENATED_SEGMENTS
      INTO l_dummy_char
      FROM MTL_SYSTEM_ITEMS_KFV
     WHERE INVENTORY_ITEM_ID = p_inventory_item_id
       AND ORGANIZATION_ID = p_organization_id;

Line: 1198

    SELECT name
      INTO l_dummy_char
      FROM hr_all_organization_units_vl
     WHERE organization_id = p_organization_id;

Line: 1255

        SELECT name
        INTO l_dummy_char
        FROM PA_EGO_PHASES_V
        WHERE proj_element_id = p_phase_id;

Line: 1273

      SELECT count(*)
      INTO l_pending_rec_count
      FROM mtl_pending_item_status
      WHERE inventory_item_id = p_inventory_item_id
        AND organization_id = p_organization_id
        AND pending_flag = 'Y'
        AND implemented_date IS NULL
        AND NVL(revision_id,-1) = NVL(l_revision_id,-1)
        AND lifecycle_id IS NOT NULL
        AND phase_id IS NOT NULL;

Line: 1288

          SELECT concatenated_segments
          INTO l_dummy_char
          FROM mtl_system_items_b_kfv
          WHERE inventory_item_id = p_inventory_item_id
          AND   organization_id = p_organization_id;

Line: 1326

      SELECT name
      INTO l_dummy_char
      FROM PA_EGO_PHASES_V
      WHERE proj_element_id = NVL(p_phase_id,l_phase_id_curr);

Line: 1351

    code_debug(' comparing values before insert p_lifecycle_id '||p_lifecycle_id ||' l_lifecycle_id '||l_lifecycle_id);

Line: 1356

    INSERT INTO MTL_PENDING_ITEM_STATUS
    (
      inventory_item_id
     ,organization_id
     ,status_code
     ,effective_date
     ,implemented_date
     ,pending_flag
     ,last_update_date
     ,last_updated_by
     ,creation_date
     ,created_by
     ,last_update_login
--     ,request_id
--     ,program_update_date
     ,revision_id
     ,lifecycle_id
     ,phase_id
     ,change_id
     ,change_line_id
    )
    VALUES
    (
      p_inventory_item_id
     ,p_organization_id
     ,l_status_code
     ,NVL(p_effective_date,l_sysdate)
     ,NULL
     ,NVL(p_pending_flag,'Y')
     ,l_sysdate
     ,G_CURRENT_USER_ID
     ,l_sysdate
     ,G_CURRENT_USER_ID
     ,G_CURRENT_LOGIN_ID
--     ,NULL
--     ,l_sysdate
     ,l_revision_id
     ,l_lifecycle_id
     ,l_phase_id
     ,p_change_id
     ,p_change_line_id
    );

Line: 1507

         p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE)
      ) THEN
      fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');

Line: 1545

    IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
      --
      -- to be removed after bug 3874132 is resoloved.
      --
      code_debug(l_api_name|| ' Updating pending change record ');

Line: 1550

      UPDATE mtl_pending_item_status
      SET    effective_date     = p_new_effective_date,
             last_update_date   = SYSDATE,
             last_updated_by    = G_CURRENT_USER_ID,
             last_update_login  = G_CURRENT_LOGIN_ID
      WHERE  inventory_item_id                 = p_inventory_item_id
        AND  organization_id                   = p_organization_id
        AND  NVL(revision_id,l_miss_num)       = NVL(p_revision_id, l_miss_num)
        AND  NVL(lifecycle_id, l_miss_num)     = NVL(p_lifecycle_id, l_miss_num)
        AND  NVL(phase_id, l_miss_num)         = NVL(p_phase_id, l_miss_num)
        AND  NVL(status_code,l_miss_char)      = NVL(p_status_code, l_miss_char)
        AND  NVL(p_change_id, l_miss_num)      = NVL(p_change_id, l_miss_num)
        AND  NVL(p_change_line_id, l_miss_num) = NVL(p_change_line_id, l_miss_num)
        AND  effective_date                    = p_effective_date
        AND  pending_flag                      = 'Y'
        AND  implemented_date IS NULL;

Line: 1567

        code_debug(l_api_name|| ' cannot update record!! ');

Line: 1569

        fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_REC_UPDATE');

Line: 1574

    ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE THEN
      --
      -- to be removed after bug 3874132 is resoloved.
      --
      code_debug(l_api_name|| ' Deleting pending change record ');

Line: 1579

      DELETE mtl_pending_item_status
      WHERE  inventory_item_id                 = p_inventory_item_id
        AND  organization_id                   = p_organization_id
        AND  NVL(revision_id,l_miss_num)       = NVL(p_revision_id, l_miss_num)
        AND  NVL(lifecycle_id, l_miss_num)     = NVL(p_lifecycle_id, l_miss_num)
        AND  NVL(phase_id, l_miss_num)         = NVL(p_phase_id, l_miss_num)
        AND  NVL(status_code,l_miss_char)      = NVL(p_status_code, l_miss_char)
        AND  NVL(p_change_id, l_miss_num)      = NVL(p_change_id, l_miss_num)
        AND  NVL(p_change_line_id, l_miss_num) = NVL(p_change_line_id, l_miss_num)
        AND  effective_date                    = p_effective_date
        AND  pending_flag                      = 'Y'
        AND  implemented_date IS NULL;

Line: 1593

        fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_REC_DELETE');

Line: 1612

PROCEDURE Delete_Pending_Phase_Change
(
  p_api_version                     IN   NUMBER
 ,p_commit                          IN   VARCHAR2
 ,p_inventory_item_id               IN   NUMBER
 ,p_organization_id                 IN   NUMBER
 ,p_change_id                       IN   NUMBER
 ,p_change_line_id                  IN   NUMBER
 ,x_return_status                   OUT  NOCOPY VARCHAR2
 ,x_errorcode                       OUT  NOCOPY NUMBER
 ,x_msg_count                       OUT  NOCOPY NUMBER
 ,x_msg_data                        OUT  NOCOPY VARCHAR2
 ) IS

  l_api_version      NUMBER;

Line: 1631

  l_api_name         := 'Delete_Pending_Phase_Change';

Line: 1655

    SAVEPOINT Delete_Pending_Phase_Change_SP;

Line: 1664

        DELETE MTL_PENDING_ITEM_STATUS
        WHERE  organization_id   = p_organization_id
          AND  inventory_item_id = p_inventory_item_id
          AND  change_id         = p_change_id
          AND  change_line_id    = p_change_line_id
          AND  implemented_date IS NULL
          AND  pending_flag = 'Y';

Line: 1675

        DELETE MTL_PENDING_ITEM_STATUS
        WHERE  organization_id   = p_organization_id
          AND  change_id         = p_change_id
          AND  change_line_id    = p_change_line_id
          AND  implemented_date IS NULL
          AND  pending_flag = 'Y';

Line: 1687

        DELETE MTL_PENDING_ITEM_STATUS
        WHERE  organization_id   = p_organization_id
          AND  inventory_item_id = p_inventory_item_id
          AND  change_id         = p_change_id
          AND  implemented_date IS NULL
          AND  pending_flag = 'Y';

Line: 1697

        DELETE MTL_PENDING_ITEM_STATUS
        WHERE  organization_id   = p_organization_id
          AND  change_id         = p_change_id
          AND  implemented_date IS NULL
          AND  pending_flag = 'Y';

Line: 1710

        DELETE MTL_PENDING_ITEM_STATUS
        WHERE  organization_id   = p_organization_id
          AND  inventory_item_id = p_inventory_item_id
          AND  change_line_id    = p_change_line_id
          AND  implemented_date IS NULL
          AND  pending_flag = 'Y';

Line: 1720

        DELETE MTL_PENDING_ITEM_STATUS
        WHERE  organization_id   = p_organization_id
          AND  change_line_id    = p_change_line_id
          AND  implemented_date IS NULL
          AND  pending_flag = 'Y';

Line: 1732

        DELETE MTL_PENDING_ITEM_STATUS
        WHERE  organization_id   = p_organization_id
          AND  inventory_item_id = p_inventory_item_id
          AND  change_id        IS NULL
          AND  change_line_id   IS NULL
          AND  implemented_date IS NULL
          AND  pending_flag = 'Y';

Line: 1751

        ROLLBACK TO Delete_Pending_Phase_Change_SP;

Line: 1760

END Delete_Pending_Phase_Change;

Line: 1833

  SELECT *
  FROM  mtl_pending_item_status
  WHERE implemented_date IS NULL
    AND pending_flag = 'Y'
    AND change_id = NVL(cp_change_id, change_id)
    AND change_line_id = NVL(cp_change_line_id, change_line_id);

Line: 1970

  SELECT
    DECODE(LOOKUP_CODE2, 1, FND_API.G_TRUE, 2, FND_API.G_FALSE, FND_API.G_FALSE) INTO l_status_master_controlled
  FROM
    MTL_ITEM_ATTRIBUTES_V
  WHERE
    ATTRIBUTE_NAME = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';

Line: 1983

    SELECT
      ORGANIZATION_ID BULK COLLECT INTO l_orgs
    FROM
      ORG_ACCESS_VIEW
    WHERE RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID
    AND RESP_APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID;

Line: 2006

        SELECT
          MP.MASTER_ORGANIZATION_ID INTO l_master_org
        FROM
          MTL_PARAMETERS MP
        WHERE
          MP.ORGANIZATION_ID = l_orgs(org_index);

Line: 2024

          SELECT
            INVENTORY_ITEM_ID BULK COLLECT INTO l_items
          FROM
            MTL_SYSTEM_ITEMS_B
          WHERE
            ORGANIZATION_ID = l_orgs(org_index);

Line: 2049

                SELECT
                  REVISION BULK COLLECT INTO l_revs
                FROM
                  MTL_ITEM_REVISIONS_B
                WHERE ORGANIZATION_ID = l_orgs(org_index)
                      AND INVENTORY_ITEM_ID = l_items(item_index);

Line: 2089

                        SELECT
                          REVISION_ID INTO l_revision_id
                        FROM
                          MTL_ITEM_REVISIONS_B
                        WHERE
                          ORGANIZATION_ID = l_master_org
                          AND INVENTORY_ITEM_ID = l_items(item_index)
                          AND REVISION = l_revs(rev_index);

Line: 2100

                        SELECT
                          REVISION_ID INTO l_revision_id
                        FROM
                          MTL_ITEM_REVISIONS_B
                        WHERE
                          ORGANIZATION_ID = l_orgs(org_index)
                          AND INVENTORY_ITEM_ID = l_items(item_index)
                          AND REVISION = l_revs(rev_index);

Line: 2109

                      END IF; -- select rev id