APPS.WMS_WMSASNI_XMLP_PKG SQL Statements

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

Line: 38

    SELECT
      ORGANIZATION_NAME
    INTO P_ORG_NAME
    FROM
      ORG_ORGANIZATION_DEFINITIONS ORG
    WHERE ORG.ORGANIZATION_ID = ORG_ID;

Line: 82

    SELECT
      MSI.CONCATENATED_SEGMENTS
    INTO P_ITEM_DESCRIPTION
    FROM
      MTL_SYSTEM_ITEMS_KFV MSI
    WHERE MSI.ORGANIZATION_ID = ORG_ID
      AND MSI.INVENTORY_ITEM_ID = ITEM_ID;

Line: 125

    SELECT
      SUBSTR(VENDOR_NAME
            ,1
            ,240)
    INTO P_VENDOR_NAME
    FROM
      PO_VENDORS
    WHERE VENDOR_ID = VENDOR_ID1;