APPS.GMD_DISP_PUB dependencies on GMD_COMPOSITE_SPEC_DISP

Line 544: FROM gmd_event_spec_disp esd, gmd_composite_spec_disp csd,

540: AND delete_mark = 0 ;
541:
542: CURSOR c_non_accept_w_spec_cr IS
543: SELECT count(1)
544: FROM gmd_event_spec_disp esd, gmd_composite_spec_disp csd,
545: gmd_composite_results cr, gmd_spec_tests_b st
546: WHERE csd.composite_spec_disp_id = p_update_disp_rec.composite_spec_disp_id
547: AND csd.event_spec_disp_id = esd.event_spec_disp_id
548: AND csd.latest_ind = 'Y'

Line 557: FROM gmd_event_spec_disp esd, gmd_composite_spec_disp csd,

553: AND (st.optional_ind IS NULL OR (l_include_optional = 'Y' and st.optional_ind = 'Y' and (cr.mean IS NOT NULL or cr.mode_char IS NOT NULL)));
554:
555: CURSOR c_non_accept_wo_spec_cr IS
556: SELECT count(1)
557: FROM gmd_event_spec_disp esd, gmd_composite_spec_disp csd,
558: gmd_composite_results cr
559: WHERE csd.composite_spec_disp_id = p_update_disp_rec.composite_spec_disp_id
560: AND csd.event_spec_disp_id = esd.event_spec_disp_id
561: AND csd.latest_ind = 'Y'

Line 626: gmd_composite_spec_disp gcsd

622: CURSOR c_get_evt_org_id IS
623: SELECT organization_id
624: FROM gmd_sampling_events gse,
625: gmd_event_spec_disp gesd,
626: gmd_composite_spec_disp gcsd
627: WHERE gse.sampling_event_id = gesd.sampling_event_id
628: AND gesd.event_spec_disp_id = gcsd.event_spec_disp_id
629: AND gcsd.composite_spec_disp_id = p_update_disp_rec.composite_spec_disp_id;
630:

Line 901: FROM gmd_composite_spec_disp

897: WHERE sampling_event_id = p_change_disp_rec.sampling_event_id;
898:
899: CURSOR composite_spec_disp(l_event_spec_disp_id NUMBER) IS
900: SELECT composite_spec_disp_id
901: FROM gmd_composite_spec_disp
902: WHERE event_spec_disp_id = l_event_spec_disp_id;
903:
904: CURSOR cr_get_lot_status IS
905: SELECT control_lot_attrib_ind,

Line 1167: FROM gmd_composite_spec_disp csd,

1163: NVL(gse.sample_type, 'I'),nvl(gse.source,'I'),esd.spec_id,esd.spec_vr_id,csd.disposition,gsb.spec_name,gsb.spec_vers
1164: INTO l_organization_id,l_inventory_item_id,l_parent_lot_number,l_lot_number,l_grade_control_flag,l_lot_control_code,l_child_lot_flag,l_lot_status_enabled,
1165: l_sampling_event_date,l_subinventory,l_locator_id,l_locator,l_lpn_id,l_lpn,l_wms_enabled_flag,
1166: l_sample_type,l_source,l_spec_id,l_spec_vr_id,l_update_disp_rec.curr_disposition,l_spec_name,l_spec_vers
1167: FROM gmd_composite_spec_disp csd,
1168: gmd_event_spec_disp esd ,
1169: gmd_sampling_events gse,
1170: mtl_system_items_b msi,
1171: gmd_specifications_b gsb,