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 237: x_ic_lots_mst_row ic_lots_mst%ROWTYPE;

233: l_return_val NUMBER;
234: x_ic_item_mst_row ic_item_mst%ROWTYPE;
235: x_ic_whse_mst_row ic_whse_mst%ROWTYPE;
236: x_sy_reas_cds_row sy_reas_cds%ROWTYPE;
237: x_ic_lots_mst_row ic_lots_mst%ROWTYPE;
238: x_ic_loct_inv_row ic_loct_inv%ROWTYPE;
239: l_check_qty NUMBER;
240: l_org INV_Validate.org;
241: l_item INV_Validate.item;

Line 1061: SELECT * INTO x_ic_lots_mst_row

1057: log_msg('Start validating OPM lot when transfer type is 0');
1058: END IF;
1059:
1060: BEGIN
1061: SELECT * INTO x_ic_lots_mst_row
1062: FROM ic_lots_mst
1063: WHERE item_id = p_line_rec_tbl(i).opm_item_id
1064: AND lot_id = p_lot_rec_tbl(j).opm_lot_id;
1065:

Line 1062: FROM ic_lots_mst

1058: END IF;
1059:
1060: BEGIN
1061: SELECT * INTO x_ic_lots_mst_row
1062: FROM ic_lots_mst
1063: WHERE item_id = p_line_rec_tbl(i).opm_item_id
1064: AND lot_id = p_lot_rec_tbl(j).opm_lot_id;
1065:
1066: EXCEPTION

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

1075:
1076: END IF;
1077:
1078:
1079: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1080: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1081: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1082: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1083:

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

1076: END IF;
1077:
1078:
1079: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1080: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1081: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1082: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1083:
1084: --now lets check whether there is inventory to transfer from OPM to ODM

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

1077:
1078:
1079: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1080: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1081: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1082: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1083:
1084: --now lets check whether there is inventory to transfer from OPM to ODM
1085: x_ic_loct_inv_row.whse_code := p_line_rec_tbl(i).opm_whse_code;

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

1078:
1079: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1080: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1081: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1082: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1083:
1084: --now lets check whether there is inventory to transfer from OPM to ODM
1085: x_ic_loct_inv_row.whse_code := p_line_rec_tbl(i).opm_whse_code;
1086: x_ic_loct_inv_row.location := p_line_rec_tbl(i).opm_location;

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

1096: p_lot_rec_tbl(j).opm_lot_status := x_ic_loct_inv_row.lot_status;
1097: l_return_val := GMICUOM.uom_conversion
1098: (
1099: x_ic_item_mst_row.item_id,
1100: nvl(x_ic_lots_mst_row.lot_id,0),
1101: p_lot_rec_tbl(j).quantity,
1102: p_line_rec_tbl(i).quantity_um,
1103: x_ic_item_mst_row.item_um,
1104: 0

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

1173:
1174: l_return_val := GMICUOM.uom_conversion
1175: (
1176: x_ic_item_mst_row.item_id,
1177: nvl(x_ic_lots_mst_row.lot_id,0),
1178: p_lot_rec_tbl(j).quantity,
1179: p_line_rec_tbl(i).quantity_um,
1180: x_ic_item_mst_row.item_um2,
1181: 0

Line 1308: INTO x_ic_lots_mst_row

1304: IF (x_ic_item_mst_row.lot_ctl = 1) THEN
1305:
1306: --get the opm lot row
1307: SELECT *
1308: INTO x_ic_lots_mst_row
1309: FROM ic_lots_mst
1310: WHERE ITEM_ID = x_ic_item_mst_row.item_id
1311: AND lot_id = p_lot_rec_tbl(j).opm_lot_id;
1312:

Line 1309: FROM ic_lots_mst

1305:
1306: --get the opm lot row
1307: SELECT *
1308: INTO x_ic_lots_mst_row
1309: FROM ic_lots_mst
1310: WHERE ITEM_ID = x_ic_item_mst_row.item_id
1311: AND lot_id = p_lot_rec_tbl(j).opm_lot_id;
1312:
1313:

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

1310: WHERE ITEM_ID = x_ic_item_mst_row.item_id
1311: AND lot_id = p_lot_rec_tbl(j).opm_lot_id;
1312:
1313:
1314: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1315: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1316: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1317: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1318:

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

1311: AND lot_id = p_lot_rec_tbl(j).opm_lot_id;
1312:
1313:
1314: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1315: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1316: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1317: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1318:
1319: --We need this get the lot_status of the OPM lot.

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

1312:
1313:
1314: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1315: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1316: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1317: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1318:
1319: --We need this get the lot_status of the OPM lot.
1320: x_ic_loct_inv_row.whse_code := p_line_rec_tbl(i).opm_whse_code;

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

1313:
1314: p_lot_rec_tbl(j).opm_lot_no := x_ic_lots_mst_row.lot_no;
1315: p_lot_rec_tbl(j).opm_sublot_no := x_ic_lots_mst_row.sublot_no;
1316: p_lot_rec_tbl(j).opm_grade := x_ic_lots_mst_row.qc_grade;
1317: p_lot_rec_tbl(j).opm_lot_expiration_date := x_ic_lots_mst_row.expire_date;
1318:
1319: --We need this get the lot_status of the OPM lot.
1320: x_ic_loct_inv_row.whse_code := p_line_rec_tbl(i).opm_whse_code;
1321: x_ic_loct_inv_row.location := p_line_rec_tbl(i).opm_location;