APPS.JA_CN_CUSTOM_SOURCES SQL Statements

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

Line: 63

    SELECT 'Refund'
      INTO l_refund_item
      FROM AP_INVOICES_ALL aia
     WHERE aia.INVOICE_ID = P_INVOICE_ID
       and aia.PAY_PROC_TRXN_TYPE_CODE='AR_CUSTOMER_REFUND'
       and aia.INVOICE_TYPE_LOOKUP_CODE = 'PAYMENT REQUEST';

Line: 132

        SELECT GLOBAL_ATTRIBUTE1
        INTO GDF_ITEM
        FROM AP_INVOICE_DISTRIBUTIONS_ALL
        WHERE INVOICE_DISTRIBUTION_ID=P_INVOICE_DISTRIBUTION_ID;

Line: 140

          SELECT GLOBAL_ATTRIBUTE1
          INTO GDF_ITEM
          FROM AP_INVOICES_ALL
          WHERE INVOICE_ID=P_INVOICE_ID;

Line: 182

  FUNCTION MASTER_ITEM_UPDATE(P_INVOICE_ID                  IN NUMBER,
                       P_INVOICE_DISTRIBUTION_ID     IN  NUMBER)
    RETURN VARCHAR2 IS
    MASTER_ITEM              VARCHAR(100):=null;

Line: 214

        SELECT INVOICE_LINE_NUMBER,INVOICE_ID
        INTO L_INVOICE_LINE_NUMBER,L_INVOICE_ID
        FROM AP_INVOICE_DISTRIBUTIONS_ALL
        WHERE INVOICE_DISTRIBUTION_ID=P_INVOICE_DISTRIBUTION_ID ;

