APPS.PO_DISTRIBUTIONS_SV dependencies on RCV_TRANSACTIONS

Line 537: /* Find if any record for the shipment exists in rcv_transactions table */

533: RETURN BOOLEAN IS
534: l_exists VARCHAR2(1);
535: Begin
536: l_exists :='N';
537: /* Find if any record for the shipment exists in rcv_transactions table */
538: begin
539: select 'Y'
540: into l_exists
541: from dual

Line 544: from rcv_transactions

540: into l_exists
541: from dual
542: where exists
543: (select 'rcv transaction records'
544: from rcv_transactions
545: where po_line_location_id = p_line_location_id);
546:
547: exception
548: when no_data_found then

Line 564: from rcv_transactions_interface

560: into l_exists
561: from dual
562: where exists
563: (select 'transaction interface records'
564: from rcv_transactions_interface
565: where po_line_location_id = p_line_location_id
566: and transaction_status_code = 'PENDING');
567:
568: exception