DBA Data[Home] [Help]

APPS.GMD_DISP_PUB dependencies on GMD_SPECIFICATIONS_B

Line 1052: gmd_specifications_b c

1048: l_spec_id,l_spec_vr_id,
1049: l_spec_name,l_spec_vers
1050: FROM gmd_sample_spec_disp a,
1051: gmd_event_spec_disp b,
1052: gmd_specifications_b c
1053: WHERE a.sample_id = l_update_disp_rec.sample_id
1054: AND a.event_spec_disp_id = b.event_spec_disp_id
1055: AND a.delete_mark = 0
1056: AND b.SPEC_USED_FOR_LOT_ATTRIB_IND = 'Y'

Line 1171: gmd_specifications_b gsb,

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,
1172: mtl_item_locations_kfv mil,
1173: wms_license_plate_numbers wlpn,
1174: mtl_parameters mp
1175: WHERE csd.composite_spec_disp_id = l_update_disp_rec.composite_spec_disp_id

Line 1387: FROM GMD_SPECIFICATIONS_B

1383: IF l_grade_control_flag = 'Y' THEN
1384: IF p_change_disp_rec.to_disposition IN ('4A','5AV') AND p_change_disp_rec.to_grade_code IS NULL THEN
1385: BEGIN
1386: SELECT grade_code INTO l_to_grade_code
1387: FROM GMD_SPECIFICATIONS_B
1388: WHERE spec_id = l_spec_id ;
1389: EXCEPTION WHEN OTHERS THEN
1390: NULL ;
1391: END ;