APPS.GMD_OUTBOUND_APIS_PUB dependencies on GMD_ROUTINGS_B

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

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

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

4502: END IF;
4503:
4504: IF g_samples_table(i).routing_id is not NULL
4505: THEN
4506: --dbms_output.put_line('select from gmd_routings_b with routing_id of '
4507: -- || g_samples_table(i).routing_id);
4508: select routing_no, routing_vers into g_samples_table(i).routing_no,g_samples_table(i).routing_vers
4509: from gmd_routings_b
4510: where routing_id = g_samples_table(i).routing_id;

Line 4509: from gmd_routings_b

4505: THEN
4506: --dbms_output.put_line('select from gmd_routings_b with routing_id of '
4507: -- || g_samples_table(i).routing_id);
4508: select routing_no, routing_vers into g_samples_table(i).routing_no,g_samples_table(i).routing_vers
4509: from gmd_routings_b
4510: where routing_id = g_samples_table(i).routing_id;
4511: END IF;
4512:
4513: IF g_samples_table(i).oprn_id is not NULL