APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_SAMPLES

Line 786: from gmd_samples

782: order by a.creation_date desc ;
783:
784: CURSOR c_simple_result(p_sampling_event_id IN NUMBER) IS
785: select sample_id
786: from gmd_samples
787: where sampling_event_id = p_sampling_event_id;
788:
789: BEGIN
790: PrintLn('Begin Procedure getLatestSample');

Line 1153: from gmd_samples a, mtl_parameters b

1149: p_event_spec_disp_id IN NUMBER) IS
1150:
1151: CURSOR c_sample IS
1152: select a.organization_id, b.organization_code, a.sample_no
1153: from gmd_samples a, mtl_parameters b
1154: where sample_id = p_sample_id
1155: and a.organization_id = b.organization_id;
1156:
1157:

Line 1160: from gmd_samples a,

1156:
1157:
1158: CURSOR c_samples IS
1159: select a.organization_id, c.organization_code, a.sample_no
1160: from gmd_samples a,
1161: gmd_event_spec_disp b,
1162: mtl_parameters c
1163: where a.sampling_event_id = b.sampling_event_id
1164: and b.event_spec_disp_id = p_event_spec_disp_id