DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on RCV_SHIPMENT_HEADERS

Line 2191: FROM rcv_shipment_headers rsh , rcv_transactions rt

2187: --Bug# 3576573. Added cusor c_receipt_info
2188: -- Bug 3970893: receipt line id is no longer the transaction id, it is now shipment_line_id
2189: /*CURSOR c_receipt_info IS
2190: SELECT 1
2191: FROM rcv_shipment_headers rsh , rcv_transactions rt
2192: WHERE (p_sample_rec.receipt_id, p_sample_rec.receipt_line_id) IN
2193: (SELECT rsh.shipment_header_id,
2194: rsl.shipment_line_id -- rt.transaction_id
2195: FROM rcv_shipment_lines rsl

Line 2210: FROM rcv_shipment_headers rsh

2206:
2207: --CURSOR c_receipt_info rewritten as part of bug# 4916871
2208: CURSOR c_receipt_info IS
2209: SELECT 1
2210: FROM rcv_shipment_headers rsh
2211: WHERE (p_sample_rec.receipt_id, p_sample_rec.receipt_line_id) IN
2212: (SELECT rsh.shipment_header_id,
2213: rsl.shipment_line_id
2214: FROM rcv_shipment_lines rsl