APPS.GMD_OUTBOUND_APIS_PUB dependencies on GMD_ROUTINGS_B

Line 4060: table_list := table_list ||', gmd_routings_b grout ';

4056: END IF;
4057:
4058: IF (p_wip_routing_no IS NOT NULL or p_wip_routing_vers IS NOT NULL)
4059: THEN
4060: table_list := table_list ||', gmd_routings_b grout ';
4061: where_clause := where_clause ||'AND gs.routing_id = grout.routing_id ';
4062:
4063: IF p_wip_routing_no IS NOT NULL
4064: THEN

Line 4533: --dbms_output.put_line('select from gmd_routings_b with routing_id of '

4529: END IF;
4530:
4531: IF g_samples_table(i).routing_id is not NULL
4532: THEN
4533: --dbms_output.put_line('select from gmd_routings_b with routing_id of '
4534: -- || g_samples_table(i).routing_id);
4535: select routing_no, routing_vers into g_samples_table(i).routing_no,g_samples_table(i).routing_vers
4536: from gmd_routings_b
4537: where routing_id = g_samples_table(i).routing_id;

Line 4536: from gmd_routings_b

4532: THEN
4533: --dbms_output.put_line('select from gmd_routings_b with routing_id of '
4534: -- || g_samples_table(i).routing_id);
4535: select routing_no, routing_vers into g_samples_table(i).routing_no,g_samples_table(i).routing_vers
4536: from gmd_routings_b
4537: where routing_id = g_samples_table(i).routing_id;
4538: END IF;
4539:
4540: IF g_samples_table(i).oprn_id is not NULL