DBA Data[Home] [Help]

APPS.GMF_GET_PRODUCT_INFO SQL Statements

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

Line: 4

  SELECT PR.PRODUCT_GROUP_ID,
         PR.PRODUCT_GROUP_NAME,
         PR.RELEASE_NAME,
         -99,
         PR.PRODUCT_GROUP_TYPE,
         PR.ARGUMENT1,
         PR.MULTI_ORG_FLAG,
         PR.MULTI_LINGUAL_FLAG,
         '',
         PR.LAST_UPDATE_DATE,
         PR.LAST_UPDATED_BY,
         PR.CREATION_DATE,
         PR.CREATED_BY
  FROM   FND_PRODUCT_GROUPS PR;
Line: 30

          LAST_UPDATE_DATE               OUT    NOCOPY DATE,
          LAST_UPDATED_BY                OUT    NOCOPY NUMBER,
          ROW_TO_FETCH                   IN OUT NOCOPY NUMBER,
          ERROR_STATUS                   OUT    NOCOPY NUMBER)   IS
/*    CREATEDBY   NUMBER;*/
Line: 46

            LAST_UPDATE_DATE,               LAST_UPDATED_BY,
            CREATION_DATE,                  CREATED_BY;
Line: 53

/*        LAST_UPDATED_BY := PKG_FND_GET_USERS.FND_GET_USERS(MODIFIEDBY);*/