APPS.JA_JAIN23C1_XMLP_PKG SQL Statements

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

Line: 66

      SELECT
        QUANTITY_RECEIVED
      INTO RCVD_QTY
      FROM
        JAI_CMN_RG_23AC_I_TRXS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND LOCATION_ID = P_LOCATION_ID
        AND SLNO = SLNO_1
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
        AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 82

        SELECT
          OTH_RECEIPT_QUANTITY
        INTO RCVD_QTY
        FROM
          JAI_CMN_RG_23AC_I_TRXS
        WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
          AND LOCATION_ID = P_LOCATION_ID
          AND SLNO = SLNO_1
          AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
          AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 109

      SELECT
        QUANTITY_RECEIVED
      INTO RCVD_QTY
      FROM
        JAI_CMN_RG_23AC_I_TRXS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND LOCATION_ID = P_LOCATION_ID
        AND SLNO = SLNO_1
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
        AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 125

        SELECT
          EXCISE_INVOICE_NO
        INTO INV_ID
        FROM
          JAI_CMN_RG_23AC_I_TRXS
        WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
          AND LOCATION_ID = P_LOCATION_ID
          AND SLNO = SLNO_1
          AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
          AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 141

        SELECT
          OTH_RECEIPT_QUANTITY
        INTO RCVD_QTY
        FROM
          JAI_CMN_RG_23AC_I_TRXS
        WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
          AND LOCATION_ID = P_LOCATION_ID
          AND SLNO = SLNO_1
          AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
          AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 157

          SELECT
            OTH_RECEIPT_ID_REF
          INTO INV_ID
          FROM
            JAI_CMN_RG_23AC_I_TRXS
          WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
            AND LOCATION_ID = P_LOCATION_ID
            AND SLNO = SLNO_1
            AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
            AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 182

      SELECT
        QUANTITY_RECEIVED
      INTO RCVD_QTY
      FROM
        JAI_CMN_RG_23AC_I_TRXS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND LOCATION_ID = P_LOCATION_ID
        AND SLNO = SLNO_1
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
        AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 198

        SELECT
          EXCISE_INVOICE_DATE
        INTO INV_DT
        FROM
          JAI_CMN_RG_23AC_I_TRXS
        WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
          AND LOCATION_ID = P_LOCATION_ID
          AND SLNO = SLNO_1
          AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
          AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 214

        SELECT
          OTH_RECEIPT_QUANTITY
        INTO RCVD_QTY
        FROM
          JAI_CMN_RG_23AC_I_TRXS
        WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
          AND LOCATION_ID = P_LOCATION_ID
          AND SLNO = SLNO_1
          AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
          AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 230

          SELECT
            OTH_RECEIPT_DATE
          INTO INV_DT
          FROM
            JAI_CMN_RG_23AC_I_TRXS
          WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
            AND LOCATION_ID = P_LOCATION_ID
            AND SLNO = SLNO_1
            AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
            AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 258

      SELECT
        NVL(BASIC_ED
           ,0),
        NVL(ADDITIONAL_ED
           ,0),
        NVL(OTHER_ED
           ,0),
        NVL(ADDITIONAL_CVD
           ,0)
      INTO B_ED,A_ED,O_ED,LN_ADD_CVD
      FROM
        JAI_CMN_RG_23AC_I_TRXS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND LOCATION_ID = P_LOCATION_ID
        AND SLNO = SLNO_1
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
        AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 283

      SELECT
        SALES_INVOICE_NO
      INTO S_INV_ID
      FROM
        JAI_CMN_RG_23AC_I_TRXS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND LOCATION_ID = P_LOCATION_ID
        AND SLNO = SLNO_1
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
        AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 308

      SELECT
        NVL(BASIC_ED
           ,0),
        NVL(ADDITIONAL_ED
           ,0),
        NVL(OTHER_ED
           ,0),
        NVL(ADDITIONAL_CVD
           ,0)
      INTO B_ED,A_ED,O_ED,LN_ADD_CVD
      FROM
        JAI_CMN_RG_23AC_I_TRXS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND LOCATION_ID = P_LOCATION_ID
        AND SLNO = SLNO_1
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
        AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 333

      SELECT
        SALES_INVOICE_DATE
      INTO S_INV_DT
      FROM
        JAI_CMN_RG_23AC_I_TRXS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND LOCATION_ID = P_LOCATION_ID
        AND SLNO = SLNO_1
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
        AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 358

      SELECT
        ABS(QUANTITY_RECEIVED)
      FROM
        JAI_CMN_RG_23AC_I_TRXS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND LOCATION_ID = P_LOCATION_ID
        AND SLNO = SLNO_1
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
        AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 369

      SELECT
        NVL(BASIC_ED
           ,0),
        NVL(ADDITIONAL_ED
           ,0),
        NVL(OTHER_ED
           ,0),
        NVL(ADDITIONAL_CVD
           ,0)
      INTO B_ED,A_ED,O_ED,LN_ADD_CVD
      FROM
        JAI_CMN_RG_23AC_I_TRXS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND LOCATION_ID = P_LOCATION_ID
        AND SLNO = SLNO_1
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
        AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 394

      SELECT
        SALES_INVOICE_QUANTITY
      INTO S_INV_QTY
      FROM
        JAI_CMN_RG_23AC_I_TRXS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND LOCATION_ID = P_LOCATION_ID
        AND SLNO = SLNO_1
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1
        AND TRUNC(TRANSACTION_DATE) = TRUNC(TRANSACTION_DATE_1);

