APPS.GMD_COA_DATA_OM dependencies on IC_LOTS_MST

Line 275: c_lot_id ic_lots_mst.lot_id%TYPE,

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
278: select gr.result_id qc_result_id,
279: gst.spec_id qc_spec_id,

Line 276: c_lot_no ic_lots_mst.lot_no%TYPE,

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
278: select gr.result_id qc_result_id,
279: gst.spec_id qc_spec_id,
280: gt.test_code assay_code,

Line 328: c_lot_no ic_lots_mst.lot_no%TYPE,

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,
331: gst.spec_id qc_spec_id,
332: gt.test_code assay_code,

Line 329: c_lot_id ic_lots_mst.lot_id%TYPE) IS

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,
331: gst.spec_id qc_spec_id,
332: gt.test_code assay_code,
333: gr.result_date result_date,

Line 1005: CURSOR get_lot_info (c_lot_id ic_lots_mst.lot_id%TYPE) IS

1001: AND itp.line_detail_id = c_line_id
1002: and itp.delete_mark = 0
1003: ;
1004:
1005: CURSOR get_lot_info (c_lot_id ic_lots_mst.lot_id%TYPE) IS
1006: SELECT ilm.lot_no,
1007: ilm.lot_desc,
1008: ilm.sublot_no
1009: FROM

Line 1010: ic_lots_mst ilm

1006: SELECT ilm.lot_no,
1007: ilm.lot_desc,
1008: ilm.sublot_no
1009: FROM
1010: ic_lots_mst ilm
1011: WHERE
1012: ilm.lot_id = c_lot_id
1013: and ilm.delete_mark = 0
1014: ;

Line 1267: /* get lot no, sublot no and lot desc from ic_lots_mst */

1263: -- END IF;
1264: /* end checking if item id has a value */
1265:
1266:
1267: /* get lot no, sublot no and lot desc from ic_lots_mst */
1268: /* if pkg called from report, lot id must have value */
1269: /* else if called from opm portal, lot may be null */
1270: -- IF tbl_hdr(loop_counter).lot_id is not NULL THEN
1271: -- FOR lot_cur_rec IN get_lot_info (tbl_hdr(loop_counter).lot_id) LOOP