APPS.INV_FA_INTERFACE_PVT SQL Statements

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

Line: 21

     SELECT MMT.trx_source_line_id
     INTO   l_trx_src_line_id
     FROM   ap_invoice_distributions_all APINVD
        ,   ra_customer_trx_lines_all RCTL
        ,   mtl_material_transactions MMT
     WHERE   APINVD.invoice_distribution_id = p_inv_dist_id
     AND     RCTL.customer_trx_line_id = to_number(APINVD.reference_1)
     AND     RCTL.interface_line_context = 'INTERCOMPANY'
     AND     MMT.transaction_id = to_number(RCTL.interface_line_attribute7)
     AND     MMT.transaction_source_type_id = 8
     AND     MMT.transaction_action_id = 21;

Line: 39

      SELECT   PORD.code_combination_id
      INTO     l_temp_cc_id
      FROM     oe_order_lines_all OEL
         ,     po_req_distributions_all PORD
      WHERE    OEL.line_id = l_trx_src_line_id
      AND      OEL.source_document_type_id = 10
      AND      PORD.requisition_line_id = OEL.source_document_line_id
      GROUP BY PORD.code_combination_id;

Line: 84

     SELECT MMT.trx_source_line_id
     INTO   l_trx_src_line_id
     FROM   ra_customer_trx_lines_all RCTL
        ,   mtl_material_transactions MMT
     WHERE  RCTL.customer_trx_line_id = to_number(p_inv_ref_id)
     AND    RCTL.interface_line_context = 'INTERCOMPANY'
     AND    MMT.transaction_id = to_number(RCTL.interface_line_attribute7)
     AND    MMT.transaction_source_type_id = 8
     AND    MMT.transaction_action_id = 21;

Line: 100

      SELECT   PORD.code_combination_id
      INTO     l_temp_cc_id
      FROM     oe_order_lines_all OEL
         ,     po_req_distributions_all PORD
      WHERE    OEL.line_id = l_trx_src_line_id
      AND      OEL.source_document_type_id = 10
      AND      PORD.requisition_line_id = OEL.source_document_line_id
      GROUP BY PORD.code_combination_id;