APPS.GMD_OUTBOUND_APIS_PUB dependencies on RCV_SHIPMENT_HEADERS

Line 4631: --dbms_output.put_line('select from rcv_shipment_headers with shipment_header_id of '

4627: END IF;
4628:
4629: IF g_samples_table(i).receipt_id is not NULL
4630: THEN
4631: --dbms_output.put_line('select from rcv_shipment_headers with shipment_header_id of '
4632: -- || g_samples_table(i).receipt_id);
4633: select receipt_num into g_samples_table(i).receipt_no
4634: from rcv_shipment_headers
4635: where shipment_header_id = g_samples_table(i).receipt_id;

Line 4634: from rcv_shipment_headers

4630: THEN
4631: --dbms_output.put_line('select from rcv_shipment_headers with shipment_header_id of '
4632: -- || g_samples_table(i).receipt_id);
4633: select receipt_num into g_samples_table(i).receipt_no
4634: from rcv_shipment_headers
4635: where shipment_header_id = g_samples_table(i).receipt_id;
4636: END IF;
4637:
4638: IF g_samples_table(i).receipt_line_id is not NULL

Line 4880: main_table_list :=' gmd_sampling_events se, rcv_shipment_headers rh, po_headers_all ph'

4876: ||', se.SAMPLE_ACTIVE_CNT '
4877: ||', se.organization_id, se.resources, se.instance_id, se.time_point_id '
4878: ||', se.variant_id, se.archived_taken, se.reserved_taken ';
4879:
4880: main_table_list :=' gmd_sampling_events se, rcv_shipment_headers rh, po_headers_all ph'
4881: ||',gme_batch_header bh, fnd_user fu1, fnd_user fu2, gmd_recipes_b r'
4882: ||',fm_form_mst_b fh, oe_order_headers_all oh, mtl_system_items_b im'
4883: ||',po_lines_all pl, oe_order_lines_all ol, fm_matl_dtl fd'
4884: ||',mtl_parameters mp';