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.GMO_VBATCH_TASK_PVT dependencies on MTL_LOT_NUMBERS

Line 1061: l_mtl_lot_num_rec mtl_lot_numbers%ROWTYPE;

1057:
1058: l_mtl_txn_rec mtl_transactions_interface%ROWTYPE;
1059: l_mtl_lot_rec mtl_transaction_lots_interface%ROWTYPE;
1060: l_mtl_lot_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
1061: l_mtl_lot_num_rec mtl_lot_numbers%ROWTYPE;
1062: l_lot_expiration_date DATE;
1063: l_orig_date DATE;
1064: CURSOR c_fetch_lot_attributes(cp_lot_number mtl_lot_numbers.lot_number%TYPE,
1065: cp_organization_id mtl_lot_numbers.organization_id%TYPE,

Line 1064: CURSOR c_fetch_lot_attributes(cp_lot_number mtl_lot_numbers.lot_number%TYPE,

1060: l_mtl_lot_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
1061: l_mtl_lot_num_rec mtl_lot_numbers%ROWTYPE;
1062: l_lot_expiration_date DATE;
1063: l_orig_date DATE;
1064: CURSOR c_fetch_lot_attributes(cp_lot_number mtl_lot_numbers.lot_number%TYPE,
1065: cp_organization_id mtl_lot_numbers.organization_id%TYPE,
1066: cp_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE) IS
1067: SELECT * FROM mtl_lot_numbers
1068: WHERE lot_number=cp_lot_number

Line 1065: cp_organization_id mtl_lot_numbers.organization_id%TYPE,

1061: l_mtl_lot_num_rec mtl_lot_numbers%ROWTYPE;
1062: l_lot_expiration_date DATE;
1063: l_orig_date DATE;
1064: CURSOR c_fetch_lot_attributes(cp_lot_number mtl_lot_numbers.lot_number%TYPE,
1065: cp_organization_id mtl_lot_numbers.organization_id%TYPE,
1066: cp_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE) IS
1067: SELECT * FROM mtl_lot_numbers
1068: WHERE lot_number=cp_lot_number
1069: AND organization_id= cp_organization_id

Line 1066: cp_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE) IS

1062: l_lot_expiration_date DATE;
1063: l_orig_date DATE;
1064: CURSOR c_fetch_lot_attributes(cp_lot_number mtl_lot_numbers.lot_number%TYPE,
1065: cp_organization_id mtl_lot_numbers.organization_id%TYPE,
1066: cp_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE) IS
1067: SELECT * FROM mtl_lot_numbers
1068: WHERE lot_number=cp_lot_number
1069: AND organization_id= cp_organization_id
1070: AND inventory_item_id = cp_inventory_item_id ;

Line 1067: SELECT * FROM mtl_lot_numbers

1063: l_orig_date DATE;
1064: CURSOR c_fetch_lot_attributes(cp_lot_number mtl_lot_numbers.lot_number%TYPE,
1065: cp_organization_id mtl_lot_numbers.organization_id%TYPE,
1066: cp_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE) IS
1067: SELECT * FROM mtl_lot_numbers
1068: WHERE lot_number=cp_lot_number
1069: AND organization_id= cp_organization_id
1070: AND inventory_item_id = cp_inventory_item_id ;
1071:

Line 1395: l_lot_rec mtl_lot_numbers%ROWTYPE;

1391: ,x_message_count OUT NOCOPY NUMBER
1392: ,x_message_data OUT NOCOPY VARCHAR2
1393: )
1394: IS
1395: l_lot_rec mtl_lot_numbers%ROWTYPE;
1396: l_char_tbl inv_lot_api_pub.char_tbl;
1397: l_number_tbl inv_lot_api_pub.number_tbl;
1398: l_date_tbl inv_lot_api_pub.date_tbl;
1399: BEGIN

Line 1538: select gen_object_id into x_lot_event_key from mtl_lot_numbers

1534: )
1535: IS
1536: BEGIN
1537:
1538: select gen_object_id into x_lot_event_key from mtl_lot_numbers
1539: where organization_id = p_organization_id
1540: and inventory_item_id = p_inventory_item_id
1541: and lot_number = p_lot_number;
1542:

Line 1711: FROM mtl_lot_numbers

1707: x_return_status := FND_API.G_RET_STS_SUCCESS;
1708: BEGIN /*begin segment 2 */
1709: SELECT Nvl(origination_date,p_transaction_date)
1710: INTO x_orig_date
1711: FROM mtl_lot_numbers
1712: WHERE inventory_item_id = p_inventory_item_id
1713: AND lot_number = p_lot_number
1714: AND organization_id = p_organization_id;
1715: EXCEPTION