APPS.GMD_OUTBOUND_APIS_PUB dependencies on GMD_SPECIFICATIONS_B

Line 856: -- GMD_SPECIFICATIONS basic clauses

852: -- The whole statement is then put into an EXECUTE IMMEDIATE statement to pass it
853: -- to the database. Here goes......
854:
855:
856: -- GMD_SPECIFICATIONS basic clauses
857:
858: main_column_list := ' gs.spec_id, gs.spec_name, gs.spec_vers, gs.spec_desc'
859: ||', gs.inventory_item_id, NULL, gs.grade_code, gs.revision, gs.spec_status, gstat.description'
860: ||', gs.owner_organization_id, gs.owner_id, fu3.user_name'

Line 1223: main_table_list := main_table_list || ', gmd_specifications_b gsp';

1219: END IF;
1220:
1221: IF p_base_spec_name IS NOT NULL OR p_base_spec_version IS NOT NULL
1222: THEN
1223: main_table_list := main_table_list || ', gmd_specifications_b gsp';
1224: main_where_clause := main_where_clause || ' AND gsp.spec_id = gs.base_spec_id';
1225:
1226: IF p_base_spec_name IS NOT NULL
1227: THEN

Line 4478: gme_debug.put_line('select from gmd_specifications_b using spec_id of '

4474: LOOP
4475: gme_debug.put_line('sample no=' || g_samples_table(i).sample_no);
4476: IF g_samples_table(i).spec_id is not NULL
4477: THEN
4478: gme_debug.put_line('select from gmd_specifications_b using spec_id of '
4479: || g_samples_table(i).spec_id);
4480: select spec_name, spec_vers into g_samples_table(i).spec_name,g_samples_table(i).spec_vers
4481: from gmd_specifications_b
4482: where spec_id = g_samples_table(i).spec_id;

Line 4481: from gmd_specifications_b

4477: THEN
4478: gme_debug.put_line('select from gmd_specifications_b using spec_id of '
4479: || g_samples_table(i).spec_id);
4480: select spec_name, spec_vers into g_samples_table(i).spec_name,g_samples_table(i).spec_vers
4481: from gmd_specifications_b
4482: where spec_id = g_samples_table(i).spec_id;
4483: END IF;
4484:
4485: IF g_samples_table(i).inventory_item_id is not NULL

Line 4907: disp_table_list :=' gmd_event_spec_disp sd, gmd_specifications_b gs, fnd_user fu3, fnd_user fu4';

4903: ||',sd.SPEC_VR_ID, sd.DISPOSITION, sd.SPEC_USED_FOR_LOT_ATTRIB_IND'
4904: ||',sd.DELETE_MARK, sd.CREATION_DATE, sd.CREATED_BY, fu3.USER_NAME'
4905: ||',sd.LAST_UPDATE_DATE, sd.LAST_UPDATED_BY, fu4.USER_NAME, sd.LAST_UPDATE_LOGIN';
4906:
4907: disp_table_list :=' gmd_event_spec_disp sd, gmd_specifications_b gs, fnd_user fu3, fnd_user fu4';
4908:
4909: disp_where_clause:=' sd.spec_id = gs.spec_id(+) AND sd.created_by = fu3.user_id'
4910: ||' AND sd.last_updated_by = fu4.user_id'
4911: ||' AND sd.sampling_event_id = se.sampling_event_id'