APPS.JA_JAINCINI_XMLP_PKG SQL Statements

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

Line: 45

    SELECT
      ' ' || LC1.MEANING || ' ',
      ' ' || LC2.MEANING || ' ',
      ' ' || LC3.MEANING || ' ',
      ' ' || LC4.MEANING
    INTO B_CRORE,B_LAKH,B_THOUSAND,B_ZERO
    FROM
      JA_LOOKUPS LC1,
      JA_LOOKUPS LC2,
      JA_LOOKUPS LC3,
      JA_LOOKUPS LC4
    WHERE LC1.LOOKUP_CODE = LV_CRORE
      AND LC1.LOOKUP_TYPE = LV_NLS_TRANS
      AND LC2.LOOKUP_CODE = LV_LAKH
      AND LC2.LOOKUP_TYPE = LV_NLS_TRANS
      AND LC3.LOOKUP_CODE = LV_THOUSAND
      AND LC3.LOOKUP_TYPE = LV_NLS_TRANS
      AND LC4.LOOKUP_CODE = LV_ZERO
      AND LC4.LOOKUP_TYPE = LV_NLS_TRANS;

Line: 103

      SELECT
        SUM(EXTENDED_AMOUNT)
      FROM
        RA_CUSTOMER_TRX_LINES_ALL
      WHERE CUSTOMER_TRX_ID = NVL(P_INVOICE_NO
         ,CUSTOMER_TRX_ID);

Line: 137

      SELECT
        CARRIER_ID
      FROM
        WSH_NEW_DELIVERIES A,
        RA_CUSTOMER_TRX_ALL B
      WHERE B.CUSTOMER_TRX_ID = P_INVOICE_NO
        AND DELIVERY_ID = TO_NUMBER(B.INTERFACE_HEADER_ATTRIBUTE3);

Line: 155

      SELECT
        CONFIRM_DATE
      FROM
        WSH_NEW_DELIVERIES A,
        RA_CUSTOMER_TRX_ALL B
      WHERE B.CUSTOMER_TRX_ID = P_INVOICE_NO
        AND DELIVERY_ID = TO_NUMBER(B.INTERFACE_HEADER_ATTRIBUTE3);

Line: 172

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

Line: 213

SELECT INSTR(TR_EC_CODE,'D')
FROM JAI_CMN_INVENTORY_ORGS
WHERE ORGANIZATION_ID = P_ORG_ID AND LOCATION_ID = P_LOC_ID;

Line: 231

SELECT INSTR(TR_EC_CODE,'D')
FROM JAI_CMN_INVENTORY_ORGS
WHERE ORGANIZATION_ID =P_ORG_ID AND LOCATION_ID =P_LOC_ID;

Line: 250

SELECT INSTR(TR_EC_CODE,'D')
FROM JAI_CMN_INVENTORY_ORGS
WHERE ORGANIZATION_ID =P_ORG_ID AND LOCATION_ID = P_LOC_ID;