APPS.WSH_WSHRDOPN_XMLP_PKG SQL Statements

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

Line: 5

      SELECT
        ORGANIZATION_CODE
      FROM
        MTL_PARAMETERS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 12

      SELECT
        NAME
      FROM
        HR_ALL_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 22

      SELECT
        ACCOUNT_NUMBER
      FROM
        HZ_CUST_ACCOUNTS
      WHERE CUST_ACCOUNT_ID = V_CUST_ID;

Line: 30

      SELECT
        MEANING
      FROM
        WSH_LOOKUPS
      WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
        AND LOOKUP_CODE = P_ITEM_DISPLAY;

Line: 39

      SELECT
        CONCATENATED_SEGMENTS
      FROM
        MTL_SYSTEM_ITEMS_KFV
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND INVENTORY_ITEM_ID = V_ITEM_ID;

Line: 45

    V_ITEM_SELECT VARCHAR2(90);

Line: 53

      SELECT
        WPB.NAME
      FROM
        WSH_PICKING_BATCHES WPB
      WHERE WPB.BATCH_ID = V_BATCH_ID;

Line: 60

      SELECT
        MEANING
      FROM
        WSH_LOOKUPS
      WHERE LOOKUP_TYPE = 'OPN_SORT_BY'
        AND LOOKUP_CODE = P_SORT_BY;

Line: 158

      SELECT
        ORGANIZATION_CODE
      FROM
        MTL_PARAMETERS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 165

      SELECT
        NAME
      FROM
        HR_ALL_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 175

      SELECT
        ACCOUNT_NUMBER
      FROM
        HZ_CUST_ACCOUNTS
      WHERE CUST_ACCOUNT_ID = V_CUST_ID;

Line: 183

      SELECT
        MEANING
      FROM
        WSH_LOOKUPS
      WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
        AND LOOKUP_CODE = P_ITEM_DISPLAY;

Line: 192

      SELECT
        CONCATENATED_SEGMENTS
      FROM
        MTL_SYSTEM_ITEMS_KFV
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND INVENTORY_ITEM_ID = V_ITEM_ID;

Line: 198

    V_ITEM_SELECT VARCHAR2(90);

Line: 206

      SELECT
        WPB.NAME
      FROM
        WSH_PICKING_BATCHES WPB
      WHERE WPB.BATCH_ID = V_BATCH_ID;

Line: 213

      SELECT
        MEANING
      FROM
        WSH_LOOKUPS
      WHERE LOOKUP_TYPE = 'OPN_SORT_BY'
        AND LOOKUP_CODE = P_SORT_BY;

Line: 285

      V_ITEM_SELECT := ' and (wnd.name, wnd.delivery_id) IN (select wnd2.name, wnd2.delivery_id ';

Line: 290

      V_ITEM_TOTAL := V_ITEM_SELECT || V_ITEM_FROM || V_ITEM_WHERE || V_ITEM_QUALIFY;

Line: 327

      SELECT
        MEANING
      INTO L_MEANING
      FROM
        OE_LOOKUPS
      WHERE LOOKUP_TYPE = 'SHIPMENT_PRIORITY'
        AND LOOKUP_CODE = SHIPPRI;

Line: 344

      SELECT
        MEANING
      INTO LPN
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_CODE = 'Y'
        AND LOOKUP_TYPE = 'YES_NO';