APPS.JA_JAINVAR_XMLP_PKG SQL Statements

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

Line: 14

      SELECT
        INTERFACE_LINE_ATTRIBUTE7
      FROM
        RA_CUSTOMER_TRX_LINES_ALL
      WHERE CUSTOMER_TRX_ID = CF_1FORMULA.CUSTOMER_TRX_ID
        AND CUSTOMER_TRX_LINE_ID = CF_1FORMULA.CUSTOMER_TRX_LINE_ID
        AND INTERFACE_LINE_ATTRIBUTE7 IS NOT NULL;

Line: 22

      SELECT
        INVENTORY_ITEM_ID
      FROM
        SO_PICKING_LINES_ALL
      WHERE PICKING_LINE_ID = V_PICKING_LINE_ID;

Line: 28

      SELECT
        TO_CHAR(A.INVENTORY_ITEM_ID) || '/' || TO_CHAR(A.SLNO)
      FROM
        JAI_CMN_RG_23AC_II_TRXS A
      WHERE A.EXCISE_INVOICE_NO = EXCISE_INVOICE_NO
        AND A.INVENTORY_ITEM_ID = V_INVENTORY_ITEM_ID
        AND A.DR_BASIC_ED = CF_4;

Line: 36

      SELECT
        TO_CHAR(A.INVENTORY_ITEM_ID) || '/' || TO_CHAR(A.SLNO)
      FROM
        JAI_CMN_RG_PLA_TRXS A
      WHERE A.EXCISE_INVOICE_NO = EXCISE_INVOICE_NO
        AND A.INVENTORY_ITEM_ID = V_INVENTORY_ITEM_ID;

Line: 84

      SELECT
        A.FUNC_TAX_AMOUNT FUNC_AMT,
        B.TAX_TYPE T_TYPE
      FROM
        JAI_AR_TRX_TAX_LINES A,
        JAI_CMN_TAXES_ALL B
      WHERE LINK_TO_CUST_TRX_LINE_ID = CF_4FORMULA.CUSTOMER_TRX_LINE_ID
        AND A.TAX_ID = B.TAX_ID
        AND B.TAX_TYPE = CP_EXCISE
      ORDER BY
        1;

Line: 109

      SELECT
        DR_ADDITIONAL_ED
      FROM
        JAI_CMN_RG_23AC_II_TRXS A
      WHERE A.EXCISE_INVOICE_NO = CF_5FORMULA.EXCISE_INVOICE_NO
        AND A.INVENTORY_ITEM_ID = CF_5FORMULA.INVENTORY_ITEM_ID;

Line: 116

      SELECT
        DR_ADDITIONAL_ED
      FROM
        JAI_CMN_RG_PLA_TRXS A
      WHERE A.EXCISE_INVOICE_NO = CF_5FORMULA.EXCISE_INVOICE_NO
        AND A.INVENTORY_ITEM_ID = CF_5FORMULA.INVENTORY_ITEM_ID;

Line: 143

      SELECT
        DR_OTHER_ED
      FROM
        JAI_CMN_RG_23AC_II_TRXS A
      WHERE A.EXCISE_INVOICE_NO = CF_6FORMULA.EXCISE_INVOICE_NO
        AND A.INVENTORY_ITEM_ID = CF_6FORMULA.INVENTORY_ITEM_ID;

Line: 150

      SELECT
        DR_OTHER_ED
      FROM
        JAI_CMN_RG_PLA_TRXS A
      WHERE A.EXCISE_INVOICE_NO = CF_6FORMULA.EXCISE_INVOICE_NO
        AND A.INVENTORY_ITEM_ID = CF_6FORMULA.INVENTORY_ITEM_ID;

Line: 175

      SELECT
        A.FUNC_TAX_AMOUNT FUNC_AMT,
        B.TAX_TYPE T_TYPE
      FROM
        JAI_AR_TRX_TAX_LINES A,
        JAI_CMN_TAXES_ALL B
      WHERE LINK_TO_CUST_TRX_LINE_ID = CF_7FORMULA.CUSTOMER_TRX_LINE_ID
        AND A.TAX_ID = B.TAX_ID
        AND B.TAX_TYPE = CP_TAX_TYPE
      ORDER BY
        1;

Line: 198

      SELECT
        A.FUNC_TAX_AMOUNT FUNC_AMT,
        B.TAX_TYPE T_TYPE
      FROM
        JAI_AR_TRX_TAX_LINES A,
        JAI_CMN_TAXES_ALL B
      WHERE LINK_TO_CUST_TRX_LINE_ID = CF_8FORMULA.CUSTOMER_TRX_LINE_ID
        AND A.TAX_ID = B.TAX_ID
        AND B.TAX_TYPE = CP_TAX_TYPE
      ORDER BY
        1;

