APPS.GMD_OUTBOUND_APIS_PUB dependencies on GMD_OPERATIONS

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

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

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

4511: END IF;
4512:
4513: IF g_samples_table(i).oprn_id is not NULL
4514: THEN
4515: --dbms_output.put_line('select from gmd_operations with oprn_id of '|| g_samples_table(i).oprn_id);
4516: select oprn_no, oprn_vers into g_samples_table(i).oprn_no,g_samples_table(i).oprn_vers
4517: from gmd_operations
4518: where oprn_id = g_samples_table(i).oprn_id;
4519: END IF;

Line 4517: from gmd_operations

4513: IF g_samples_table(i).oprn_id is not NULL
4514: THEN
4515: --dbms_output.put_line('select from gmd_operations with oprn_id of '|| g_samples_table(i).oprn_id);
4516: select oprn_no, oprn_vers into g_samples_table(i).oprn_no,g_samples_table(i).oprn_vers
4517: from gmd_operations
4518: where oprn_id = g_samples_table(i).oprn_id;
4519: END IF;
4520:
4521: IF g_samples_table(i).cust_id is not NULL

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

5105: END IF;
5106:
5107: IF p_wip_oprn_no IS NOT NULL OR p_wip_oprn_vers IS NOT NULL
5108: THEN
5109: main_table_list := main_table_list||', gmd_operations_b go';
5110: main_where_clause := main_where_clause||' AND se.oprn_id = go.oprn_id';
5111:
5112: IF p_wip_oprn_no IS NOT NULL
5113: THEN