DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on RCV_SHIPMENT_HEADERS

Line 5768: FROM rcv_shipment_headers rsh

5764: WHERE po_line_id = p_po_line_id;
5765:
5766: CURSOR Cur_get_receipt_info IS
5767: SELECT rsh.receipt_num receipt
5768: FROM rcv_shipment_headers rsh
5769: WHERE rsh.shipment_header_id = p_receipt_id;
5770:
5771: CURSOR Cur_get_receipt_line_info IS
5772: SELECT rsh.receipt_num receipt_no,

Line 5775: rcv_shipment_headers rsh

5771: CURSOR Cur_get_receipt_line_info IS
5772: SELECT rsh.receipt_num receipt_no,
5773: rsl.line_num receipt_line_num
5774: FROM rcv_shipment_lines rsl ,
5775: rcv_shipment_headers rsh
5776: WHERE rsl.po_header_id = p_po_header_id
5777: AND rsl.po_line_id = p_po_line_id
5778: AND rsl.shipment_header_id = rsh.shipment_header_id
5779: AND rsh.shipment_header_id = p_receipt_id ;