APPS.INV_INVTRSHS_XMLP_PKG SQL Statements

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

Line: 106

      RETURN ('/* Do not select from category tables.*/');

Line: 148

    SELECT
      ML.MEANING
    INTO V_MEANING
    FROM
      MFG_LOOKUPS ML
    WHERE ML.LOOKUP_TYPE = 'MTL_SHORT_SUM_PRINT_GROUP'
      AND ML.LOOKUP_CODE = P_GROUP_BY;

Line: 171

        SELECT
          MCS.CATEGORY_SET_NAME
        INTO NAME
        FROM
          MTL_CATEGORY_SETS MCS
        WHERE MCS.CATEGORY_SET_ID = SET_ID;

Line: 198

      RETURN ('and 0 < (select NVL(SUM(DECODE(MSIN.availability_type, 1, 1, 0) * MIQV.quantity), 0)
                         	      from   mtl_secondary_inventories MSIN
                                         ,mtl_item_quantities_view MIQV
                         	      where  MSSV.organization_id = MIQV.organization_id
                         	      and    MSSV.inventory_item_id = MIQV.inventory_item_id
                         	      and    MIQV.organization_id = MSIN.organization_id
                         	      and    MIQV.subinventory_code = MSIN.secondary_inventory_name)');

Line: 213

    SELECT
      ML.MEANING
    INTO V_MEANING
    FROM
      MFG_LOOKUPS ML
    WHERE ML.LOOKUP_TYPE = 'SYS_YES_NO'
      AND ML.LOOKUP_CODE = P_ONHAND_ONLY_YN;

Line: 233

      SELECT
        NVL(SUM(DECODE(MSI.AVAILABILITY_TYPE
                      ,1
                      ,1
                      ,0) * MIQV.QUANTITY)
           ,0)
      INTO SUM_QTY
      FROM
        MTL_ITEM_QUANTITIES_VIEW MIQV,
        MTL_SECONDARY_INVENTORIES MSI
      WHERE MIQV.INVENTORY_ITEM_ID = C_INVENTORY_ITEM_ID
        AND MIQV.ORGANIZATION_ID = P_ORG_ID
        AND MSI.ORGANIZATION_ID = P_ORG_ID
        AND MSI.SECONDARY_INVENTORY_NAME = MIQV.SUBINVENTORY_CODE;

Line: 260

      SELECT
        NVL(SUM(DECODE(MSI.AVAILABILITY_TYPE
                      ,1
                      ,1
                      ,0) * MIQV.QUANTITY)
           ,0)
      INTO SUM_QTY
      FROM
        MTL_ITEM_QUANTITIES_VIEW MIQV,
        MTL_SECONDARY_INVENTORIES MSI
      WHERE MIQV.INVENTORY_ITEM_ID = C_INVENTORY_ITEM_ID
        AND MIQV.ORGANIZATION_ID = P_ORG_ID
        AND MSI.ORGANIZATION_ID = P_ORG_ID
        AND MSI.SECONDARY_INVENTORY_NAME = MIQV.SUBINVENTORY_CODE;

Line: 300

    SELECT
      ML.MEANING
    INTO V_MEANING
    FROM
      MFG_LOOKUPS ML
    WHERE ML.LOOKUP_TYPE = 'SYS_YES_NO'
      AND ML.LOOKUP_CODE = P_SEND_NOTIFICATIONS_YN;