APPS.GMD_OUTBOUND_APIS_PUB dependencies on RCV_SHIPMENT_HEADERS

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

4600: END IF;
4601:
4602: IF g_samples_table(i).receipt_id is not NULL
4603: THEN
4604: --dbms_output.put_line('select from rcv_shipment_headers with shipment_header_id of '
4605: -- || g_samples_table(i).receipt_id);
4606: select receipt_num into g_samples_table(i).receipt_no
4607: from rcv_shipment_headers
4608: where shipment_header_id = g_samples_table(i).receipt_id;

Line 4607: from rcv_shipment_headers

4603: THEN
4604: --dbms_output.put_line('select from rcv_shipment_headers with shipment_header_id of '
4605: -- || g_samples_table(i).receipt_id);
4606: select receipt_num into g_samples_table(i).receipt_no
4607: from rcv_shipment_headers
4608: where shipment_header_id = g_samples_table(i).receipt_id;
4609: END IF;
4610:
4611: IF g_samples_table(i).receipt_line_id is not NULL

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

4828: ||', se.SAMPLE_ACTIVE_CNT '
4829: ||', se.organization_id, se.resources, se.instance_id, se.time_point_id '
4830: ||', se.variant_id, se.archived_taken, se.reserved_taken ';
4831:
4832: main_table_list :=' gmd_sampling_events se, rcv_shipment_headers rh, po_headers_all ph'
4833: ||',gme_batch_header bh, fnd_user fu1, fnd_user fu2, gmd_recipes_b r'
4834: ||',fm_form_mst_b fh, oe_order_headers_all oh, mtl_system_items_b im'
4835: ||',po_lines_all pl, oe_order_lines_all ol, fm_matl_dtl fd'
4836: ||',mtl_parameters mp';