DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on RCV_SHIPMENT_HEADERS

Line 2321: FROM rcv_shipment_headers rsh , rcv_transactions rt

2317: --Bug# 3576573. Added cusor c_receipt_info
2318: -- Bug 3970893: receipt line id is no longer the transaction id, it is now shipment_line_id
2319: /*CURSOR c_receipt_info IS
2320: SELECT 1
2321: FROM rcv_shipment_headers rsh , rcv_transactions rt
2322: WHERE (p_sample_rec.receipt_id, p_sample_rec.receipt_line_id) IN
2323: (SELECT rsh.shipment_header_id,
2324: rsl.shipment_line_id -- rt.transaction_id
2325: FROM rcv_shipment_lines rsl

Line 2340: FROM rcv_shipment_headers rsh

2336:
2337: --CURSOR c_receipt_info rewritten as part of bug# 4916871
2338: CURSOR c_receipt_info IS
2339: SELECT 1
2340: FROM rcv_shipment_headers rsh
2341: WHERE (p_sample_rec.receipt_id, p_sample_rec.receipt_line_id) IN
2342: (SELECT rsh.shipment_header_id,
2343: rsl.shipment_line_id
2344: FROM rcv_shipment_lines rsl