Line: 221

      SELECT
        A.FUNC_TAX_AMOUNT FUNC_AMT,
        B.TAX_TYPE T_TYPE
      FROM
        JAI_AR_TRX_TAX_LINES A,
        JAI_CMN_TAXES_ALL B
      WHERE LINK_TO_CUST_TRX_LINE_ID = CF_9FORMULA.CUSTOMER_TRX_LINE_ID
        AND A.TAX_ID = B.TAX_ID
        AND B.TAX_TYPE = CP_TAX_TYPE
      ORDER BY
        1;

Line: 244

      SELECT
        A.FUNC_TAX_AMOUNT FUNC_AMT,
        B.TAX_TYPE T_TYPE
      FROM
        JAI_AR_TRX_TAX_LINES A,
        JAI_CMN_TAXES_ALL B
      WHERE LINK_TO_CUST_TRX_LINE_ID = CF_10FORMULA.CUSTOMER_TRX_LINE_ID
        AND A.TAX_ID = B.TAX_ID
        AND B.TAX_TYPE = CP_TAX_TYPE
      ORDER BY
        1;

Line: 267

      SELECT
        A.FUNC_TAX_AMOUNT FUNC_AMT,
        B.TAX_TYPE T_TYPE
      FROM
        JAI_AR_TRX_TAX_LINES A,
        JAI_CMN_TAXES_ALL B
      WHERE LINK_TO_CUST_TRX_LINE_ID = CF_11FORMULA.CUSTOMER_TRX_LINE_ID
        AND A.TAX_ID = B.TAX_ID
        AND B.TAX_TYPE = CP_TAX_TYPE
      ORDER BY
        1;

Line: 290

      SELECT
        A.FUNC_TAX_AMOUNT FUNC_AMT,
        B.TAX_TYPE T_TYPE
      FROM
        JAI_AR_TRX_TAX_LINES A,
        JAI_CMN_TAXES_ALL B
      WHERE LINK_TO_CUST_TRX_LINE_ID = CF_12FORMULA.CUSTOMER_TRX_LINE_ID
        AND A.TAX_ID = B.TAX_ID
        AND B.TAX_TYPE = CP_TAX_TYPE
      ORDER BY
        1;

Line: 313

      SELECT
        A.FUNC_TAX_AMOUNT FUNC_AMT,
        B.TAX_TYPE T_TYPE
      FROM
        JAI_AR_TRX_TAX_LINES A,
        JAI_CMN_TAXES_ALL B
      WHERE LINK_TO_CUST_TRX_LINE_ID = CF_13FORMULA.CUSTOMER_TRX_LINE_ID
        AND A.TAX_ID = B.TAX_ID
        AND B.TAX_TYPE = CP_TAX_TYPE
      ORDER BY
        1;

Line: 336

      SELECT
        A.FUNC_TAX_AMOUNT FUNC_AMT,
        B.TAX_TYPE T_TYPE
      FROM
        JAI_AR_TRX_TAX_LINES A,
        JAI_CMN_TAXES_ALL B
      WHERE LINK_TO_CUST_TRX_LINE_ID = CF_14FORMULA.CUSTOMER_TRX_LINE_ID
        AND A.TAX_ID = B.TAX_ID
        AND B.TAX_TYPE = CP_TAX_TYPE
      ORDER BY
        1;

Line: 359

      SELECT
        A.FUNC_TAX_AMOUNT FUNC_AMT,
        B.TAX_TYPE T_TYPE
      FROM
        JAI_AR_TRX_TAX_LINES A,
        JAI_CMN_TAXES_ALL B
      WHERE LINK_TO_CUST_TRX_LINE_ID = CF_15FORMULA.CUSTOMER_TRX_LINE_ID
        AND A.TAX_ID = B.TAX_ID
        AND B.TAX_TYPE = CP_TAX_TYPE
      ORDER BY
        1;

Line: 382

      SELECT
        A.FUNC_TAX_AMOUNT FUNC_AMT,
        B.TAX_TYPE T_TYPE
      FROM
        JAI_AR_TRX_TAX_LINES A,
        JAI_CMN_TAXES_ALL B
      WHERE LINK_TO_CUST_TRX_LINE_ID = CF_16FORMULA.CUSTOMER_TRX_LINE_ID
        AND A.TAX_ID = B.TAX_ID
        AND B.TAX_TYPE = CP_TAX_TYPE
      ORDER BY
        1;

