APPS.JA_CN_CUSTOM_SOURCES SQL Statements

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

Line: 70

        SELECT GLOBAL_ATTRIBUTE1
        INTO GDF_ITEM
        FROM AP_INVOICE_DISTRIBUTIONS_ALL
        WHERE INVOICE_DISTRIBUTION_ID=P_INVOICE_DISTRIBUTION_ID;

Line: 78

          SELECT GLOBAL_ATTRIBUTE1
          INTO GDF_ITEM
          FROM AP_INVOICES_ALL
          WHERE INVOICE_ID=P_INVOICE_ID;

Line: 120

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

Line: 152

        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: 160

    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: 197

               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: 214

                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: 271

    END MASTER_ITEM_UPDATE;

Line: 318

        SELECT description
        INTO Expense_Item_desc
        FROM ap_invoice_distributions_all
        WHERE invoice_distribution_id=p_invoice_distribution_id ;

Line: 388

        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: 395

    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: 523

              Source_Value := MASTER_ITEM_UPDATE(p_invoice_id,
                                          p_invoice_distribution_id);

Line: 596

       SELECT SEGMENT1
       INTO project_num
       FROM PA_PROJECTS_ALL
       WHERE PROJECT_ID = Project_id;