eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMIVDX dependencies on IC_LOTS_MST

Line 230: x_ic_lots_mst_row ic_lots_mst%ROWTYPE;

226: l_return_val NUMBER;
227: x_ic_item_mst_row ic_item_mst%ROWTYPE;
228: x_ic_whse_mst_row ic_whse_mst%ROWTYPE;
229: x_sy_reas_cds_row sy_reas_cds%ROWTYPE;
230: x_ic_lots_mst_row ic_lots_mst%ROWTYPE;
231: x_ic_loct_inv_row ic_loct_inv%ROWTYPE;
232: l_check_qty NUMBER;
233: l_org INV_Validate.org;
234: l_item INV_Validate.item;

Line 1054: SELECT * INTO x_ic_lots_mst_row

1050: log_msg('Start validating OPM lot when transfer type is 0');
1051: END IF;
1052:
1053: BEGIN
1054: SELECT * INTO x_ic_lots_mst_row
1055: FROM ic_lots_mst
1056: WHERE item_id = p_line_rec_tbl(i).opm_item_id
1057: AND lot_id = p_lot_rec_tbl(j).opm_lot_id;
1058:

Line 1055: FROM ic_lots_mst

1051: END IF;
1052:
1053: BEGIN
1054: SELECT * INTO x_ic_lots_mst_row
1055: FROM ic_lots_mst
1056: WHERE item_id = p_line_rec_tbl(i).opm_item_id
1057: AND lot_id = p_lot_rec_tbl(j).opm_lot_id;
1058:
1059: EXCEPTION

Line 1072: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;

1068:
1069: END IF;
1070:
1071:
1072: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1073: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1074: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1075: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1076:

Line 1073: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;

1069: END IF;
1070:
1071:
1072: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1073: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1074: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1075: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1076:
1077: --now lets check whether there is inventory to transfer from OPM to ODM

Line 1074: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;

1070:
1071:
1072: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1073: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1074: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1075: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1076:
1077: --now lets check whether there is inventory to transfer from OPM to ODM
1078: x_ic_loct_inv_row.whse_code := p_line_rec_tbl(i).opm_whse_code;

Line 1075: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;

1071:
1072: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1073: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1074: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1075: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1076:
1077: --now lets check whether there is inventory to transfer from OPM to ODM
1078: x_ic_loct_inv_row.whse_code := p_line_rec_tbl(i).opm_whse_code;
1079: x_ic_loct_inv_row.location := p_line_rec_tbl(i).opm_location;

Line 1093: nvl(x_ic_lots_mst_row.lot_id,0),

1089: p_lot_rec_tbl(j).opm_lot_status := x_ic_loct_inv_row.lot_status;
1090: l_return_val := GMICUOM.uom_conversion
1091: (
1092: x_ic_item_mst_row.item_id,
1093: nvl(x_ic_lots_mst_row.lot_id,0),
1094: p_lot_rec_tbl(j).quantity,
1095: p_line_rec_tbl(i).quantity_um,
1096: x_ic_item_mst_row.item_um,
1097: 0

Line 1170: nvl(x_ic_lots_mst_row.lot_id,0),

1166:
1167: l_return_val := GMICUOM.uom_conversion
1168: (
1169: x_ic_item_mst_row.item_id,
1170: nvl(x_ic_lots_mst_row.lot_id,0),
1171: p_lot_rec_tbl(j).quantity,
1172: p_line_rec_tbl(i).quantity_um,
1173: x_ic_item_mst_row.item_um2,
1174: 0

Line 1301: INTO x_ic_lots_mst_row

1297: IF (x_ic_item_mst_row.lot_ctl = 1) THEN
1298:
1299: --get the opm lot row
1300: SELECT *
1301: INTO x_ic_lots_mst_row
1302: FROM ic_lots_mst
1303: WHERE ITEM_ID = x_ic_item_mst_row.item_id
1304: AND lot_id = p_lot_rec_tbl(j).opm_lot_id;
1305:

Line 1302: FROM ic_lots_mst

1298:
1299: --get the opm lot row
1300: SELECT *
1301: INTO x_ic_lots_mst_row
1302: FROM ic_lots_mst
1303: WHERE ITEM_ID = x_ic_item_mst_row.item_id
1304: AND lot_id = p_lot_rec_tbl(j).opm_lot_id;
1305:
1306:

Line 1307: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;

1303: WHERE ITEM_ID = x_ic_item_mst_row.item_id
1304: AND lot_id = p_lot_rec_tbl(j).opm_lot_id;
1305:
1306:
1307: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1308: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1309: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1310: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1311:

Line 1308: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;

1304: AND lot_id = p_lot_rec_tbl(j).opm_lot_id;
1305:
1306:
1307: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1308: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1309: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1310: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1311:
1312: --We need this get the lot_status of the OPM lot.

Line 1309: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;

1305:
1306:
1307: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1308: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1309: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1310: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1311:
1312: --We need this get the lot_status of the OPM lot.
1313: x_ic_loct_inv_row.whse_code := p_line_rec_tbl(i).opm_whse_code;

Line 1310: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;

1306:
1307: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1308: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1309: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1310: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1311:
1312: --We need this get the lot_status of the OPM lot.
1313: x_ic_loct_inv_row.whse_code := p_line_rec_tbl(i).opm_whse_code;
1314: x_ic_loct_inv_row.location := p_line_rec_tbl(i).opm_location;