DBA Data[Home] [Help]

APPS.CHV_INQ_SV dependencies on PO_HEADERS

Line 664: po_headers poh

660: select max(rct.transaction_id)
661: into x_last_receipt_id
662: from rcv_transactions rct,
663: rcv_shipment_lines rsl,
664: po_headers poh
665: where rct.shipment_line_id = rsl.shipment_line_id
666: and rct.transaction_type = 'RECEIVE'
667: and rct.transaction_date between
668: to_date(x_cum_period_start_date,'YYYY/MM/DD') and

Line 680: po_headers poh2

676: and rct.transaction_date in
677: (select max(rct2.transaction_date)
678: from rcv_transactions rct2,
679: rcv_shipment_lines rsl2,
680: po_headers poh2
681: where rct2.shipment_line_id = rsl2.shipment_line_id
682: and rct2.transaction_type = 'RECEIVE'
683: and rct2.transaction_date between
684: to_date(x_cum_period_start_date,'YYYY/MM/DD') and