APPS.GMDQC0_WF_P dependencies on RCV_SHIPMENT_HEADERS

Line 190: FROM rcv_shipment_headers

186: /* Added code to fetch the doc_no depending upon doc type and doc_id*/
187: IF l_doc_type in ('PORC') THEN
188: SELECT receipt_num
189: INTO l_doc_no
190: FROM rcv_shipment_headers
191: WHERE shipment_header_id = l_doc_id;
192: ELSIF l_doc_type in ('RECV') THEN
193: SELECT recv_no
194: INTO l_doc_no