APPS.GMD_COA_DATA_OM dependencies on GMD_SAMPLES

Line 273: CURSOR get_cust_rslt_info (c_orgn_code gmd_samples.orgn_code%TYPE,

269: tbl_dtl IN OUT NOCOPY t_coa_detail_tbl) IS
270:
271: /* BEGIN BUG#1810652 James Bernard */
272: /* Added 'c_item_id is NULL or' in the where clause */
273: CURSOR get_cust_rslt_info (c_orgn_code gmd_samples.orgn_code%TYPE,
274: c_item_id ic_item_mst.item_id%TYPE,
275: c_lot_id ic_lots_mst.lot_id%TYPE,
276: c_lot_no ic_lots_mst.lot_no%TYPE,
277: c_cust_id hz_cust_accounts.cust_account_id%TYPE) IS

Line 288: from gmd_samples gs,

284: specification,
285: gt.test_unit uom,
286: gst.text_code spec_text_code,
287: gr.text_code rslt_text_code
288: from gmd_samples gs,
289: gmd_results gr,
290: gmd_qc_tests_b gt,
291: gmd_spec_results gsr,
292: gmd_spec_tests_b gst ,

Line 326: CURSOR get_item_rslt_info (c_orgn_code gmd_samples.orgn_code%TYPE,

322:
323: /* use the next cursor if no rows returned from get_cust_rslt_info */
324: /* BEGIN BUG#1810652 James Bernard */
325: /* Added 'c_item_id is NULL or' and 'c_lot_id is NULL or' in the where clause */
326: CURSOR get_item_rslt_info (c_orgn_code gmd_samples.orgn_code%TYPE,
327: c_item_id ic_item_mst.item_id%TYPE,
328: c_lot_no ic_lots_mst.lot_no%TYPE,
329: c_lot_id ic_lots_mst.lot_id%TYPE) IS
330: select gr.result_id qc_result_id,

Line 340: from gmd_samples gs,

336: specification,
337: gt.test_unit uom,
338: gst.text_code spec_text_code,
339: gr.text_code rslt_text_code
340: from gmd_samples gs,
341: gmd_results gr,
342: gmd_qc_tests_b gt,
343: gmd_spec_results gsr,
344: gmd_spec_tests_b gst ,