APPS.POA_EDW_SPEND_PKG dependencies on RCV_TRANSACTIONS

Line 559: -- gets min good_received_date from rcv_transactions for given line_location_id

555:
556: END get_invoice_creation_date;
557:
558: -- get_goods_received_date
559: -- gets min good_received_date from rcv_transactions for given line_location_id
560: -- and transaction_type is RECEIVE
561:
562: FUNCTION get_goods_received_date(p_po_line_loc_id NUMBER)
563: RETURN DATE

Line 572: from rcv_transactions rct

568: BEGIN
569:
570: select trunc(min(transaction_date))
571: into goods_rcvd_date
572: from rcv_transactions rct
573: where transaction_type = 'RECEIVE'
574: and rct. po_line_location_id = p_po_line_loc_id;
575:
576: RETURN(goods_rcvd_date);