APPS.INV_INVARCLI_XMLP_PKG SQL Statements

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

Line: 101

      SELECT
        NVL(SUM(PRIMARY_TRANSACTION_QUANTITY)
           ,0)
      INTO V_PRIMARY_SYS_QTY
      FROM
        MTL_ONHAND_QUANTITIES_DETAIL
      WHERE INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_V
        AND ORGANIZATION_ID = P_ORG_ID
        AND SUBINVENTORY_CODE = SUBINVENTORY
        AND NVL(LOT_NUMBER
         ,'XX') = NVL(LOTNUMBER
         ,'XX')
        AND NVL(REVISION
         ,'XXX') = NVL(REVISION
         ,'XXX')
        AND NVL(LOCATOR_ID
         ,-2) = NVL(LOCATOR
         ,-2)
        AND NVL(LPN_ID
         ,-3) = NVL(PARENT_LPN_ID
         ,-3);

Line: 123

      SELECT
        NVL(SUM(DECODE(MSN.CURRENT_STATUS
                      ,3
                      ,1
                      ,0))
           ,0)
      INTO V_PRIMARY_SYS_QTY
      FROM
        MTL_SERIAL_NUMBERS MSN
      WHERE MSN.SERIAL_NUMBER = NVL(SERIAL_NUMBER
         ,SERIAL_NUMBER)
        AND MSN.INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_V
        AND MSN.CURRENT_ORGANIZATION_ID = P_ORG_ID
        AND MSN.CURRENT_SUBINVENTORY_CODE = SUBINVENTORY
        AND NVL(MSN.LOT_NUMBER
         ,'XX') = NVL(LOTNUMBER
         ,'XX')
        AND NVL(MSN.REVISION
         ,'XXX') = NVL(REVISION
         ,'XXX')
        AND NVL(MSN.CURRENT_LOCATOR_ID
         ,-2) = NVL(LOCATOR
         ,-2)
        AND NVL(LPN_ID
         ,-3) = NVL(PARENT_LPN_ID
         ,-3);

Line: 162

    SELECT
      DECODE(MSN.CURRENT_STATUS
            ,3
            ,'Y'
            ,'N')
    INTO V_ISSERIALPRESENT
    FROM
      MTL_SERIAL_NUMBERS MSN
    WHERE MSN.SERIAL_NUMBER = SL_SERIAL_NUMBER
      AND MSN.INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_V
      AND MSN.CURRENT_ORGANIZATION_ID = P_ORG_ID
      AND ( MSN.CURRENT_STATUS = 6
    OR ( MSN.CURRENT_SUBINVENTORY_CODE = SUBINVENTORY
      AND NVL(MSN.LOT_NUMBER
       ,'XX') = NVL(LOTNUMBER
       ,'XX')
      AND NVL(MSN.REVISION
       ,'XXX') = NVL(REVISION
       ,'XXX')
      AND NVL(MSN.CURRENT_LOCATOR_ID
       ,-2) = NVL(LOCATOR
       ,-2) ) );

Line: 195

        SELECT
          COST_GROUP
        INTO M_COST_GROUP
        FROM
          CST_COST_GROUPS
        WHERE COST_GROUP_ID = COST_GROUP_ID;

Line: 216

        SELECT
          LICENSE_PLATE_NUMBER
        INTO M_OUTERMOST_LPN
        FROM
          WMS_LICENSE_PLATE_NUMBERS
        WHERE LPN_ID = OUTERMOST_LPN_ID;

Line: 237

        SELECT
          LICENSE_PLATE_NUMBER
        INTO M_PARENT_LPN
        FROM
          WMS_LICENSE_PLATE_NUMBERS
        WHERE LPN_ID = PARENT_LPN_ID;