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: 29

      SELECT
        SEGMENT1
      FROM
        PO_VENDORS
      WHERE VENDOR_ID = V_CUST_ID;

Line: 38

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

Line: 47

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

Line: 53

    V_ITEM_SELECT VARCHAR2(90);

Line: 61

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

Line: 68

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

Line: 177

      SELECT
        ORGANIZATION_CODE
      FROM
        MTL_PARAMETERS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 184

      SELECT
        NAME
      FROM
        HR_ALL_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 194

      SELECT
        ACCOUNT_NUMBER
      FROM
        HZ_CUST_ACCOUNTS
      WHERE CUST_ACCOUNT_ID = V_CUST_ID;

Line: 201

      SELECT
        SEGMENT1
      FROM
        PO_VENDORS
      WHERE VENDOR_ID = V_CUST_ID;

Line: 210

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

Line: 219

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

Line: 225

    V_ITEM_SELECT VARCHAR2(90);

Line: 233

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

Line: 240

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

Line: 325

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

Line: 330

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

Line: 367

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

Line: 384

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