Line: 414

      SELECT
        A.SLNO
      FROM
        JAI_CMN_RG_23AC_II_TRXS A
      WHERE A.EXCISE_INVOICE_NO = CF_17FORMULA.EXCISE_INVOICE_NO
        AND A.INVENTORY_ITEM_ID = CF_17FORMULA.V_INVENTORY_ITEM_ID
        AND A.DR_BASIC_ED = CF_4;

Line: 422

      SELECT
        A.SLNO
      FROM
        JAI_CMN_RG_PLA_TRXS A
      WHERE A.EXCISE_INVOICE_NO = CF_17FORMULA.EXCISE_INVOICE_NO
        AND A.INVENTORY_ITEM_ID = CF_17FORMULA.V_INVENTORY_ITEM_ID;

Line: 429

      SELECT
        INTERFACE_LINE_ATTRIBUTE7
      FROM
        RA_CUSTOMER_TRX_LINES_ALL
      WHERE CUSTOMER_TRX_ID = CF_17FORMULA.CUSTOMER_TRX_ID
        AND CUSTOMER_TRX_LINE_ID = CF_17FORMULA.CUSTOMER_TRX_LINE_ID
        AND INTERFACE_LINE_ATTRIBUTE7 IS NOT NULL;

Line: 437

      SELECT
        INVENTORY_ITEM_ID
      FROM
        SO_PICKING_LINES_ALL
      WHERE PICKING_LINE_ID = V_PICKING_LINE_ID;

Line: 472

      SELECT
        INVOICE_CURRENCY_CODE
      FROM
        RA_CUSTOMER_TRX_ALL
      WHERE CUSTOMER_TRX_ID = CUSTOMER_TRX_ID1;

Line: 488

      SELECT
        CURRENCY_CODE
      FROM
        GL_SETS_OF_BOOKS
      WHERE SET_OF_BOOKS_ID in (
        SELECT
          SET_OF_BOOKS_ID
        FROM
          RA_CUSTOMER_TRX_ALL
        WHERE CUSTOMER_TRX_ID = CUSTOMER_TRX_ID1 );

Line: 514

      SELECT
        INTERFACE_LINE_ATTRIBUTE7
      FROM
        RA_CUSTOMER_TRX_LINES_ALL
      WHERE CUSTOMER_TRX_ID = CF_20FORMULA.CUSTOMER_TRX_ID
        AND CUSTOMER_TRX_LINE_ID = CF_20FORMULA.CUSTOMER_TRX_LINE_ID
        AND INTERFACE_LINE_ATTRIBUTE7 IS NOT NULL;

Line: 522

      SELECT
        SELLING_PRICE
      FROM
        JAI_OM_WSH_LINES_ALL
      WHERE PICKING_LINE_ID = V_PICKING_LINE_ID;

Line: 563

      SELECT
        SET_OF_BOOKS_ID,
        INVOICE_CURRENCY_CODE,
        EXCHANGE_RATE_TYPE,
        NVL(EXCHANGE_DATE
           ,TRX_DATE) EXCHANGE_DATE,
        EXCHANGE_RATE
      FROM
        RA_CUSTOMER_TRX_ALL
      WHERE CUSTOMER_TRX_ID = CUSTOMER_TRX_ID1;

Line: 597

      SELECT
        SET_OF_BOOKS_ID,
        INVOICE_CURRENCY_CODE,
        EXCHANGE_RATE_TYPE,
        NVL(EXCHANGE_DATE
           ,TRX_DATE) EXCHANGE_DATE,
        EXCHANGE_RATE
      FROM
        RA_CUSTOMER_TRX_ALL
      WHERE CUSTOMER_TRX_ID = CUSTOMER_TRX_ID1;

Line: 642

      SELECT
        INTERFACE_LINE_ATTRIBUTE7
      FROM
        RA_CUSTOMER_TRX_LINES_ALL
      WHERE CUSTOMER_TRX_ID = CONV_ASSESSABLEFORMULA.CUSTOMER_TRX_ID
        AND CUSTOMER_TRX_LINE_ID = CONV_ASSESSABLEFORMULA.CUSTOMER_TRX_LINE_ID
        AND INTERFACE_LINE_ATTRIBUTE7 IS NOT NULL;

Line: 650

      SELECT
        ASSESSABLE_VALUE
      FROM
        JAI_OM_WSH_LINES_ALL
      WHERE PICKING_LINE_ID = V_PICKING_LINE_ID;

