APPS.FV_THIRD_PARTY_REMIT_PKG SQL Statements

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

Line: 262

   DELETE FROM fv_third_party_temp;

Line: 290

   g_message := '     Inserting a record in Fv_Third_Party_Temp ...';

Line: 295

   INSERT INTO fv_third_party_temp
     (original_supplier_name,
      original_supplier_site,
      third_party_agent,
      third_party_site,
      check_number,
      check_date,
      check_amount,
      invoice_number,
      invoice_amount,
      discount_amount,
      org_id,
      set_of_books_id)
   VALUES
     (p_from_supp_name,
      p_from_supp_site,
      p_to_supp_name,
      p_to_supp_site,
      p_check_number,
      p_check_date,
      p_check_amount,
      p_invoice_number,
      p_invoice_amount,
      p_discount_amount,
      g_org_id,
      g_sob_id);

Line: 325

                      ' -- Error in Populate_Third_Party_Temp Procedure when inserting record into fv_third_party_temp table';

Line: 343

   SELECT vendor_name
   INTO l_vendor_name
   FROM po_vendors
   WHERE vendor_id = p_vendor_id;

Line: 374

   SELECT vendor_site_code
   INTO l_vendor_site_code
   FROM po_vendor_sites
   WHERE vendor_site_id = p_vendor_site_id;

Line: 402

l_row_select   VARCHAR2(3000);

Line: 424

l_bank_account_id   Ap_Invoice_Selection_Criteria.bank_account_id%TYPE;

Line: 435

   SELECT apc.check_number, apc.check_date, apc.amount,
          invoice_num, invoice_amount, discount_amount_taken
   FROM  ap_checks apc, ap_invoice_payments apip, ap_invoices api
   WHERE apc.bank_account_id = l_bank_account_id
   AND apc.checkrun_name = l_checkrun_name
   AND apc.check_number = l_check_num_fvtpp
   AND apc.vendor_id = l_third_party_agent_id
   AND apc.vendor_site_id = l_third_party_site_id
   AND apc.check_id = apip.check_id
   AND apip.set_of_books_id = g_sob_id
   AND apip.invoice_id = api.invoice_id
   AND api.vendor_id = l_original_supplier_id
   AND api.vendor_site_id = l_original_site_id
   AND api.set_of_books_id = g_sob_id
   AND status_lookup_code IN ('CLEARED', 'CLEARED BUT UNACCOUNTED', 'ISSUED',
                              'NEGOTIABLE', 'RECONCILED', 'RECONCILED UNACCOUNTED');

Line: 511

   l_row_select := '
      SELECT fvcd.assignment_id, tpp.original_supplier_id, tpp.original_supplier_site_id,
	     tpp.third_party_agent_id, tpp.third_party_site_id, fvcd.checkrun_name, fvcd.check_number
      FROM fv_tpp_check_details fvcd, fv_tpp_assignments_all tpp, ap_invoice_selection_criteria apisc
      WHERE '|| l_where_clause ||'
            fvcd.checkrun_name = apisc.checkrun_name
      AND   apisc.status = '||''''|| 'CONFIRMED' ||''''||'
      AND   fvcd.set_of_books_id = '|| g_sob_id ||'
      AND   tpp.set_of_books_id = '|| g_sob_id ||'
      AND   tpp.org_id = '|| g_org_id ||'
      AND   fvcd.assignment_id = tpp.assignment_id';

Line: 523

   g_message := l_row_select;

Line: 528

      DBMS_SQL.PARSE(l_row_cursor, l_row_select, DBMS_SQL.V7);

Line: 615

	  SELECT bank_account_id
	  INTO l_bank_account_id
	  FROM ap_invoice_selection_criteria
	  WHERE checkrun_name = l_checkrun_name;

Line: 683

	 -- Select the Original and Third Party info
   	 -- if not specified as SRS parameters

    	 IF (l <> 0) AND (j <> 0)
    	 THEN
	    FOR i IN l .. j
	    LOOP
	       BEGIN
	          SELECT pv.vendor_name, ps.vendor_site_code
	          INTO l_vendor_name, l_site_code
	          FROM po_vendors pv, po_vendor_sites ps,
  	               fv_tpp_assignments_all fv
	          WHERE fv.assignment_id = l_assignment_id
		  AND fv.set_of_books_id = g_sob_id
		  AND fv.org_id = g_org_id
	          AND pv.vendor_id = DECODE(i, 1, fv.original_supplier_id,
	                        	       2, fv.third_party_agent_id)
	          AND ps.vendor_site_id = DECODE(i, 1, fv.original_supplier_site_id,
					            2, fv.third_party_site_id);