Line: 222

    SELECT MC.CONCATENATED_SEGMENTS
       INTO MASTER_ITEM
       FROM MTL_CATEGORIES_B_KFV MC
       WHERE CATEGORY_ID IN(
           SELECT CATEGORY_ID
           FROM MTL_ITEM_CATEGORIES MIC
           WHERE MIC.CATEGORY_SET_ID IN (
                  SELECT CATEGORY_SET_ID
                  FROM MTL_CATEGORY_SETS_TL MCST
                  WHERE MCST.LANGUAGE = USERENV('LANG')
                  AND MCST.CATEGORY_SET_NAME = 'Cash Flow Category')
           AND INVENTORY_ITEM_ID IN(
                  SELECT ITEM_ID
                  FROM PO_LINES_ALL
                  WHERE PO_HEADER_ID = (
                          SELECT PO_HEADER_ID
                          FROM AP_INVOICE_LINES_ALL AP
                          WHERE AP.INVOICE_ID=L_INVOICE_ID
                          AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
                  AND   PO_LINE_ID = (
                          SELECT PO_LINE_ID
                          FROM AP_INVOICE_LINES_ALL AP
                          WHERE AP.INVOICE_ID=L_INVOICE_ID
                          AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
                  )
            AND ORGANIZATION_ID IN(
                          SELECT ORG_ID
                          FROM AP_INVOICE_LINES_ALL AP
                          WHERE AP.INVOICE_ID=L_INVOICE_ID
                          AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
           );

Line: 259

               SELECT PO_HEADER_ID,
                      PO_LINE_ID
                 INTO L_PO_HEADER_ID,
                      L_PO_LINE_ID
                 FROM ap_invoice_lines_all al
                WHERE RCV_TRANSACTION_ID = (
                         SELECT RCV_TRANSACTION_ID
                           FROM ap_invoice_lines_all ap
                          WHERE ap.invoice_id = P_INVOICE_ID
                            AND ap.LINE_NUMBER = L_INVOICE_LINE_NUMBER)

                  AND INVOICE_ID = P_INVOICE_ID
                  AND PO_HEADER_ID IS NOT NULL
                  AND PO_LINE_ID IS NOT NULL;

Line: 276

                SELECT MC.CONCATENATED_SEGMENTS
                  INTO MASTER_ITEM
                  FROM MTL_CATEGORIES_B_KFV MC
                 WHERE CATEGORY_ID IN(
                    SELECT CATEGORY_ID
                      FROM MTL_ITEM_CATEGORIES MIC
                     WHERE MIC.CATEGORY_SET_ID IN (
                           SELECT CATEGORY_SET_ID
                             FROM MTL_CATEGORY_SETS_TL MCST
                            WHERE MCST.LANGUAGE = USERENV('LANG')
                              AND MCST.CATEGORY_SET_NAME = 'Cash Flow Category')
                       AND INVENTORY_ITEM_ID IN(
                              SELECT ITEM_ID
                              FROM PO_LINES_ALL
                              WHERE PO_HEADER_ID = L_PO_HEADER_ID
                              AND   PO_LINE_ID = L_PO_LINE_ID
                              )
                       AND ORGANIZATION_ID IN(
                                      SELECT ORG_ID
                                      FROM AP_INVOICE_LINES_ALL AP
                                      WHERE AP.INVOICE_ID=L_INVOICE_ID
                                      AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
                       );

Line: 333

    END MASTER_ITEM_UPDATE;

Line: 380

        SELECT description
        INTO Expense_Item_desc
        FROM ap_invoice_distributions_all
        WHERE invoice_distribution_id=p_invoice_distribution_id ;

Line: 450

        SELECT INVOICE_LINE_NUMBER,INVOICE_ID
        INTO L_INVOICE_LINE_NUMBER,L_INVOICE_ID
        FROM AP_INVOICE_DISTRIBUTIONS_ALL
        WHERE INVOICE_DISTRIBUTION_ID=P_INVOICE_DISTRIBUTION_ID ;

Line: 457

    SELECT MC.CONCATENATED_SEGMENTS
       INTO MASTER_ITEM
       FROM MTL_CATEGORIES_B_KFV MC
       WHERE CATEGORY_ID IN(
           SELECT CATEGORY_ID
           FROM MTL_ITEM_CATEGORIES MIC
           WHERE MIC.CATEGORY_SET_ID IN (
                  SELECT CATEGORY_SET_ID
                  FROM MTL_CATEGORY_SETS_TL MCST
                  WHERE MCST.LANGUAGE = USERENV('LANG')
                  AND MCST.CATEGORY_SET_NAME = 'Cash Flow Category')
           AND INVENTORY_ITEM_ID IN(
                  SELECT ITEM_ID
                  FROM PO_LINES_ALL
                  WHERE PO_HEADER_ID = (
                          SELECT PO_HEADER_ID
                          FROM AP_INVOICE_LINES_ALL AP
                          WHERE AP.INVOICE_ID=L_INVOICE_ID
                          AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
                  AND   PO_LINE_ID = (
                          SELECT PO_LINE_ID
                          FROM AP_INVOICE_LINES_ALL AP
                          WHERE AP.INVOICE_ID=L_INVOICE_ID
                          AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
                  )
            AND ORGANIZATION_ID IN(
                          SELECT ORG_ID
                          FROM AP_INVOICE_LINES_ALL AP
                          WHERE AP.INVOICE_ID=L_INVOICE_ID
                          AND AP.LINE_NUMBER=L_INVOICE_LINE_NUMBER)
           );

Line: 585

              Source_Value := MASTER_ITEM_UPDATE(p_invoice_id,
                                          p_invoice_distribution_id);

Line: 668

        SELECT apa.invoice_id, aia.source
          INTO ln_invoice_id,  lv_invoice_source
          FROM ap_invoice_payments_all apa, AP_INVOICES_ALL aia
         WHERE apa.invoice_payment_id = p_invoice_payment_id
           AND aia.invoice_id = apa.invoice_id;

Line: 690

              Source_Value := MASTER_ITEM_UPDATE(ln_invoice_id,
                                          '');

Line: 771

     SELECT ppa.SEGMENT1
       INTO l_project_num
       FROM PA_PROJECTS_ALL ppa
      WHERE ppa.PROJECT_ID = p_project_id;