DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_COMPOSITE_SPEC_DISP

Line 399: gmd_composite_spec_disp sd,

395: r.range,
396: r.non_validated_result,
397: r.standard_deviation , ges.spec_id
398: from gmd_composite_results r,
399: gmd_composite_spec_disp sd,
400: gmd_event_spec_disp ges
401: where r.composite_spec_disp_id =sd.composite_spec_disp_id
402: and sd.event_spec_disp_id = p_event_spec_disp_id
403: and sd.event_spec_disp_id = ges.event_spec_disp_id

Line 915: GMD_COMPOSITE_SPEC_DISP ges

911: gr.mode_char result_value_char,'EVENT_SPEC_DISP'
912: FROM GMD_SAMPLING_EVENTS gs ,
913: GMD_EVENT_SPEC_DISP sd,
914: GMD_COMPOSITE_RESULTS gr,
915: GMD_COMPOSITE_SPEC_DISP ges
916: WHERE
917: gs.inventory_item_id = l_inventory_item_id
918: AND (gs.revision = l_revision OR gs.revision IS NULL)
919: AND (gs.lot_number = l_lot_number OR gs.lot_number IS NULL)