APPS.GMI_PIR05_XMLP_PKG SQL Statements

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

Line: 6

    SELECT
      WHSE_NAME
    INTO WHSE_DESC
    FROM
      IC_WHSE_MST
    WHERE WHSE_CODE = WHSE;

Line: 20

      SELECT
        CYCLE_NO
      FROM
        IC_CYCL_HDR
      WHERE CYCLE_ID = CYCLE_ID_1;

Line: 26

      SELECT
        MIN(COUNT_NO)
      FROM
        IC_CYCL_DTL
      WHERE CYCLE_ID = CYCLE_ID_1;

Line: 32

      SELECT
        count(*)
      FROM
        IC_PHYS_CNT
      WHERE IC_PHYS_CNT.WHSE_CODE = WHSE
        AND IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1
        AND IC_PHYS_CNT.COUNT_NO >= FROM_COUNT
        AND IC_PHYS_CNT.COUNT_NO <= TO_COUNT
        AND IC_PHYS_CNT.CREATION_DATE <> IC_PHYS_CNT.LAST_UPDATE_DATE;

Line: 57

    SELECT
      PRINT_FORMAT
    INTO PRN_FOR
    FROM
      IC_CYCL_HDR
    WHERE IC_CYCL_HDR.WHSE_CODE = WHSE
      AND IC_CYCL_HDR.CYCLE_ID = CYCLE_ID_1;

Line: 96

   SELECT MIN(COUNT_NO)
   INTO   X_MIN_COUNT
   FROM   IC_CYCL_DTL
   WHERE  CYCLE_ID = CYCLE_ID_1
   AND    rownum=1;

Line: 113

     SELECT   count(*)
     INTO     COUNT2
     FROM     IC_PHYS_CNT
     WHERE IC_PHYS_CNT.WHSE_CODE = WHSE
     AND   IC_PHYS_CNT.CYCLE_ID = CYCLE_ID_1
     AND   IC_PHYS_CNT.COUNT_NO >= FROM_COUNT
     AND   IC_PHYS_CNT.COUNT_NO <= TO_COUNT
     AND   IC_PHYS_CNT.CREATION_DATE <> IC_PHYS_CNT.LAST_UPDATE_DATE
     AND   rownum=1;

Line: 141

    SELECT
      CYCLE_NO,
      CYCLE_SOURCE
    INTO CYCLE_NO,PHYSICAL_OR_CYCLE
    FROM
      IC_CYCL_HDR
    WHERE CYCLE_ID = CYCLE_ID_1;