DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on RCV_SHIPMENT_HEADERS

Line 5100: FROM rcv_shipment_headers rsh

5096: WHERE po_line_id = p_po_line_id;
5097:
5098: CURSOR Cur_get_receipt_info IS
5099: SELECT rsh.receipt_num receipt
5100: FROM rcv_shipment_headers rsh
5101: WHERE rsh.shipment_header_id = p_receipt_id;
5102:
5103: CURSOR Cur_get_receipt_line_info IS
5104: SELECT rsh.receipt_num receipt_no,

Line 5107: rcv_shipment_headers rsh

5103: CURSOR Cur_get_receipt_line_info IS
5104: SELECT rsh.receipt_num receipt_no,
5105: rsl.line_num receipt_line_num
5106: FROM rcv_shipment_lines rsl ,
5107: rcv_shipment_headers rsh
5108: WHERE rsl.po_header_id = p_po_header_id
5109: AND rsl.po_line_id = p_po_line_id
5110: AND rsl.shipment_header_id = rsh.shipment_header_id
5111: AND rsh.shipment_header_id = p_receipt_id ;