APPS.INV_INVPOPSR_XMLP_PKG SQL Statements

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

Line: 137

      INSERT INTO MTL_PO_PACKSLIPS
        (PACKSLIP_NUMBER
        ,PACKSLIP_DATE
        ,TRANSACTION_ID)
      VALUES   (CF_DOC_NUM
        ,SYSDATE
        ,TRANS_ID);

Line: 154

      SELECT
        MTL_PO_PACKSLIPS_S.NEXTVAL
      INTO L_NEW_PACKSLIP_NUM
      FROM
        DUAL;

Line: 193

      SELECT
        ZR.REGISTRATION_NUMBER
      INTO L_DEF_TAX_REG_NO
      FROM
        ZX_PARTY_TAX_PROFILE ZPTP,
        ZX_REGISTRATIONS ZR,
        XLE_ASSOCIATIONS_V XAV
      WHERE ZPTP.PARTY_TAX_PROFILE_ID = ZR.PARTY_TAX_PROFILE_ID
        AND ZR.DEFAULT_REGISTRATION_FLAG = 'Y'
        AND ZPTP.PARTY_ID = XAV.LEGAL_PARTY_ID
        AND ZPTP.PARTY_TYPE_CODE = 'LEGAL_ESTABLISHMENT'
        AND XAV.ENTITY_ID = P_ORG_ID
        AND XAV.ENTITY_TYPE = 'INVENTORY_ORGANIZATION';

Line: 209

        SELECT
          ZR.REGISTRATION_NUMBER
        INTO L_DEF_TAX_REG_NO
        FROM
          XLE_ETB_PROFILES XEP,
          ZX_PARTY_TAX_PROFILE ZPTP,
          ZX_REGISTRATIONS ZR,
          ORG_ORGANIZATION_DEFINITIONS OOD
        WHERE ZPTP.PARTY_TAX_PROFILE_ID = ZR.PARTY_TAX_PROFILE_ID
          AND ZR.DEFAULT_REGISTRATION_FLAG = 'Y'
          AND ZPTP.PARTY_ID = XEP.PARTY_ID
          AND ZPTP.PARTY_TYPE_CODE = 'LEGAL_ESTABLISHMENT'
          AND XEP.LEGAL_ENTITY_ID = OOD.LEGAL_ENTITY
          AND XEP.MAIN_ESTABLISHMENT_FLAG = 'Y'
          AND OOD.ORGANIZATION_ID = P_ORG_ID;