Line: 427

      SELECT
        ITEM_TARIFF
      INTO I_TARRIF
      FROM
        JAI_INV_ITM_SETUPS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1;

Line: 444

      SELECT
        ITEM_FOLIO
      INTO I_FOLIO
      FROM
        JAI_INV_ITM_SETUPS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_1;

Line: 459

      SELECT
        CONCURRENT_PROGRAM_ID,
        NVL(ENABLE_TRACE
           ,'N')
      FROM
        FND_CONCURRENT_REQUESTS
      WHERE REQUEST_ID = P_REQUEST_ID;

Line: 498

      SELECT
        SUBSTR(HRU.NAME
              ,1
              ,20) || ' ' || SUBSTR(HRL.ADDRESS_LINE_1
              ,1
              ,12) || ' ' || SUBSTR(HRL.ADDRESS_LINE_2
              ,1
              ,8) || ' ' || SUBSTR(HRL.ADDRESS_LINE_3
              ,1
              ,7) || ' ' || SUBSTR(HRL.TOWN_OR_CITY
              ,1
              ,15) || ' ' || SUBSTR(HRL.POSTAL_CODE
              ,1
              ,10) || ' ' || SUBSTR(HRL.COUNTRY
              ,1
              ,10)
      FROM
        HR_LOCATIONS HRL,
        RCV_TRANSACTIONS RCVT,
        RCV_SHIPMENT_HEADERS RCVSH,
        JAI_OM_WSH_LINES_ALL JSPL,
        HR_ALL_ORGANIZATION_UNITS HRU
      WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
        AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION
        AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
        AND RCVSH.RECEIPT_SOURCE_CODE = LCV_INT_ORD
        AND RCVSH.SHIPMENT_NUM = JSPL.DELIVERY_ID
        AND HRL.LOCATION_ID = JSPL.LOCATION_ID
        AND HRU.ORGANIZATION_ID = RCVSH.ORGANIZATION_ID;

Line: 528

      SELECT
        SUBSTR(HRU.NAME
              ,1
              ,20) || ' ' || SUBSTR(HRL.ADDRESS_LINE_1
              ,1
              ,12) || ' ' || SUBSTR(HRL.ADDRESS_LINE_2
              ,1
              ,8) || ' ' || SUBSTR(HRL.ADDRESS_LINE_3
              ,1
              ,7) || ' ' || SUBSTR(HRL.TOWN_OR_CITY
              ,1
              ,15) || ' ' || SUBSTR(HRL.POSTAL_CODE
              ,1
              ,10) || ' ' || SUBSTR(HRL.COUNTRY
              ,1
              ,10)
      FROM
        HR_ALL_ORGANIZATION_UNITS HRU,
        HR_LOCATIONS HRL
      WHERE HRU.ORGANIZATION_ID = ABS(VENDOR_ID)
        AND HRL.LOCATION_ID = ABS(VENDOR_SITE_ID)
        AND HRU.LOCATION_ID = HRL.LOCATION_ID;

Line: 580

      SELECT
        EXCISE_DUTY_RANGE
      FROM
        JAI_CMN_INVENTORY_ORGS
      WHERE ORGANIZATION_ID = ABS(VENDOR_ID)
        AND LOCATION_ID = ABS(VENDOR_SITE_ID);

Line: 587

      SELECT
        DISTINCT
        JU.EXCISE_DUTY_RANGE
      FROM
        RCV_TRANSACTIONS RCVT,
        RCV_SHIPMENT_HEADERS RCVSH,
        JAI_CMN_INVENTORY_ORGS JU
      WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
        AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION
        AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
        AND RCVSH.RECEIPT_SOURCE_CODE = LV_INT_ORD
        AND RCVSH.ORGANIZATION_ID = JU.ORGANIZATION_ID;

Line: 624

      SELECT
        EXCISE_DUTY_DIVISION
      FROM
        JAI_CMN_INVENTORY_ORGS
      WHERE ORGANIZATION_ID = ABS(VENDOR_ID)
        AND LOCATION_ID = ABS(VENDOR_SITE_ID);

Line: 631

      SELECT
        DISTINCT
        JU.EXCISE_DUTY_DIVISION
      FROM
        RCV_TRANSACTIONS RCVT,
        RCV_SHIPMENT_HEADERS RCVSH,
        JAI_CMN_INVENTORY_ORGS JU
      WHERE RCVT.TRANSACTION_ID = P_RECEIPT_ID
        AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION
        AND RCVT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
        AND RCVSH.RECEIPT_SOURCE_CODE = LV_INT_ORD
        AND RCVSH.ORGANIZATION_ID = JU.ORGANIZATION_ID;