APPS.GMD_OUTBOUND_APIS_PUB dependencies on GMD_OPERATIONS

Line 4102: table_list := table_list ||', gmd_operations go ';

4098: END IF;
4099:
4100: IF (p_wip_oprn_no IS NOT NULL or p_wip_oprn_vers IS NOT NULL )
4101: THEN
4102: table_list := table_list ||', gmd_operations go ';
4103: where_clause := where_clause ||'AND gs.oprn_id = go.oprn_id ';
4104:
4105: IF p_wip_oprn_no IS NOT NULL
4106: THEN

Line 4542: --dbms_output.put_line('select from gmd_operations with oprn_id of '|| g_samples_table(i).oprn_id);

4538: END IF;
4539:
4540: IF g_samples_table(i).oprn_id is not NULL
4541: THEN
4542: --dbms_output.put_line('select from gmd_operations with oprn_id of '|| g_samples_table(i).oprn_id);
4543: select oprn_no, oprn_vers into g_samples_table(i).oprn_no,g_samples_table(i).oprn_vers
4544: from gmd_operations
4545: where oprn_id = g_samples_table(i).oprn_id;
4546: END IF;

Line 4544: from gmd_operations

4540: IF g_samples_table(i).oprn_id is not NULL
4541: THEN
4542: --dbms_output.put_line('select from gmd_operations with oprn_id of '|| g_samples_table(i).oprn_id);
4543: select oprn_no, oprn_vers into g_samples_table(i).oprn_no,g_samples_table(i).oprn_vers
4544: from gmd_operations
4545: where oprn_id = g_samples_table(i).oprn_id;
4546: END IF;
4547:
4548: IF g_samples_table(i).cust_id is not NULL

Line 5157: main_table_list := main_table_list||', gmd_operations_b go';

5153: END IF;
5154:
5155: IF p_wip_oprn_no IS NOT NULL OR p_wip_oprn_vers IS NOT NULL
5156: THEN
5157: main_table_list := main_table_list||', gmd_operations_b go';
5158: main_where_clause := main_where_clause||' AND se.oprn_id = go.oprn_id';
5159:
5160: IF p_wip_oprn_no IS NOT NULL
5161: THEN