APPS.GMD_OUTBOUND_APIS_PUB dependencies on GMD_COMPOSITE_RESULTS_REC_TYPE

Line 3172: column_list := 'system.gmd_composite_results_rec_type( gcr.composite_result_id, gcr.test_id, '

3168:
3169: IF (p_from_item_number IS NOT NULL OR p_to_item_number IS NOT NULL or p_inventory_item_id is NOT NULL) AND
3170: (p_lot_number is NOT NULL)
3171: THEN
3172: column_list := 'system.gmd_composite_results_rec_type( gcr.composite_result_id, gcr.test_id, '
3173: ||'gcr.mean, gcr.mode_num, gcr.mode_char, gcr.low_num, gcr.high_num , '
3174: ||'gcr.range, gcr.standard_deviation, gcr.sample_total, '
3175: ||'gcr.sample_cnt_used, gcr.non_validated_result, '
3176: ||'gcr.high_char, gcr.low_char, gcr.median_char, gcr.median_num, '

Line 3205: column_list := 'system.gmd_composite_results_rec_type( gcr.composite_result_id, gcr.test_id, ' -- 5284247

3201: ||'AND fu1.user_id = gcr.created_by AND fu2.user_id = gcr.last_updated_by and 1=:dummy ';
3202:
3203: ELSIF (p_from_item_number IS NOT NULL OR p_to_item_number IS NOT NULL or p_inventory_item_id is NOT NULL)
3204: THEN
3205: column_list := 'system.gmd_composite_results_rec_type( gcr.composite_result_id, gcr.test_id, ' -- 5284247
3206: ||'gcr.mean, gcr.mode_num, gcr.mode_char, gcr.low_num, gcr.high_num , '
3207: ||'gcr.range, gcr.standard_deviation, gcr.sample_total, '
3208: ||'gcr.sample_cnt_used, gcr.non_validated_result, '
3209: ||'gcr.high_char, gcr.low_char, gcr.median_char, gcr.median_num, '

Line 3238: column_list := 'system.gmd_composite_results_rec_type( gcr.composite_result_id, gcr.test_id, ' -- 5284247

3234: ||'AND fu1.user_id = gcr.created_by AND fu2.user_id = gcr.last_updated_by and 1=:dummy ';
3235:
3236: ELSIF (p_lot_number is NOT NULL)
3237: THEN
3238: column_list := 'system.gmd_composite_results_rec_type( gcr.composite_result_id, gcr.test_id, ' -- 5284247
3239: ||'gcr.mean, gcr.mode_num, gcr.mode_char, gcr.low_num, gcr.high_num , '
3240: ||'gcr.range, gcr.standard_deviation, gcr.sample_total, '
3241: ||'gcr.sample_cnt_used, gcr.non_validated_result, '
3242: ||'gcr.high_char, gcr.low_char, gcr.median_char, gcr.median_num, '

Line 3271: column_list := 'system.gmd_composite_results_rec_type( gcr.composite_result_id, gcr.test_id, ' -- 5284247

3267: ||'AND fu1.user_id = gcr.created_by AND fu2.user_id = gcr.last_updated_by and 1=:dummy ';
3268:
3269:
3270: ELSE
3271: column_list := 'system.gmd_composite_results_rec_type( gcr.composite_result_id, gcr.test_id, ' -- 5284247
3272: ||'gcr.mean, gcr.mode_num, gcr.mode_char, gcr.low_num, gcr.high_num , '
3273: ||'gcr.range, gcr.standard_deviation, gcr.sample_total, '
3274: ||'gcr.sample_cnt_used, gcr.non_validated_result, '
3275: ||'gcr.high_char, gcr.low_char, gcr.median_char, gcr.median_num, '