DBA Data[Home] [Help]

APPS.GHG_PO_EMISSIONS_PKG dependencies on PO_HEADERS_V

Line 181: FROM po_headers_v ph

177: SELECT MAX(rt.transaction_date)
178: INTO v_emission_date
179: FROM rcv_transactions rt
180: WHERE rt.po_header_id IN (SELECT ph.po_header_id
181: FROM po_headers_v ph
182: WHERE ph.segment1 = x_po_number)
183: AND rt.transaction_type = 'RECEIVE';
184:
185: IF v_emission_date IS NULL THEN