APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_SAMPLES

Line 816: --Added extra join in where clause to gmd_samples and changed 5RJ to 6RJ

812:
813: --BUG#3482676 Anoop.
814: --Added condition in where clause to check the lot no specified.
815: --BUG# 8577332
816: --Added extra join in where clause to gmd_samples and changed 5RJ to 6RJ
817: ---- 9655426 added nvl to lot_number to put nulls at end of list for sort by so that a Parent lot/lot combination
818: ---- would always come first before just a parent lot even though the parent lot was the latest.
819: CURSOR c_sampling_event(p_spec_id IN NUMBER) IS
820:

Line 824: from gmd_samples a,gmd_event_spec_disp b, gmd_sampling_events c

820:
821: select nvl(c.SAMPLE_ACTIVE_CNT,0) sample_active_cnt,
822: b.event_spec_disp_id,
823: b.sampling_event_id
824: from gmd_samples a,gmd_event_spec_disp b, gmd_sampling_events c
825: where b.spec_id =p_spec_id
826: and (((a.lot_number = p_lot_number or p_lot_number is null)
827: and (a.parent_lot_number = p_parent_lot_number or p_parent_lot_number is null) ) -- 9655426 added
828: or (a.parent_lot_number = p_parent_lot_number and a.lot_number is null) ) -- 9655426 added latest

Line 842: from gmd_samples a, gmd_sample_spec_disp b

838: --Bug 8812000
839: --Added and a.sample_id = b.sample_id and b.disposition <> '7CN';
840: CURSOR c_simple_result(p_sampling_event_id IN NUMBER) IS
841: select a.sample_id , a.sample_no
842: from gmd_samples a, gmd_sample_spec_disp b
843: where a.sampling_event_id = p_sampling_event_id
844: AND a.sample_id = b.sample_id
845: AND b.disposition <> '7CN';
846:

Line 1224: from gmd_samples a, mtl_parameters b

1220: p_event_spec_disp_id IN NUMBER) IS
1221:
1222: CURSOR c_sample IS
1223: select a.organization_id, b.organization_code, a.sample_no
1224: from gmd_samples a, mtl_parameters b
1225: where sample_id = p_sample_id
1226: and a.organization_id = b.organization_id;
1227:
1228:

Line 1231: from gmd_samples a,

1227:
1228:
1229: CURSOR c_samples IS
1230: select a.organization_id, c.organization_code, a.sample_no
1231: from gmd_samples a,
1232: gmd_event_spec_disp b,
1233: mtl_parameters c
1234: where a.sampling_event_id = b.sampling_event_id
1235: and b.event_spec_disp_id = p_event_spec_disp_id