APPS.PO_DISTRIBUTIONS_SV dependencies on RCV_TRANSACTIONS

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

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

Line 543: from rcv_transactions

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

Line 563: from rcv_transactions_interface

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