APPS.GME_MOBILE_TXN dependencies on MTL_LOT_NUMBERS

Line 1399: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api

1395: IS
1396: l_return_status VARCHAR2(1) ;
1397: l_msg_data VARCHAR2(3000) ;
1398: l_msg_count NUMBER ;
1399: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api
1400: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api
1401: l_api_version NUMBER;
1402: l_init_msg_list VARCHAR2(100);
1403: l_commit VARCHAR2(100);

Line 1400: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api

1396: l_return_status VARCHAR2(1) ;
1397: l_msg_data VARCHAR2(3000) ;
1398: l_msg_count NUMBER ;
1399: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api
1400: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE; -- for lot api
1401: l_api_version NUMBER;
1402: l_init_msg_list VARCHAR2(100);
1403: l_commit VARCHAR2(100);
1404: l_validation_level NUMBER;

Line 1411: FROM mtl_lot_numbers

1407:
1408: /* Cursor to check if a lot already exists*/
1409: CURSOR c_lot_exists IS
1410: SELECT 1
1411: FROM mtl_lot_numbers
1412: WHERE organization_id = p_org_id
1413: AND inventory_item_id = p_inventory_item_id
1414: AND lot_number = p_lot_number ;
1415:

Line 2072: mtl_lot_numbers n

2068: FROM
2069: gme_pending_product_lots l,
2070: mtl_transaction_reasons r,
2071: gme_material_details m, -- nsinghi bug#5236906. Add join to gme_material_details and MLN
2072: mtl_lot_numbers n
2073: WHERE
2074: l.batch_id = p_batch_id AND
2075: l.material_detail_id = p_material_detail_id AND
2076: l.lot_number = NVL(p_lot_number, l.lot_number) AND

Line 2135: mtl_lot_numbers n

2131: FROM
2132: gme_pending_product_lots l,
2133: mtl_transaction_reasons r,
2134: gme_material_details m,
2135: mtl_lot_numbers n
2136: WHERE
2137: l.batch_id = p_batch_id AND
2138: l.material_detail_id = p_material_detail_id AND
2139: l.lot_number = NVL(p_lot_number, l.lot_number) AND