Line: 656

      SELECT
        SET_OF_BOOKS_ID,
        INVOICE_CURRENCY_CODE,
        EXCHANGE_RATE_TYPE,
        NVL(EXCHANGE_DATE
           ,TRX_DATE) EXCHANGE_DATE,
        EXCHANGE_RATE
      FROM
        RA_CUSTOMER_TRX_ALL
      WHERE CUSTOMER_TRX_ID = CUSTOMER_TRX_ID1;

Line: 703

      SELECT
        TAX_RATE
      FROM
        JAI_AR_TRX_TAX_LINES
      WHERE LINK_TO_CUST_TRX_LINE_ID = BASIC_RATEFORMULA.CUSTOMER_TRX_LINE_ID
        AND TAX_ID IN (
        SELECT
          TAX_ID
        FROM
          JAI_CMN_TAXES_ALL
        WHERE TAX_TYPE LIKE CP_TAX_TYPE );

Line: 733

      SELECT
        TAX_RATE
      FROM
        JAI_AR_TRX_TAX_LINES
      WHERE LINK_TO_CUST_TRX_LINE_ID = SPECIAL_RATEFORMULA.CUSTOMER_TRX_LINE_ID
        AND TAX_ID IN (
        SELECT
          TAX_ID
        FROM
          JAI_CMN_TAXES_ALL
        WHERE TAX_TYPE LIKE CP_TAX_TYPE );

Line: 763

      SELECT
        TAX_RATE
      FROM
        JAI_AR_TRX_TAX_LINES
      WHERE LINK_TO_CUST_TRX_LINE_ID = ADDL_RATEFORMULA.CUSTOMER_TRX_LINE_ID
        AND TAX_ID IN (
        SELECT
          TAX_ID
        FROM
          JAI_CMN_TAXES_ALL
        WHERE TAX_TYPE LIKE CP_TAX_TYPE );

Line: 794

      SELECT
        SEGMENT1
      FROM
        MTL_SYSTEM_ITEMS
      WHERE INVENTORY_ITEM_ID = ITEM_CODEFORMULA.ITEM_CODE_ID
        AND ORGANIZATION_ID = ITEM_CODEFORMULA.ORGANIZATION_ID;

Line: 816

      SELECT
        INTERFACE_LINE_ATTRIBUTE7
      FROM
        RA_CUSTOMER_TRX_LINES_ALL
      WHERE CUSTOMER_TRX_ID = ITEM_CODE_IDFORMULA.CUSTOMER_TRX_ID
        AND CUSTOMER_TRX_LINE_ID = ITEM_CODE_IDFORMULA.CUSTOMER_TRX_LINE_ID
        AND INTERFACE_LINE_ATTRIBUTE7 IS NOT NULL;

Line: 824

      SELECT
        INVENTORY_ITEM_ID
      FROM
        JAI_OM_WSH_LINES_ALL
      WHERE PICKING_LINE_ID = V_PICKING_LINE_ID;

Line: 854

      SELECT
        MODVAT_REVERSE_PERCENT
      FROM
        JAI_CMN_INVENTORY_ORGS
      WHERE ORGANIZATION_ID = CF_24FORMULA.ORGANIZATION_ID
        AND NVL(LOCATION_ID
         ,0) = NVL(LOCATION_ID
         ,0);

Line: 863

      SELECT
        A.TAX_RATE,
        B.ROUNDING_FACTOR
      FROM
        JAI_AR_TRX_TAX_LINES A,
        JAI_CMN_TAXES_ALL B
      WHERE A.TAX_ID = B.TAX_ID
        AND A.LINK_TO_CUST_TRX_LINE_ID = CF_24FORMULA.CUSTOMER_TRX_LINE_ID
        AND B.TAX_TYPE = CP_TAX_TYPE;

Line: 873

      SELECT
        ITEM_CLASS
      FROM
        JAI_INV_ITM_SETUPS
      WHERE INVENTORY_ITEM_ID = CF_24FORMULA.INVENTORY_ITEM_ID
        AND ORGANIZATION_ID = CF_24FORMULA.ORGANIZATION_ID;

Line: 915

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

Line: 962

SELECT COUNT(*)
FROM JAI_AR_TRX_LINES
WHERE CUSTOMER_TRX_ID = CUSTOMER_TRX_ID1
AND EXCISE_EXEMPT_TYPE IN (LV_CT2, LV_EXCISE_EXEMPT_CERT, LV_CRT2_OTH, LV_EXCISE_EXEMPT_OTH) ;